Error ID: 12005 Job Type: Save

S

Sara

We are getting the following message on about 3 projects. In addition to
this, these 3 projects never Check-In. The check-in job never even appears
in the queue with a "waiting to be processed" or "blocked by failed job"
status as it typically seen. I am not certain if they were all created from
a specific template or not. I do know they were created by the same person.
Any help would be greatly appreciated!

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="6b2422e3-1d82-47ab-bb58-47a416054ebe"
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.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.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="6a5b5abf-735b-4957-b54e-e83b588517a1"
JobUID="7fabc7c6-49b5-4c32-ac73-753918302c26" ComputerName="MSAPPPROJECT01"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="61" Stage=""/>
</class>
</general>
</errinfo>
 
C

Chak

Hi Sara,

This error might be related to currupt local cache on project
professional. I suggest do the following steps:

1) Cancel the queue jobs related to this project plan

2) Fix the cache issue on computer from where project was published

http://www.epmcentral.com/msproject/corruptcache.php

3) Open project plan and publish

4) Monitor the queue to make sure, it published successfully.

Thanks
Chak
pVector Technologies
http://www.epmcentral.com



We are getting the following message on about 3 projects.  In addition to
this, these 3 projects never Check-In.  The check-in job never even appears
in the queue with a "waiting to be processed" or "blocked by failed job"
status as it typically seen.  I am not certain if they were all createdfrom
a specific template or not.  I do know they were created by the same person.  
Any help would be greatly appreciated!

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
        <general>
                <class name="ActiveCacheQueuedMessageExecutionError">
                        <error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="6b2422e3-1d82-47ab-bb58-47a416054ebe"
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.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
   at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje­ct
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.ExecuteStoredPro­cedureNoResult(String storedProcedureName, SqlParameter[] parameters)
   at
Microsoft.Office.Project.Server.DataAccessLayer.WinProjDal.ExecuteStoredPro­cedure(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.WinProjQueueMe­ssageDispatcher.DispatchMessage(ACMessage
acMessage, Message msg, Group messageGroup, JobTicket jobTicket,
MessageContext mContext)"/>
                </class>
                <class name="Queue">
                        <error id="26000" name="GeneralQueueJobFailed"
uid="6a5b5abf-735b-4957-b54e-e83b588517a1"
JobUID="7fabc7c6-49b5-4c32-ac73-753918302c26" ComputerName="MSAPPPROJECT01"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="61" 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

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

Top