Queue operations cannot be used from within a transaction - Error in App Log RRS feed

  • Question

  • Hi Experts,

    When a team member clicks on Send Timesheet (after filling task details) in his timesheet, a CRITICAL ERROR is shown in the Application Log of the Project Server 2010. Whereas there is NO error in the "Project Web App  --> Manage Queue Jobs"

    Here are the error details copied and pasted from the app log of the Project Server:

    Standard Information:PSI Entry Point:
    Project User: xx\xxxxxx
    Correlation Id: 5b1aab07-c97d-4cd7-9918-9959a9f7e0fa
    PWA Site URL: http://xxxxxx:11115/PWA
    SSP Name: Project Server Service Application
    PSError: NoError (0)
    Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Queue operations cannot be used from within a transaction.
       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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
       at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.BeginMessageGroup(String prefix, Guid GroupUID, Guid CorrelationUID, Guid ResUID, Nullable`1 RendezvousUID, Int32 MessageType, Int32 Priority, Int32 correlationPriority, Guid ServerUID, Guid JobUID, Guid TrackingId, Guid JobInfoUID, Byte[] jobInfo, Byte[] contextInfo, Int32 wakeupTimeSeconds, Boolean forceSend)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.BeginMessageGroupSqlCall.Execute()
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

    I have seen this thread but not able to fix it on my Project Server:

    Also I have tried to change the Service Account for

    • Windows Service - Microsoft Project Server Events Serive
    • Windows Service - Microsoft Project Server Queueing Service

    Please advise the resolution to this problem.

    Thanks in advance!


    • Edited by Irish_Cool Monday, May 7, 2012 8:17 AM
    Monday, May 7, 2012 8:16 AM

All replies

  • is this issue user specific?

    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    Monday, May 7, 2012 6:43 PM
  • is this issue user specific?

    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    This is not user specific. This Critical error has been noticed for more than 4 team members while they submit their timesheet.

    They neither get any kind of error message in PWA 2010, nor there is a problem in their timesheet's data after submission. It's the only Application Log at the Project Server, which shows the CRITICAL error, once a team member clicks on "Send Timesheet" in their respective PWA 2010.


    Tuesday, May 8, 2012 6:18 AM