PS 2007 SP1 - Save job failing, cancelling, and restarting at 7%

R

Renee H

We have a project that when you first save it after a change fails at 7%
complete with the following error:

"Save failed due to unknown error. Message ID is 8. Error is
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_CALENDARS'.
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). Please contact administrator for further details"

It then starts another save job automatically that succeeds. If you then
make another change and save, it works fine. But after you close and check
in, it will do the same thing next time it is opened and saved. Any ideas?
 
P

Prasanna Adavi, PMP, MCTS

May be this will help you. You will need to install SP2

http://microsoftepmsolution.blogspot.com/2009/05/service-pack-2-for-2007-microsoft.html



Renee wrote:

PS 2007 SP1 - Save job failing, cancelling, and restarting at 7%
31-Mar-09

We have a project that when you first save it after a change fails at 7%
complete with the following error:

"Save failed due to unknown error. Message ID is 8. Error is
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_CALENDARS'.
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). Please contact administrator for further details"

It then starts another save job automatically that succeeds. If you then
make another change and save, it works fine. But after you close and check
in, it will do the same thing next time it is opened and saved. Any ideas?

Previous Posts In This Thread:

PS 2007 SP1 - Save job failing, cancelling, and restarting at 7%
We have a project that when you first save it after a change fails at 7%
complete with the following error:

"Save failed due to unknown error. Message ID is 8. Error is
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_CALENDARS'.
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). Please contact administrator for further details"

It then starts another save job automatically that succeeds. If you then
make another change and save, it works fine. But after you close and check
in, it will do the same thing next time it is opened and saved. Any ideas?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Data-Centric .NET Programming with C#
http://www.eggheadcafe.com/tutorial...08b-82da4c5f3160/datacentric-net-program.aspx
 
D

Dale Howard [MVP]

Prasanna --

Sage advice, my friend. At this point in time, I cannot fathom why anyone
would not have SP2 installed, plus any Cumulative Updates since then
(especially the December 2009 CU which fixes the "time smearing" problem).
Thanks for sharing your advice to this user! :)




in message
May be this will help you. You will need to install SP2

http://microsoftepmsolution.blogspot.com/2009/05/service-pack-2-for-2007-microsoft.html



Renee wrote:

PS 2007 SP1 - Save job failing, cancelling, and restarting at 7%
31-Mar-09

We have a project that when you first save it after a change fails at 7%
complete with the following error:

"Save failed due to unknown error. Message ID is 8. Error is
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_CALENDARS'.
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). Please contact administrator for further
details"

It then starts another save job automatically that succeeds. If you then
make another change and save, it works fine. But after you close and
check
in, it will do the same thing next time it is opened and saved. Any
ideas?

Previous Posts In This Thread:

PS 2007 SP1 - Save job failing, cancelling, and restarting at 7%
We have a project that when you first save it after a change fails at 7%
complete with the following error:

"Save failed due to unknown error. Message ID is 8. Error is
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint
'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in object
'dbo.MSP_PROJECT_CALENDARS'.
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). Please contact administrator for further
details"

It then starts another save job automatically that succeeds. If you then
make another change and save, it works fine. But after you close and
check
in, it will do the same thing next time it is opened and saved. Any
ideas?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Data-Centric .NET Programming with C#
http://www.eggheadcafe.com/tutorial...08b-82da4c5f3160/datacentric-net-program.aspx
Click to expand...
 
P

Prasanna Adavi, PMP, MCTS

Thanks Dale!



Dale Howard [MVP] wrote:

Prasanna --Sage advice, my friend.
03-Feb-10

Prasanna -

Sage advice, my friend. At this point in time, I cannot fathom why anyon
would not have SP2 installed, plus any Cumulative Updates since the
(especially the December 2009 CU which fixes the "time smearing" problem)
Thanks for sharing your advice to this user! :

-
Dale A. Howard [MVP
VP of Educational Service
msProjectExpert
http://www.msprojectexperts.co
http://www.projectserverexperts.co
"We write the books on Project Server

in message

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
C# : Develop Producer-Consumer application with Threads and Monitor usage and Run it from browser
http://www.eggheadcafe.com/tutorial...adde-177814ad893c/c--develop-producercon.aspx
 

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

Error ID: 12005 Job Type: Save 1
save job failed & blocking with error: ActiveCacheQueuedMessageEx 1
ACProjectSave failed 4
Unable to access to the "Force Check-in Enterprise Objects 4
Errors 12005 and 26000 in PS 2007 2
Save job failed on PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES 1
Cube Not Building 2
Exception when using PWA Services: MSP_SSP_UPDATE_ENTERPRISE_ENTIT 0

Top