Queue stuck due to arithmetic overflow

J

JBG

Currently we are using MSPS 2007 with SP1.

The queue is stuck due to the following error:
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7754
Date: 01/07/2008
Time: 5:51:12 AM
User: N/A
Computer: NLHFD-PRJ031
Description:
Standard Information:pSI Entry Point:
Project User: DOMAIN1\nlhfd-prj-sa
Correlation Id: bbfb1211-401b-43cc-8df3-fd3e5383fadf
PWA Site URL: http://nlhfd-prj031/Projectserver
SSP Name: SharedServices1
PSError: Success (0)
Queue unable to interact with SQL. Queue type (Project Queue, Timesheet
Queue etc): ProjectQ Exception:
Microsoft.Office.Project.Server.BusinessLayer.Queue.QueueSqlException:
UpdateQueueStatsWaitTime failed ---> System.Data.SqlClient.SqlException:
Arithmetic overflow error converting expression to data type int.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.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.UpdateQueueStatsWaitTime(String prefix, Guid groupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.UpdateQueueStatsWaitTimeSqlCall.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.UpdateQueueStatsWaitTimeSqlCall.UpdateQueueStatsWaitTimeRetry(Guid
groupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.UpdateQueueStats(Group msgGroup, StatType statType)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.LoadThreads(Boolean& haveGroup, Int32 totalCount)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.ThreadEntry()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Unfortunately I do not know how to further debug this problem. We are not
developing our own add ons, etc. and are only working with the PWA as well
as with the various error logs.

Any assistance would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top