Error 12005 in MSP 2007

A

asadim

One of our PS Project Managers have complained that this is what he got from
PS in his email after trying to publish his project:

Subject: Your queue job ACProjectSave failed. Please contact your
administrator for assistance

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="a2c6ea80-7a24-4caf-8599-e9446beb7db2"
error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY
constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
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="1f22af26-8a66-438f-865d-25c63d3333c9"
JobUID="43641875-433c-4f00-bb5e-5b2f69435a5f" ComputerName="VANMSEVAL02"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="5" Stage="" />
</class>
</general>
</errinfo>

I have no single idea what the problem might be from! It'd be appreciated if
someone could advise on how to resolve this.
 
D

Dale Howard [MVP]

asadim --

You definitely need to repost this message in the Project Server newsgroup
at microsoft.public.project.server newsgroup, as this newsgroup is devoted
to the Microsoft Project desktop application only. Your problem describes a
serious technical issue, and of late, Microsoft staff from the Project team
have been monitoring the Project Server newsgroup and addressing technical
issues. Hope this helps.





asadim said:
One of our PS Project Managers have complained that this is what he got
from
PS in his email after trying to publish his project:

Subject: Your queue job ACProjectSave failed. Please contact your
administrator for assistance

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="a2c6ea80-7a24-4caf-8599-e9446beb7db2"
error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY
constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in
object
'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot
insert duplicate key in object 'dbo.MSP_PROJECT_CALENDARS'.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
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="1f22af26-8a66-438f-865d-25c63d3333c9"
JobUID="43641875-433c-4f00-bb5e-5b2f69435a5f" ComputerName="VANMSEVAL02"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="5" Stage="" />
</class>
</general>
</errinfo>

I have no single idea what the problem might be from! It'd be appreciated
if
someone could advise on how to resolve this.
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

Errors 12005 and 26000 in PS 2007 2
Error ID: 12005 Job Type: Save 1
PS 2007 SP1 - Save job failing, cancelling, and restarting at 7% 3
save job failed & blocking with error: ActiveCacheQueuedMessageEx 1
Save job failed on PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES 1
ACProjectSave failed 4
Creating Offline Database 6
Issues in Project Server 2007 2

Top