locked
Save error message when saving a template in Project Pro RRS feed

  • Question

  • I'm trying to resolve this issue that has to do with a template in project Pro. When I try to save it, I'm getting an error message (12005).

    I tried to overwrite it with a new template but it didn't help. I'm not sure what made it corrupted.

    It looks like there are problems with duplicate resources. I also tried to delete all tasks and saved it with just the sumamry task name and it still gave me an error message. I'm not sure what other options are there to fix this issue. Please help. Thank you

    <?xml version="1.0" encoding="utf-16"?>
    <errinfo>
     <general>
      <class name="ActiveCacheQueuedMessageExecutionError">
       <error id="12005" name="ActiveCacheQueuedMessageExecutionError" uid="ff12583a-3f2b-4531-8ba5-74d379cefa9a" error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_RESOURCES'. Cannot insert duplicate key in object 'dbo.MSP_PROJECT_RESOURCES'.&#xA;The statement has been terminated.&#xA;   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)&#xA;   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)&#xA;   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)&#xA;   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)&#xA;   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)&#xA;   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)&#xA;   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)&#xA;   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xA;   at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)&#xA;   at Microsoft.Office.Project.Server.DataAccessLayer.WinProjDal.ExecuteStoredProcedure(String spName, SqlParameter[] parameters)&#xA;   at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjUtility.ExecuteP12QueueableSPCommand(WinProjTraceContext wpTraceContext, DataStoreEnum store, P12QueueableSPCommand command, Boolean retry, Boolean useTransaction)&#xA;   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="7f451dc8-08bf-4773-b77f-85d8162c7aea" JobUID="5dba3ac6-1d48-4b8f-8a9f-7e060cbee084" ComputerName="NICKPRICE2" GroupType="ACProjectSave" MessageType="Byte[]" MessageId="6" Stage=""/>
      </class>
     </general>
    </errinfo>


    • Edited by pawel850 Friday, December 2, 2011 10:24 PM
    Friday, December 2, 2011 10:24 PM

Answers

  • What SP / CU are you on ?

    Try cleaning up summary task resources, any duplicate resource assignments on same task and then republish

    Let us know if this helps


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Tuesday, December 6, 2011 12:06 AM