Error ID: 12005 Job Type: Save
Sara
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>
Chak
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
On Feb 2, 2:02 pm, Sara <S...@discussions.microsoft.com> wrote:
> 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