save job failed & blocking with error: ActiveCacheQueuedMessageEx

R

R Halbach

Hello:

I have a user saving a project the goes to failed & blocking state in the
Project 2007 Server queue. I've tried several times to 'retry', but the
result is the same. The error message is
ActiveCacheQueuedMessageExecutionError. Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_FRONT_END'.

the full message text is below. I would appreciate any help that you can
offer on this issue.

Ruth
Error summary/areas:
ActiveCacheQueuedMessageExecutionError
ActiveCacheQueuedMessageExecutionError
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="e25837a9-90ca-46ad-a701-5e49f5687a1e"
error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY
constraint 'PK_MSP_PROJECT_FRONT_END'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_FRONT_END'.
The statement has been terminated.
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.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.WinProjDal.ExecuteStoredProcedure(String spName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjUtility.ExecuteP12QueueableSPCommand(WinProjTraceContext
wpTraceContext, DataStoreEnum store, P12QueueableSPCommand command, Boolean
retry, Boolean useTransaction)
at
Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjQueueMessageDispatcher.DispatchMessage(ACMessage
acMessage, Message msg, Group messageGroup, JobTicket jobTicket,
MessageContext mContext)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="148504e9-a082-4a27-9ab1-00f6c637af99"
JobUID="7e398f7f-d443-4333-887c-cb5681a86183" ComputerName="ETC-MSP-01"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="114" Stage="" />
</class>
</general>
</errinfo>
 
M

Martin Laukkanen

Hi,

Although I have never seen that specific message before I would suggest
trying the following things to correct this issue:
1. Check and cancel any blocked jobs in the queue (ensure first to select
ALL dates, as by default you will not see old blocked jobs)
2. Retry the save operation from the client - this would be preferred to
using Retry in the queue if something else is blocking it.


Otherwise having a quick look at that MSP_PROJECT_FRONT_END table mentioned
in the error it would seem that table contains a list of all Project Pro
views associated with all projects, have you recently made any changes to the
views in that particular project? You might like to try and undo those
changes by using the organiser and removing your custom view before trying to
save.

HTH,

--
Martin Laukkanen
See my Blog: http://www.nearbaseline.com/blog/


R Halbach said:
Hello:

I have a user saving a project the goes to failed & blocking state in the
Project 2007 Server queue. I've tried several times to 'retry', but the
result is the same. The error message is
ActiveCacheQueuedMessageExecutionError. Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_FRONT_END'.

the full message text is below. I would appreciate any help that you can
offer on this issue.

Ruth
Error summary/areas:
ActiveCacheQueuedMessageExecutionError
ActiveCacheQueuedMessageExecutionError
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="e25837a9-90ca-46ad-a701-5e49f5687a1e"
error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY
constraint 'PK_MSP_PROJECT_FRONT_END'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_FRONT_END'.
The statement has been terminated.
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.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.WinProjDal.ExecuteStoredProcedure(String spName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjUtility.ExecuteP12QueueableSPCommand(WinProjTraceContext
wpTraceContext, DataStoreEnum store, P12QueueableSPCommand command, Boolean
retry, Boolean useTransaction)
at
Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjQueueMessageDispatcher.DispatchMessage(ACMessage
acMessage, Message msg, Group messageGroup, JobTicket jobTicket,
MessageContext mContext)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="148504e9-a082-4a27-9ab1-00f6c637af99"
JobUID="7e398f7f-d443-4333-887c-cb5681a86183" ComputerName="ETC-MSP-01"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="114" Stage="" />
</class>
</general>
</errinfo>
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

Error ID: 12005 Job Type: Save 1
PS 2007 SP1 - Save job failing, cancelling, and restarting at 7% 3
ACProjectSave failed 4
Save job failed on PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES 1
Errors 12005 and 26000 in PS 2007 2
Unable to access to the "Force Check-in Enterprise Objects 4
Exception when using PWA Services: MSP_SSP_UPDATE_ENTERPRISE_ENTIT 0
Cube Not Building 2

Top