Errors 12005 and 26000 in PS 2007

A

asadim

One of our PS Project Managers have complained that this is what he got from
PS in his email:

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.
 
A

asadim

Well, here's the solution that I finally figured out: there are duplicate
entries in the project. The project had fields with unique ID's but some task
names were the same. I think this is a major issue that needs to be fixed.
Our Project Manager was also not happy with the way errors were emailed to
him.

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

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...
 
S

Sharry Heberer [MSFT]

You can turn off Queue Notifications (without affecting other types of
Notifications/Alerts). Queue Failures are emailed to the person who
submitted the failing job if Queue Notifications are turned on.

asadim said:
Well, here's the solution that I finally figured out: there are duplicate
entries in the project. The project had fields with unique ID's but some
task
names were the same. I think this is a major issue that needs to be fixed.
Our Project Manager was also not happy with the way errors were emailed to
him.

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

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...
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

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

Top