Cube Not Building

D

Deve

Project Server 2007 without SP1 with multiple instances on it. Hosted on 4
servers with Web, App, Db & SQL AS.

One account is used to configure the system & that same account is part of
SQL AS admin group.

Data Analysis cube is not building on one of the instance, while it is
building on the other one. Build time are different on both instances.

It is giving this error in "Cube Build Status" page:

===== Initiating cube build process =====
[9/3/2008 12:16 PM] Cube build request message has been added to the Project
Server queue

Another strange thing on this instance is that all the PROJECT queue
requests go into "Waiting To Be Processed" state. All TIMESHEET queue
requests are processing correctly.

On App server we get these errors:

EV Log 1:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7754
Date: 9/3/2008
Time: 1:26:45 PM
User: N/A
Computer: servername
Description:
Standard Information:pSI Entry Point:
Project User: Domain\ID
Correlation Id: 5e6799ff-2ba3-46b7-9257-d5477cfdde94
PWA Site URL: http://servername/PWA
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.


EV Log 2:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7761
Date: 9/3/2008
Time: 1:26:45 PM
User: N/A
Computer: Servername
Description:
Standard Information:pSI Entry Point:
Project User: Domain\ID
Correlation Id: 5e6799ff-2ba3-46b7-9257-d5477cfdde94
PWA Site URL: http://Servername/PWA
SSP Name: SharedServices1
PSError: Success (0)
An unxpected exception occurred in the Project Server Queue. Queue type
(Project Queue/Timesheet Queue): ProjectQ. Exception details:
UpdateQueueStatsWaitTime failed.

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


EV Log 3:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 9/3/2008
Time: 1:26:45 PM
User: N/A
Computer: ServerName
Description:
Standard Information:pSI Entry Point:
Project User: Domain\ID
Correlation Id: 5e6799ff-2ba3-46b7-9257-d5477cfdde94
PWA Site URL: http://ServerName/PWA
SSP Name: SharedServices1
PSError: Success (0)
Queue SQL call failed. Error: 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()

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

KH

Hi Deve,

I'm having the smae problem on me QA server for Project Server 2007. Have
you figured out the cause and resolution?

KH

Deve said:
Project Server 2007 without SP1 with multiple instances on it. Hosted on 4
servers with Web, App, Db & SQL AS.

One account is used to configure the system & that same account is part of
SQL AS admin group.

Data Analysis cube is not building on one of the instance, while it is
building on the other one. Build time are different on both instances.

It is giving this error in "Cube Build Status" page:

===== Initiating cube build process =====
[9/3/2008 12:16 PM] Cube build request message has been added to the Project
Server queue

Another strange thing on this instance is that all the PROJECT queue
requests go into "Waiting To Be Processed" state. All TIMESHEET queue
requests are processing correctly.

On App server we get these errors:

EV Log 1:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7754
Date: 9/3/2008
Time: 1:26:45 PM
User: N/A
Computer: servername
Description:
Standard Information:pSI Entry Point:
Project User: Domain\ID
Correlation Id: 5e6799ff-2ba3-46b7-9257-d5477cfdde94
PWA Site URL: http://servername/PWA
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.


EV Log 2:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7761
Date: 9/3/2008
Time: 1:26:45 PM
User: N/A
Computer: Servername
Description:
Standard Information:pSI Entry Point:
Project User: Domain\ID
Correlation Id: 5e6799ff-2ba3-46b7-9257-d5477cfdde94
PWA Site URL: http://Servername/PWA
SSP Name: SharedServices1
PSError: Success (0)
An unxpected exception occurred in the Project Server Queue. Queue type
(Project Queue/Timesheet Queue): ProjectQ. Exception details:
UpdateQueueStatsWaitTime failed.

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


EV Log 3:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 9/3/2008
Time: 1:26:45 PM
User: N/A
Computer: ServerName
Description:
Standard Information:pSI Entry Point:
Project User: Domain\ID
Correlation Id: 5e6799ff-2ba3-46b7-9257-d5477cfdde94
PWA Site URL: http://ServerName/PWA
SSP Name: SharedServices1
PSError: Success (0)
Queue SQL call failed. Error: 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()

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

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

Similar Threads

save job failed & blocking with error: ActiveCacheQueuedMessageEx 1
Error ID: 12005 Job Type: Save 1
Unable to access to the "Force Check-in Enterprise Objects 4
Queue stuck due to arithmetic overflow 0
Issues in Project Server 2007 2
PS 2007 SP1 - Save job failing, cancelling, and restarting at 7% 3
Exception when using PWA Services: MSP_SSP_UPDATE_ENTERPRISE_ENTIT 0
ACProjectSave failed 4

Top