ACProjectSave failed

N

nkri

Hi to all Experts!

I am facing the following problem. I have created a project template with
hundreds of tasks and a dozen of custom views and I have saved it as an
enterprise project template in the Project Server 2007. When I am trying to
create a new project based on this template, I recieve an error (id 12005)
saying that project failed to be saved and also I recieve a mail with the
following description for the error:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError" uid
="5d6852ad-2627-4bb1-bdcf-ee4332277cd2" error
="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)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid
="05d703d2-7ca7-4168-9965-74f902cb0694" JobUID
="c351b34b-7d7f-45d1-81ce-6cc55c35b963" ComputerName="SRV-PROJECT"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="28" Stage="" />
</class>
</general>
</errinfo>

I have tried the following:
1. restarting the que
2. rebooting the Project Server
3. deleting the local cache
4. saving the project template as .mpp and then re-create a new project
enterpise template
but none of these worked. I would appreciated if you could give me a
solution to this dead-end because it took me 2 wks to create the template and
I don't want to spend all this time again to build it from scratch. Bear in
mind that other templates that I have created work fine.
Thanks in advance!!!
 
W

waqas sarwar

Hey Nkri,

I am not sure about the problem where its creating the mess but their is one
link may be it help you.

http://www.ureader.com/message/33365912.aspx
or

http://www.whitebinder.com/article/...strange-error-when-publishing-to-ps-2007.aspx


hope you may be fix the issue.

--
Waqas Sarwar
Sharepoint & Project Server Admin
MCTS(70-630,70-631,70-639).
VA, USA


nkri said:
Hi to all Experts!

I am facing the following problem. I have created a project template with
hundreds of tasks and a dozen of custom views and I have saved it as an
enterprise project template in the Project Server 2007. When I am trying to
create a new project based on this template, I recieve an error (id 12005)
saying that project failed to be saved and also I recieve a mail with the
following description for the error:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError" uid
="5d6852ad-2627-4bb1-bdcf-ee4332277cd2" error
="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)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid
="05d703d2-7ca7-4168-9965-74f902cb0694" JobUID
="c351b34b-7d7f-45d1-81ce-6cc55c35b963" ComputerName="SRV-PROJECT"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="28" Stage="" />
</class>
</general>
</errinfo>

I have tried the following:
1. restarting the que
2. rebooting the Project Server
3. deleting the local cache
4. saving the project template as .mpp and then re-create a new project
enterpise template
but none of these worked. I would appreciated if you could give me a
solution to this dead-end because it took me 2 wks to create the template and
I don't want to spend all this time again to build it from scratch. Bear in
mind that other templates that I have created work fine.
Thanks in advance!!!
Click to expand...
 
N

nkri

Thanks a lot Waqas!

I have finally found a solution that worked! I was helped in finding the
solution from the first link you posted. However, the problem had something
to do with the tasks calendars and not the task names. This can be easily
concluded from the error description that was saying "Violation of PRIMARY
KEY constraintWhat I did was to select all tasks in the template plan and from the <Task
Information> and the tab <Advanced> I selected the <Calendar> "None". The new
project template that I created this way had no problem when using it to
create (save as ...) new projects.

I hope that my solution will help also other users and admins facing the
same or similar problems.
waqas sarwar said:
Hey Nkri,

I am not sure about the problem where its creating the mess but their is one
link may be it help you.

http://www.ureader.com/message/33365912.aspx
or

http://www.whitebinder.com/article/...strange-error-when-publishing-to-ps-2007.aspx


hope you may be fix the issue.

--
Waqas Sarwar
Sharepoint & Project Server Admin
MCTS(70-630,70-631,70-639).
VA, USA


nkri said:
Hi to all Experts!

I am facing the following problem. I have created a project template with
hundreds of tasks and a dozen of custom views and I have saved it as an
enterprise project template in the Project Server 2007. When I am trying to
create a new project based on this template, I recieve an error (id 12005)
saying that project failed to be saved and also I recieve a mail with the
following description for the error:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError" uid
="5d6852ad-2627-4bb1-bdcf-ee4332277cd2" error
="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)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid
="05d703d2-7ca7-4168-9965-74f902cb0694" JobUID
="c351b34b-7d7f-45d1-81ce-6cc55c35b963" ComputerName="SRV-PROJECT"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="28" Stage="" />
</class>
</general>
</errinfo>

I have tried the following:
1. restarting the que
2. rebooting the Project Server
3. deleting the local cache
4. saving the project template as .mpp and then re-create a new project
enterpise template
but none of these worked. I would appreciated if you could give me a
solution to this dead-end because it took me 2 wks to create the template and
I don't want to spend all this time again to build it from scratch. Bear in
mind that other templates that I have created work fine.
Thanks in advance!!!
Click to expand...
Click to expand...
 
H

Hezequias Vasconcelos de Lima

nkri said:
Thanks a lot Waqas!

I have finally found a solution that worked! I was helped in finding the
solution from the first link you posted. However, the problem had something
to do with the tasks calendars and not the task names. This can be easily
concluded from the error description that was saying "Violation of PRIMARY
KEY constraintWhat I did was to select all tasks in the template plan and from the <Task
Information> and the tab <Advanced> I selected the <Calendar> "None". The new
project template that I created this way had no problem when using it to
create (save as ...) new projects.

I hope that my solution will help also other users and admins facing the
same or similar problems.
waqas sarwar said:
Hey Nkri,

I am not sure about the problem where its creating the mess but their is one
link may be it help you.

http://www.ureader.com/message/33365912.aspx
or

http://www.whitebinder.com/article/...strange-error-when-publishing-to-ps-2007.aspx


hope you may be fix the issue.

--
Waqas Sarwar
Sharepoint & Project Server Admin
MCTS(70-630,70-631,70-639).
VA, USA


nkri said:
Hi to all Experts!

I am facing the following problem. I have created a project template with
hundreds of tasks and a dozen of custom views and I have saved it as an
enterprise project template in the Project Server 2007. When I am trying to
create a new project based on this template, I recieve an error (id 12005)
saying that project failed to be saved and also I recieve a mail with the
following description for the error:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ActiveCacheQueuedMessageExecutionError">
<error id="12005" name="ActiveCacheQueuedMessageExecutionError" uid
="5d6852ad-2627-4bb1-bdcf-ee4332277cd2" error
="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)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid
="05d703d2-7ca7-4168-9965-74f902cb0694" JobUID
="c351b34b-7d7f-45d1-81ce-6cc55c35b963" ComputerName="SRV-PROJECT"
GroupType="ACProjectSave" MessageType="Byte[]" MessageId="28" Stage="" />
</class>
</general>
</errinfo>

I have tried the following:
1. restarting the que
2. rebooting the Project Server
3. deleting the local cache
4. saving the project template as .mpp and then re-create a new project
enterpise template
but none of these worked. I would appreciated if you could give me a
solution to this dead-end because it took me 2 wks to create the template and
I don't want to spend all this time again to build it from scratch. Bear in
mind that other templates that I have created work fine.
Thanks in advance!!!
Click to expand...
Click to expand...
Click to expand...
 
H

Hezequias Vasconcelos de Lima

The error is generated because it trying to insert a record that already
exists in accordance with the key primaria.Mas this case I imagine the delay
is for driving traffic to requests ... when you shoot the process is sent to
the bank and was ... this error should not give because of delay.Outro point
that PK is composed of two fields:

1 - PROJ_UID
2 - CAL_UID

They are not Identity.

But theirs is the datatype of type UID: Uniequeidentifier
What we imagine to be a random function that SQL always gives a distinct
value for that type of field.
he writes in a hash fields.
eg 46545ac7-09a6-4290-9929-00078ad4aaa0

I am doing some testing on SQL but so far only managed to get to this
information.

Hezequias Vasconcelos de Lima - MCITP.
 

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
Unable to access to the "Force Check-in Enterprise Objects 4
Save job failed on PK_MSP_PROJECT_LOOKUP_TABLE_STRUCTURES 1
Exception when using PWA Services: MSP_SSP_UPDATE_ENTERPRISE_ENTIT 0
Cube Not Building 2
Errors 12005 and 26000 in PS 2007 2

Top