none
Error : ( Microsoft Project Server ) ACProjectSave queued work. Contact your administrator for help. ( ID Error: Error ID: 12005-Error ID: 26000 ) RRS feed

  • Question

  • Dear Msft Team,

    Pls, we are asking your prompt your support to give asap a final solution to this issue:

    When user is working into the Msft Project Server , there appears the following message error:

    ( Product: Microsoft Proyect Server )

    ============================================================================================

    Subject: Error ACProjectSave queued work. Contact your administrator for help.


    ACProjectSave mistake at work. Its current status is Failed. 7% was completed. He passed on 12/20/2012 11:45:11 tail.
    For more information about the job failure, please go to Project Web Access Select Personal Settings in the left menu. Then select My Queued Jobs.

    The queue errors returned are:
     
    Error ID: 12005
     
    Error ID: 26000

    Error details - send it to the administrator for more troubleshooting information.
    " j="<? Xml version = "1.0" encoding = "utf-16"> " title="<?xml version="1.0" encoding="utf-16"?>"><? Xml version = "1.0" encoding = "utf-16">
    " j="<general>     " title="<general>"><general>
       
    " j="<class name="ActiveCacheQueuedMessageExecutionError">       " title="<class name="ActiveCacheQueuedMessageExecutionError">"><class name="ActiveCacheQueuedMessageExecutionError">

    " j="<class name="ActiveCacheQueuedMessageExecutionError">       " title="<class name="ActiveCacheQueuedMessageExecutionError">">     <Error id = "12005" name = "ActiveCacheQueuedMessageExecutionError" uid = "0b972f92-4430-82A1-c4ca-b533638b5915" error =

    "System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_MSP_ASSIGNMENTS." Can not insert duplicate key in object 'dbo.MSP_ASSIGNMENTS'. The duplicate key value is (6a73164a-4f0e-4507-8b53-a3b8b4b04126). The statement has been terminated. at System.Data . SqlClient.SqlConnection.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 wpTraceContext, DataStoreEnum store, P12QueueableSPCommand command, Boolean retry, Boolean UseTransaction) at " j="acMessage, Message msg, Group messageGroup, jobticket jobticket, MessageContext mContext) "/>     " title="acMessage, Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)" />">acMessage, Message msg, Group messageGroup, jobticket jobticket, MessageContext mContext) "/>
        
    " j="<class name="Queue">       " title="<class name="Queue">"><class name="Queue">
          
    <Error id = "26000" name = "GeneralQueueJobFailed" uid = "6a6a570c-f677-4544-a74c-733da7db0b36" JobUID = "42db1664-d6e7-4b89-9fa9-83d6c7f3d0c5" ComputerName = "PSBD-W-SPP-01" groupType " j="= "ACProjectSave" MessageType = "Byte []" MessageId = "8" Stage = "" />     " title="="ACProjectSave" MessageType="Byte[]" MessageId="8" Stage="" />">= "ACProjectSave" MessageType = "Byte []" MessageId = "8" Stage = "" />
        
    " j="</ General> " title="</general>"></ General>
    You can do the following:
    1. Try to solve problems using the Ids. Error, error XML.
    2. Contact your administrator jobID (42db1664-d6e7-4b89-9fa9-83d6c7f3d0c5) and error XML.

    o disable these notifications, go to Project Web App, click Personal Settings option on the left menu, and then click Manage my alerts and warnings.

    From this page, you can deselect the check box for notifications you no longer want to receive.
    Microsoft Project Server


    The contents of this email and accompanying documents contain confidential or proprietary information of Binary SA In the event that the recipient does not correspond to the person to whom it is directed, advised that the unauthorized use of this instrument, as its review, copying or distribution is strictly prohibited. If you received this email in error, please delete the information provided herein, by the same means notifying the sender.


    The contents of this email and accompanying documents contain confidential or proprietary information of Binary SA In the event that the recipient does not correspond to the person to whom it is directed, advised that the unauthorized use of this instrument, as its review, copying or distribution is strictly prohibited. If you received this email in error, please delete the information provided herein, by the same means notifying the sender.

    Before printing this email, make sure it is necessary

    ===================================================

    Pls your feedback or troubleshooting that coulb be applied in this issue.

    Looking forward to your comments,

    Thanks a Lot !

    Pablo Gordillo

    Movil: 8-5165830

    Deshacer cambios<input id="history_state0" name="history_state0" style="display:none;" type="text" />
    Friday, December 28, 2012 1:56 PM

All replies

  • Hi Pablo,

    This is not official Microsoft Project Server Support team page. This is a community page where project users across the world try to help each other. And may not be an speedy resolution. If this is an show stopper issue for you and has highest property please contact Microsoft support directly.

    Based on the above error message it looks like the project plan which you are trying to save  has an duplicate assignment which is already present in the database. Before we proceed further could you please tell us more about the background of this issue.

    a. Based on error message would like to confirm , you are using Project Server 2010 and Project Professional 2010?

    b. Service Pack and cumulative patch on server and project professional?

    c. Is this issue project or user specific?

    d. Were you able to perform similar action before?

    e. Are you trying to import this project plan in to the server?

    f. have you tried clearing  local cache and re-attempt to save the project plan?


    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.


    Friday, December 28, 2012 5:09 PM
    Moderator