none
Event ID 7754, 7761 and 7758 RRS feed

  • Question

  • I’m using Project Server 2010 on Windows 2008 R2. The event log is constantly filling up with 7758, 7761 and 7754 errors. The error has something to do with my project server account and the queue. This is a 7754 error:

    Standard Information:PSI Entry Point:

    Project User: Domain\account

    Correlation Id: aa5ebc1a-1f6e-49da-b2bd-52d3a2a70115

    PWA Site URL: http://msprojectdev/PWA

    SSP Name: Project Web App Service

    PSError: NoError (0)

    Queue unable to interact with SQL. Queue type

     

    I tried this fix, http://support.microsoft.com/kb/2000241/en-us, but this is not my issue.

     

    Thanks in advance

    Tuesday, September 7, 2010 3:05 PM

Answers

All replies

  • Hi,

    I have never seen that before. But you could have a look at http://blogs.msdn.com/b/brismith/archive/2007/02/28/my-queue-is-stuck-how-to-manage-your-queue-service-in-project-server-2007.aspx, KH (and someone else) is describing a similar issue in comments and how he was able to resolve - currently on page 4 or 5.

    Good luck
    Barbara

    Tuesday, September 7, 2010 5:17 PM
    Moderator
  • I have the same errors:The event log is constantly filling up with 7758, 7761 ,7754and 2424 errors.but I haven't found the problems. Are you resolve these now?

    Monday, September 27, 2010 2:13 AM
  • Still having the same issue.
    Tuesday, January 4, 2011 3:03 PM
  • I'm having the same problems with my server. Could you resolve the problem?
    Thursday, January 6, 2011 1:39 PM
  • Are you still having this issue or did you resolve it?  If you are still getting the errors can you also provide the information in the other two errors?  Is this a standalone installation of Project server?  Did you have any initial issues with deployment?  Thanks in advance.
    Travis
    • Edited by TravisA Wednesday, November 23, 2011 2:46 AM
    Tuesday, November 22, 2011 10:05 PM
  • Hello Barabra, 

    I am facing the following problems in project server 2010 on windows server 2008 R2

    "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()


    Error No 2

    Error ID-7758
    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 SQL call failed. Error: 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()"

    Thnaks

    Ankush Bhatia

    Microsoft Partners 

    Tuesday, October 23, 2012 6:53 AM
  • Anybody solved this problem?

    Tuesday, April 8, 2014 2:43 PM