none
PSI: SqlException occurred in DAL RRS feed

  • Question

  • Hi,

    does anybody knows what can cause the following error? I've found some of these entries both in the application server Event Viewer and in the ULS logs (while no error was logged in the Project Server Queue):

    PWA:http://xxxxxx/pwa, ServiceApp:Project Server service App, User:XXXXXXXXXXX, PSI: SqlException occurred in DAL:  <Error><Class>1</Class><LineNumber>22</LineNumber><Number>50000</Number><Procedure>MSP_TimesheetQ_Begin_Message_Group</Procedure>  <Message>  System.Data.SqlClient.SqlError: Queue operations cannot be used from within a transaction.  </Message>  <CallStack>     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)  </CallStack>  </Error>
    Queue operation attempted with an open transaction StackTrace:   at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.BeginMessageGroupSqlCall.BeginMessageGroupRetry(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, TimeSpan wakeupTime, Boolean forceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.BeginMessageGroup(Group msgGroup, Guid serverUID, JobTicket jobTicket, TimeSpan wakeupTime, Boolean forceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, CorrelationPriority correlationPriority, Guid correlationId, Nullable`1 rendezvousUID, JobTicket jobTicket, Nullable`1 nwakeupTime, Nullable`1 nforceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, Guid correlationId)     at Microsoft.Office.Project.Server.BusinessLayer.QueueSystem.SendNotificationMessage(PlatformContext clientContext, NotificationData notificationData)     at Microsoft.Office.Project.Server.BusinessLayer.Notifications.InternalSendAlert(NotificationData notificationData, Boolean applySubscriptionMatching)     at Microsoft.Office.Project.Server.BusinessLayer.Notifications.SendNotifications(CompositeNotificationBuilder compositeNotificationBuilder, Boolean applySubscriptionMatching)   at Microsoft.Office.Project.Server.BusinessLayer.Statusing.SubmitStatusWithResult(Guid resid, Guid[] updateGuids, String comment)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.SubmitTimesheetLines(Guid[] timesheetLines, String comment, Boolean validateLines)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.<>c__DisplayClass5.<SubmitTimesheetImpl>b__3()     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectServerDatabaseTransaction.RunInTransaction(ProjectServerDatabaseTransaction transaction, TransactionCodeDelegate transactionedCode)     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectServerDatabaseTransaction.Run(PlatformContext context, DataStoreEnum store, String transactionName, TransactionCodeDelegate transactionedCode)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.SubmitTimesheetImpl(JobTicket jobTicket, MessageContext mContext, Guid tsUID, Guid approverUID, String comment)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessTimesheetMessage.HandleMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessMessageMultiplexer.HandleMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessMessageThread.ThreadEntry()     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)     at System.Threading.ThreadHelper.ThreadStart() 

    Thank you.

    Monday, November 29, 2010 5:00 PM

Answers

  • Hi Omar,

    I had a similar problem, that was not linked to the error in this post.

    The message you reported showed up in the Approval Center, while approving Tasks (not Timesheet). The cause of the message was the presence of links on Summary tasks. We removed the link, republished the project and the view loaded correctly.

    Hope this helps.

    Fabrizio.

    Monday, December 13, 2010 9:33 PM

All replies

  • Hi,

     

    Are you having any other issues?  I think I have seen this before relating to the reporting database.  Check that the OLAP Cube is building correctly and that you have not issues with any SQL reports that you maybe creating.

     

    Do you have any customisation by any chance?

     

    Regards,

    Dharmesh Patel


    Best Regards, Dharmesh Patel www.dharmeshpatel.co.uk
    • Proposed as answer by Dharm Patel Tuesday, November 30, 2010 5:06 AM
    Monday, November 29, 2010 6:48 PM
  • Hi Dharmesh,

    no, there aren't any customisation in place and the Cube builds successfully.

    The only strange thing I can report is that a couple of users told that after they submitted their timesheets they found out actual hours had disappeared and they have to re-fill and submit the timesheet again.

    Regards.

    Wednesday, December 1, 2010 8:49 AM
  • Hi,

    I would review the event log on your servers and also the ULS logs (http://technet.microsoft.com/en-us/library/cc627255%28office.12%29.aspx).

     

    Do you have any jobs stuck in your project server queue?

     

    Let me know if I can help any further.

     

    Regards,


    Best Regards, Dharmesh Patel www.dharmeshpatel.co.uk
    Wednesday, December 1, 2010 9:46 AM
  • The queue didnt show any error (which I found quite strange).

    The Event Viewer reported this error (which was also in the ULS log, after the one I reported in my first post):

    Standard Information:PSI Entry Point:   Project User: XXXX Correlation Id: aa16003e-e376-436a-90d5-4f8721ecf4d3  PWA Site URL: http://XXXX  SSP Name: Project Server service App  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.Begin MessageGroup(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()

    Another error shown in the ULS log was the following:

    Queue operation attempted with an open transaction StackTrace:   at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.BeginMessageGroupSqlCall.BeginMessageGroupRetry(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, TimeSpan wakeupTime, Boolean forceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.BeginMessageGroup(Group msgGroup, Guid serverUID, JobTicket jobTicket, TimeSpan wakeupTime, Boolean forceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, CorrelationPriority correlationPriority, Guid correlationId, Nullable`1 rendezvousUID, JobTicket jobTicket, Nullable`1 nwakeupTime, Nullable`1 nforceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, Guid correlationId)     at Microsoft.Office.Project.Server.BusinessLayer.QueueSystem.SendNotificationMessage(PlatformContext clientContext, NotificationData notificationData)     at Microsoft.Office.Project.Server.BusinessLayer.Notifications.InternalSendAlert(NotificationData notificationData, Boolean applySubscriptionMatching)     at Microsoft.Office.Project.Server.BusinessLayer.Notifications.SendNotifications(CompositeNotificationBuilder compositeNotificationBuilder, Boolean applySubscriptionMatching) at Microsoft.Office.Project.Server.BusinessLayer.Statusing.SubmitStatusWithResult(Guid resid, Guid[] updateGuids, String comment)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.SubmitTimesheetLines(Guid[] timesheetLines, String comment, Boolean validateLines)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.<>c__DisplayClass5.<SubmitTimesheetImpl>b__3()     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectServerDatabaseTransaction.RunInTransaction(ProjectServerDatabaseTransaction transaction, TransactionCodeDelegate transactionedCode)     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectServerDatabaseTransaction.Run(PlatformContext context, DataStoreEnum store, String transactionName, TransactionCodeDelegate transactionedCode)     at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.SubmitTimesheetImpl(JobTicket jobTicket, MessageContext mContext, Guid tsUID, Guid approverUID, String comment)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessTimesheetMessage.HandleMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessMessageMultiplexer.HandleMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessMessageThread.ThreadEntry()     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)     at System.Threading.ThreadHelper.ThreadStart() 

    And finally, there was this one:

    PWA:http://XXXXX, ServiceApp:Project Server service App, User:XXXXX, PSI: Failed to queue the Notification message CompositeNotification. Messaage body: Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.CompositeNotification. Error: Microsoft.Office.Project.Server.BusinessLayer.Queue.QueueSqlException: BeginMessageGroup failed ---> 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()     --- 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.SqlCallRetry.BeginMessageGroupSqlCall.BeginMessageGroupRetry(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, TimeSpan wakeupTime, Boolean forceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.BeginMessageGroup(Group msgGroup, Guid serverUID, JobTicket jobTicket, TimeSpan wakeupTime, Boolean forceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, CorrelationPriority correlationPriority, Guid correlationId, Nullable`1 rendezvousUID, JobTicket jobTicket, Nullable`1 nwakeupTime, Nullable`1 nforceSend)     at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, Guid correlationId)     at Microsoft.Office.Project.Server.BusinessLayer.QueueSystem.SendNotificationMessage(PlatformContext clientContext, NotificationData notificationData).

    Unfortunately none of these is really giving me any help...

     

    Wednesday, December 1, 2010 10:55 AM
  • Ah - one thought - what version of the product are you using?

    Something that was in the second message was "Failed to queue the Notification message CompositeNotification"

    If 2007 - have you configured the email notification settings properly?

    If 2010 - are you using the exchange addin?

     

    Regards,

    Dharmesh


    Best Regards, Dharmesh Patel www.dharmeshpatel.co.uk
    Wednesday, December 1, 2010 11:43 AM
  • 2010 with Exchange integration configured.

    Fabrizio.

    Wednesday, December 1, 2010 12:00 PM
  • Is that all working ok?  Are alters being sent / received / communicated back ok?

    Regards,

    Dharmesh


    Best Regards, Dharmesh Patel www.dharmeshpatel.co.uk
    Friday, December 3, 2010 7:56 PM
  • Hi Dharm,

    We are in the same situation as fb75. Getting following errors in ULS log:

    Queue operation attempted with an open transaction StackTrace:

    at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.BeginMessageGroupSqlCall.BeginMessageGroupRetry(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, TimeSpan wakeupTime, Boolean forceSend)

    at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.BeginMessageGroup(Group msgGroup, Guid serverUID, JobTicket jobTicket, TimeSpan wakeupTime, Boolean forceSend)

    at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, CorrelationPriority correlationPriority, Guid correlationId, Nullable`1 rendezvousUID, JobTicket jobTicket, Nullable`1 nwakeupTime, Nullable`1 nforceSend)

    at Microsoft.Office.Project.Server.BusinessLayer.Queue.Sender.BeginMessageGroup(QueueMsgType messageType, QueueMsgPriority priority, Guid correlationId)

    at Microsoft.Office.Project.Server.BusinessLayer.QueueSystem.SendNotificationMessage(PlatformContext clientContext, NotificationData notificationData)

    at Microsoft.Office.Project.Server.BusinessLayer.Notifications.InternalSendAlert(NotificationData notificationData, Boolean applySubscriptionMatching)

    at Microsoft.Office.Project.Server.BusinessLayer.Notifications.SendNotifications(CompositeNotificationBuilder compositeNotificationBuilder, Boolean applySubscriptionMatching)

    at Microsoft.Office.Project.Server.BusinessLayer.Statusing.SubmitStatusWithResult(Guid resid, Guid[] updateGuids, String comment)

    at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.SubmitTimesheetLines(Guid[] timesheetLines, String comment, Boolean validateLines)

    at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.<>c__DisplayClass5.<SubmitTimesheetImpl>b__3()

    at Microsoft.Office.Project.Server.DataAccessLayer.ProjectServerDatabaseTransaction.RunInTransaction(ProjectServerDatabaseTransaction transaction, TransactionCodeDelegate transactionedCode)

    at Microsoft.Office.Project.Server.DataAccessLayer.ProjectServerDatabaseTransaction.Run(PlatformContext context, DataStoreEnum store, String transactionName, TransactionCodeDelegate transactionedCode)

    at Microsoft.Office.Project.Server.BusinessLayer.TimeSheet.SubmitTimesheetImpl(JobTicket jobTicket, MessageContext mContext, Guid tsUID, Guid approverUID, String comment)

    at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessTimesheetMessage.HandleMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)

    at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessMessageMultiplexer.HandleMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)

    at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessMessageThread.ThreadEntry()

    at System.Threading.ExecutionContext.runTryCode(Object userData)

    at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)

    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

    at System.Threading.ThreadHelper.ThreadStart()

     

    Standard Information:PSI Entry Point: Project User: ITSQ\dfasone Correlation Id: 60b95fc7-07e7-4d84-90b1-7e95870868e6 PWA Site URL: http://project/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()

     

    Any ideas about what can be causing this?

     

    Thanks

    Wednesday, December 8, 2010 6:27 AM
  • Here are pointers to troubleshoot:

    - Timesheets - are these processing without any issues?

    - Notifications - are these running ok?  Are you using the Exchange Add-in?  Does this work ok?


    Without actually seeing the environment and having the ability to do a health check myself, I am sorry I am not able to provide you with further input.

    Please do come back to me if you find out anything further on the two points above, I will try my best to help you.

    Regards,

     

    Dharmesh


    Best Regards, Dharmesh Patel www.dharmeshpatel.co.uk
    Wednesday, December 8, 2010 11:42 AM
  • Hi, from my point of view, the error seems to appear each time a Timesheet is saved and submitted (don't know exactly if it happens when saved or just after submission). Anyway, the queue doesn't show any error and the users havent reported any problem. The system is configured with SEM enabled, so the timesheet submission also fires the tasks submission to PMs. Which kind of notifications should the users receive in this case? Fabrizio.
    Wednesday, December 8, 2010 1:06 PM
  • It terms of notification, you would get an e-mail alert if this was configured or on the PWA home page where there is a summary.

    I would review your ULS logs for further information on this issue to see if there is any other useful information in this error.

    Regards,


    Best Regards, Dharmesh Patel www.dharmeshpatel.co.uk
    Thursday, December 9, 2010 1:43 PM
  • Hey FB . did you find any solution of this issue . I am getting the same errors in ULS .

     When user click on approval center on PWA site ,  can not view the updates under time sheet approval.   they get failuare message " the view failed to load .press ok to reload this view with the defaulet settings . press cancel to select another view "  any help ?

    Monday, December 13, 2010 6:21 PM
  • Hi Omar,

    I had a similar problem, that was not linked to the error in this post.

    The message you reported showed up in the Approval Center, while approving Tasks (not Timesheet). The cause of the message was the presence of links on Summary tasks. We removed the link, republished the project and the view loaded correctly.

    Hope this helps.

    Fabrizio.

    Monday, December 13, 2010 9:33 PM
  • Hey FB thanks for pointing me in to the right direction. You are right it was a different issue.

    I am still having the issue mention on the top in this thread. Have you find any solution yet? Thanks

     

    Standard Information:PSI Entry Point:

    Project User: username

    Correlation Id: 73e8dd35-15e4-42b9-b5fb-e90abdcca3de

    PWA Site URL: project site /PWA

    SSP Name: Project 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()

    Monday, January 31, 2011 8:28 PM
  • I am also seeing this in my Event Logs A LOT!!!!.  I do not have the Exchange configured.

    I did a quick filter on my eventlog and see that between 1/7/2011 and 2/11/2011 this has happened 2,507 times.  Each time seems to be with a different user.

    Has anyone come up wiht a good list of things to check?

    Thanks,

    Jay

     


    Jay Smith
    Friday, February 11, 2011 3:24 PM
  • Have you applied the February CU yet? I believe these errors should go away with it.

    Sunday, April 3, 2011 11:33 PM
  • Has anyone resolved 7758 yet?  I don't see any clear answers other than try the Feb CU.
    *Jen*
    Tuesday, June 7, 2011 4:06 PM
  • Anybody solved this yet.. I am on Proj 2010 Feb 2014 CU..Still happening...
    Wednesday, April 9, 2014 5:59 PM
  • Same problems here!
    Friday, October 10, 2014 8:34 AM