none
ERROR invalid resource lock is passed to XP_userlock.Unable to interact with SQL RRS feed

  • Question

  • Error No 1.\

    error ID 7754

    Overall description= "unable to ineract with SQL".
                          "an invalid lockresources passed to XP_userlock"


    Stacktrace-- Standard Information:PSI Entry Point: 
    Project User: CORP\epmadmin
    Correlation Id: 570c65f7-ab91-471a-b02d-44e608cd56cc
    PWA Site URL: http://infhydcepmwfe/PWA
    SSP Name: project_server_2010
    PSError: NoError (0)
    Queue unable to interact with SQL. Queue type (Project Queue, Timesheet Queue etc): ProjectQ Exception: Microsoft.Office.Project.Server.BusinessLayer.Queue.QueueSqlException: LockNextAvailableGroup failed ---> System.Data.SqlClient.SqlException: An invalid application lock resource was passed to xp_userlock.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(Boolean allowCache, DataSet typedDataSet, String[] tables, SqlCommand sqlCommand, Boolean enforceConstraints)
       at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.LockNextAvailableGroup(String prefix, Guid ServerUID)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.LockNextAvailableGroupSqlCall.Execute()
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.GetNextGroup(Group& msgGroup, JobTicket& jobTicket, Guid serverUID)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.LoadProcessorThreads(Boolean& haveGroup, Int32 totalCount)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.LoadThreads(Boolean& haveGroup, Int32 totalCount)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.ThreadEntry()
    Tuesday, October 23, 2012 6:32 AM

All replies

  • Hello,

    What version of SQL Server you use?

    Consider making a manual intervention in the database via script adding the necessary services.

    Reference:

    http://msdn.microsoft.com/en-us/library/ms143799.aspx

    I hope I helped


    Hezequias Vasconcelos

    Tuesday, October 23, 2012 10:59 AM
  • Hi there,

    PWA was working before? Is this new installtion?

    Do you recall any chnages made on SQL server or network configuration?


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Tuesday, October 23, 2012 3:30 PM
    Moderator
  • Hello HS

    i am using  SQL server 2008 R2 enterise eddition.Please provide the details to resolve the error.it is emergency

    thanks 

    regards


    piyush mishra

    Monday, October 29, 2012 6:23 AM
  • Dear Hrishi;

    this is not new installation.Error is arising on existing Installation. PWA is working fine .

    Can you please provide the solution  as soon as possible 

    thanks 

    Regards


    piyush mishra


    • Edited by Mratunjay Monday, October 29, 2012 7:41 AM
    Monday, October 29, 2012 6:26 AM
  • Hello have you solved the problem?

    I'm also experiencing the same thing.

    Thanks,

    Mark

    Monday, January 7, 2013 1:41 AM
  • Anyone solved the problem?

    I'm also experiencing the same thing.

    Thanks,

    Mahi

    Wednesday, June 5, 2013 2:17 PM