locked
Project Save to Server 2007 - Error RRS feed

  • Question

  • I have a user that continues to have problems with saving her project to the server. The queue shows Failed and Blocking Correlation with the following error message:

    Error summary/areas:
    ActiveCacheQueuedMessageExecutionError
    ActiveCacheQueuedMessageExecutionError
    Queue
    GeneralQueueJobFailed
    Error details:

    <?xml version="1.0" encoding="utf-16"?>
    <errinfo>
      <general>
        <class name="ActiveCacheQueuedMessageExecutionError">
          <error id="12005" name="ActiveCacheQueuedMessageExecutionError" uid="2ed136f6-405e-4a43-8cdb-5c1d131c26c6" error="System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_RESOURCES'. Cannot insert duplicate key in object 'dbo.MSP_PROJECT_RESOURCES'.&#xD;&#xA;The statement has been terminated.&#xD;&#xA;   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)&#xD;&#xA;   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)&#xD;&#xA;   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)&#xD;&#xA;   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)&#xD;&#xA;   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)&#xD;&#xA;   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)&#xD;&#xA;   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)&#xD;&#xA;   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xD;&#xA;   at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)&#xD;&#xA;   at Microsoft.Office.Project.Server.DataAccessLayer.WinProjDal.ExecuteStoredProcedure(String spName, SqlParameter[] parameters)&#xD;&#xA;   at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjUtility.ExecuteP12QueueableSPCommand(WinProjTraceContext wpTraceContext, DataStoreEnum store, P12QueueableSPCommand command, Boolean retry, Boolean useTransaction)&#xD;&#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="0c8a4c85-5a14-444a-a0b3-6e7e350df189" JobUID="b59a4ac9-bd3d-4f16-a3f1-c991011f94e5" ComputerName="VERDI" GroupType="ACProjectSave" MessageType="Byte[]" MessageId="39" Stage="" />
        </class>
      </general>
    </errinfo>

    It appears to be an error with the resources, but I'm not 100% sure what the solution is for this? Can someone help with this? I'm not well versed in decoding these error messages in Project Server.

    Thank you,

    Travis

    Tuesday, August 28, 2012 8:16 PM

Answers

  • Hi Travis,

    Please check if you have a same resource (Local Resource) same as Enterprise Resource is Project Server with some actual in Projects. 


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.This can be beneficial to other community members reading the thread.

    • Marked as answer by TravisLong Thursday, September 20, 2012 8:54 PM
    Tuesday, August 28, 2012 8:37 PM

All replies

  • Hi Travis,

    Please check if you have a same resource (Local Resource) same as Enterprise Resource is Project Server with some actual in Projects. 


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.This can be beneficial to other community members reading the thread.

    • Marked as answer by TravisLong Thursday, September 20, 2012 8:54 PM
    Tuesday, August 28, 2012 8:37 PM
  • We will give that a try! That may be the problem. I will let you know.

    Thank you!

    Travis


    Travis Long IT Project Manager Entry Idaho Power Co. Project Server Admin

    Tuesday, August 28, 2012 10:33 PM