Save job failed on PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES

P

PedroT

Hi,

Has anyone come across with this error when saving a project to the
DB?

I don´t think it has anything to do with my custom fields, but I only
have 2 simple ones with only one level and no numbers...

If anyone can point me how to search for problem cause I would very
much appreciate.

ERROR REPORT:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="623df2c2-f149-4042-8da9-c37f930750a5"
error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY
constraint 'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert
duplicate key in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
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.
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="afd376e9-892d-42a1-a298-c9ef1ce80727" JobUID="d933d664-
c155-4412-9b6f-14ddcf510cd7" ComputerName="GSRV2"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="14" Stage=""/</class>
</general>
</errinfo>
 
J

Jonathan Sofer

Try clearing your project cache and try again.

Go to C:\Documents and Settings\jonathan.sofer\Application Data\Microsoft\MS
Project and delete folder 12 and Cache

Custom fields can get jumbled up when you make changes to the global and
don't clear the project cache. This is a known bug in 2007.

Jonathan

Hi,

Has anyone come across with this error when saving a project to the
DB?

I don´t think it has anything to do with my custom fields, but I only
have 2 simple ones with only one level and no numbers...

If anyone can point me how to search for problem cause I would very
much appreciate.

ERROR REPORT:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError"
uid="623df2c2-f149-4042-8da9-c37f930750a5"
error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY
constraint 'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert
duplicate key in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'. Cannot insert duplicate key
in object 'dbo.MSP_PROJECT_LOOKUP_TABLE_STRUCTURES'.
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.
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="afd376e9-892d-42a1-a298-c9ef1ce80727" JobUID="d933d664-
c155-4412-9b6f-14ddcf510cd7" ComputerName="GSRV2"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="14" Stage=""/</class>
</general>
</errinfo>
 

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
Error ID: 12005 Job Type: Save 1
PS 2007 SP1 - Save job failing, cancelling, and restarting at 7% 3
Errors 12005 and 26000 in PS 2007 2
ACProjectSave failed 4
Error 12005 in MSP 2007 1
Issues in Project Server 2007 2
Unable to access to the "Force Check-in Enterprise Objects 4

Top