none
Project server 2010 timesheet error RRS feed

  • Question

  • Hi, 

    i have got one user who cant save or submit a timesheet.

    Errors:

    Client Email 1:

    Your ReportingTimesheetSave job failed.  Its current state is FailedNotBlocking.  It was 0% complete.  It entered the queue at 04/26/2012 10:54:17.

    To get more information about the job failure, please go to Project Web App.  Select Personal Settings from the left menu.  Then select My Queued Jobs.

    The errors returned from the queue are as follows:

     Error ID: 24014

     Error ID: 26000

    Detailed error below - send it to the administrator for more detailed troubleshooting.

    <?xml version="1.0" encoding="utf-16"?>

    <errinfo>

      <general>

        <class name="Reporting message processor failed">

          <error id="24014" name="ReportingTimesheetSaveMessageFailed" uid="dcd749b1-25f5-4d03-9f7f-2c9774ba2a6b" QueueMessageBody="TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'" Error="Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32).&#xD;&#xA;The statement has been terminated." />

          <error id="24014" name="ReportingTimesheetSaveMessageFailed" uid="f5c00ea6-8574-4330-a051-023171e68d23" QueueMessageBody="TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'" Error="Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32).&#xD;&#xA;The statement has been terminated." />

          <error id="24014" name="ReportingTimesheetSaveMessageFailed" uid="5a8d9276-5e24-41d4-942f-0a8383e76dbd" QueueMessageBody="TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'" Error="Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32).&#xD;&#xA;The statement has been terminated." />

          <error id="24014" name="ReportingTimesheetSaveMessageFailed" uid="26811a0b-5f08-4aff-9191-0bfdfaceea9a" QueueMessageBody="TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'" Error="Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32).&#xD;&#xA;The statement has been terminated." />

          <error id="24014" name="ReportingTimesheetSaveMessageFailed" uid="494336e5-5746-477d-9daf-983b14890d8b" QueueMessageBody="TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'" Error="Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32).&#xD;&#xA;The statement has been terminated." />

          <error id="24014" name="ReportingTimesheetSaveMessageFailed" uid="3bfc052d-571c-4668-8a97-e1afaf96fab5" QueueMessageBody="TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'" Error="Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32).&#xD;&#xA;The statement has been terminated." />

        </class>

        <class name="Queue">

          <error id="26000" name="GeneralQueueJobFailed" uid="2ccbaa65-7465-474e-98e9-a77c9bd06782" JobUID="b9e26eb2-7d68-4fe7-947c-bb795999d5a4" ComputerName="SVVCAB036" GroupType="ReportingTimesheetSave" MessageType="ReportTimesheetSaveMessageEx" MessageId="1" Stage="" />

        </class>

      </general>

    </errinfo>

    You can do the following:

    1. Try troubleshooting using the error IDs, error XML.

    2. Contact administrator with your jobID (b9e26eb2-7d68-4fe7-947c-bb795999d5a4) and error XML.

    To turn off these notifications, go to Project Web App, click Personal Settings on the left menu, and then click Manage My Alerts and Reminders.

    From this page, you can clear the check box for those notifications you no longer want to receive.

    Dac Systems - EPO (Microsoft Office Project Server)

    Client Email 2:

    Your ReportingTimesheetDelete job failed.  Its current state is FailedNotBlocking.  It was 0% complete.  It entered the queue at 04/26/2012 10:54:01.

    To get more information about the job failure, please go to Project Web App.  Select Personal Settings from the left menu.  Then select My Queued Jobs.

    The errors returned from the queue are as follows:

     Error ID: 24011

     Error ID: 26000

    Detailed error below - send it to the administrator for more detailed troubleshooting.

    <?xml version="1.0" encoding="utf-16"?>

    <errinfo>

      <general>

        <class name="Reporting message processor failed">

          <error id="24011" name="ReportingTimesheetDeleteMessageFailed" uid="7a77c055-c153-4511-85f4-8a6eb0a777c4" QueueMessageBody="TimesheetUid='c2098a70-24f5-4906-a1dc-25be6b09d471'" Error="Invalid call to MSP_EpmDeleteTimesheetAdminAssignments. Timesheet UID (C2098A70-24F5-4906-A1DC-25BE6B09D471) was not found in MSP_Timesheet." />

          <error id="24011" name="ReportingTimesheetDeleteMessageFailed" uid="19252dda-1178-418e-a0c2-1114f28293b8" QueueMessageBody="TimesheetUid='c2098a70-24f5-4906-a1dc-25be6b09d471'" Error="Invalid call to MSP_EpmDeleteTimesheetAdminAssignments. Timesheet UID (C2098A70-24F5-4906-A1DC-25BE6B09D471) was not found in MSP_Timesheet." />

          <error id="24011" name="ReportingTimesheetDeleteMessageFailed" uid="cbbe0efe-4913-4943-ba64-6efc94cfb4e5" QueueMessageBody="TimesheetUid='c2098a70-24f5-4906-a1dc-25be6b09d471'" Error="Invalid call to MSP_EpmDeleteTimesheetAdminAssignments. Timesheet UID (C2098A70-24F5-4906-A1DC-25BE6B09D471) was not found in MSP_Timesheet." />

          <error id="24011" name="ReportingTimesheetDeleteMessageFailed" uid="cf9861ea-f969-48fa-8e65-cfe6f73c3435" QueueMessageBody="TimesheetUid='c2098a70-24f5-4906-a1dc-25be6b09d471'" Error="Invalid call to MSP_EpmDeleteTimesheetAdminAssignments. Timesheet UID (C2098A70-24F5-4906-A1DC-25BE6B09D471) was not found in MSP_Timesheet." />

          <error id="24011" name="ReportingTimesheetDeleteMessageFailed" uid="a195ab30-ab61-4255-b9bf-0e588f9f9e6d" QueueMessageBody="TimesheetUid='c2098a70-24f5-4906-a1dc-25be6b09d471'" Error="Invalid call to MSP_EpmDeleteTimesheetAdminAssignments. Timesheet UID (C2098A70-24F5-4906-A1DC-25BE6B09D471) was not found in MSP_Timesheet." />

          <error id="24011" name="ReportingTimesheetDeleteMessageFailed" uid="621effad-dd01-428a-9266-1b1f970670a4" QueueMessageBody="TimesheetUid='c2098a70-24f5-4906-a1dc-25be6b09d471'" Error="Invalid call to MSP_EpmDeleteTimesheetAdminAssignments. Timesheet UID (C2098A70-24F5-4906-A1DC-25BE6B09D471) was not found in MSP_Timesheet." />

        </class>

        <class name="Queue">

          <error id="26000" name="GeneralQueueJobFailed" uid="7b0775d6-44df-4797-ab88-4f6b76100dd2" JobUID="6f1924ca-73d6-4b31-8d86-181e6ecbe539" ComputerName="SVVCAB036" GroupType="ReportingTimesheetDelete" MessageType="ReportTimesheetDeleteMessageEx" MessageId="1" Stage="" />

        </class>

      </general>

    </errinfo>

    You can do the following:

    1. Try troubleshooting using the error IDs, error XML.

    2. Contact administrator with your jobID (6f1924ca-73d6-4b31-8d86-181e6ecbe539) and error XML.

    To turn off these notifications, go to Project Web App, click Personal Settings on the left menu, and then click Manage My Alerts and Reminders.

    From this page, you can clear the check box for those notifications you no longer want to receive.


    Queues errors:

    General
    Reporting message processor failed:
    ReportingTimesheetSaveMessageFailed (24014) - Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.. Details: id='24014' name='ReportingTimesheetSaveMessageFailed' uid='4ed65933-5945-4411-a9de-5f77e38784b3' QueueMessageBody='TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'' Error='Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.'. 
    ReportingTimesheetSaveMessageFailed (24014) - Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.. Details: id='24014' name='ReportingTimesheetSaveMessageFailed' uid='b31ade45-b09c-41e0-a839-01c3bd46d8eb' QueueMessageBody='TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'' Error='Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.'. 
    ReportingTimesheetSaveMessageFailed (24014) - Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.. Details: id='24014' name='ReportingTimesheetSaveMessageFailed' uid='e405b576-61a7-4ba1-a7cf-289198d6d7a9' QueueMessageBody='TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'' Error='Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.'. 
    ReportingTimesheetSaveMessageFailed (24014) - Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.. Details: id='24014' name='ReportingTimesheetSaveMessageFailed' uid='ecbea309-b18e-4c69-8c5a-89b1f7391157' QueueMessageBody='TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'' Error='Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.'. 
    ReportingTimesheetSaveMessageFailed (24014) - Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.. Details: id='24014' name='ReportingTimesheetSaveMessageFailed' uid='f42fe34c-0ef5-4bd4-8f39-f534950782cf' QueueMessageBody='TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'' Error='Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.'. 
    ReportingTimesheetSaveMessageFailed (24014) - Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.. Details: id='24014' name='ReportingTimesheetSaveMessageFailed' uid='67863dec-5701-4cf9-83fa-d3b1247f28bd' QueueMessageBody='TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f'' Error='Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32). The statement has been terminated.'. 
    Queue:
    GeneralQueueJobFailed (26000) - ReportingTimesheetSave.ReportTimesheetSaveMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='feb08b0f-c897-4009-889c-8b45f2cd01b4' JobUID='71dac6d0-720d-4ee0-9901-39d8950b1a6a' ComputerName='SVVCAB036' GroupType='ReportingTimesheetSave' MessageType='ReportTimesheetSaveMessageEx' MessageId='1' Stage=''. For more details, check the ULS logs on machine SVVCAB036 for entries with JobUID 71dac6d0-720d-4ee0-9901-39d8950b1a6a. 

    ULS:

    Standard Information:PSI Entry Point:   Project User: domain\user  Correlation Id: b985c7da-c232-4be0-a26c-8f3998604470  PWA Site URL: http://projects/PWA  SSP Name: Project Server Service Application  PSError: ReportingTimesheetSaveMessageFailed (24014) RDS: The request to synchronize timesheet TimesheetUid='73bd623f-1fdb-400d-8782-838bdd0c403f' failed.  Message: 'ReportingTimesheetSaveMessageFailed'. Message Body: Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (58dac814-3a9f-45f9-8e5b-f456833ea863, 4eabe50a-6667-4a05-9352-a1770b091d32).  The statement has been terminated. Error:(null)

    Thursday, April 26, 2012 9:29 AM

Answers

  • Hi There--

    Seems that there are some records for timesheet which don't exist in publsihed database but may be in Reporting database.
    Try running the query:

    USE ProjectServer_REPORTING
    SELECT     MTR.ResourceName, MTP.PeriodName, MT.TimesheetUID
    FROM         dbo.MSP_Timesheet AS MT INNER JOIN
                          dbo.MSP_TimesheetPeriod AS MTP ON MT.PeriodUID = MTP.PeriodUID INNER JOIN
                          dbo.MSP_TimesheetResource AS MTR ON MT.OwnerResourceNameUID = MTR.ResourceNameUID
    WHERE MT.TimesheetUID NOT IN
    (SELECT TS_UID
    FROM ProjectServer_PUBLISHED.DBO.MSP_TIMESHEETS)

    If you get any record(s), You may need to open a support call with Microsoft support to clean the database.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Friday, April 27, 2012 6:22 AM

All replies

  • Oh, forgot about the server details:

    Project Server 2010

    Feb 2012 Cu...

    Thursday, April 26, 2012 10:15 AM
  • Can you just check if account is locked or password expired for:

    1. For the account for which time sheet is created

    2. For the account to which time sheet goes for approval

    3. For the account the tasks go for update (PM of the Project) which contains the tasks in this timesheet


    Abhijeet M. Mohite

    Thursday, April 26, 2012 10:18 AM
  • Can you just check if account is locked or password expired for:

    1. For the account for which time sheet is created

    2. For the account to which time sheet goes for approval

    3. For the account the tasks go for update (PM of the Project) which contains the tasks in this timesheet


    Abhijeet M. Mohite

    None of the accounts is locked.

    Passwords also not expired


    Thursday, April 26, 2012 10:44 AM
  • Try deleting the timesheet and re-create the same.


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    Thursday, April 26, 2012 3:13 PM
    Moderator
  • Tried that. Wont delete... Client email 2(Above) is the error when trying to delete.
    Thursday, April 26, 2012 3:45 PM
  • Hi There--

    Seems that there are some records for timesheet which don't exist in publsihed database but may be in Reporting database.
    Try running the query:

    USE ProjectServer_REPORTING
    SELECT     MTR.ResourceName, MTP.PeriodName, MT.TimesheetUID
    FROM         dbo.MSP_Timesheet AS MT INNER JOIN
                          dbo.MSP_TimesheetPeriod AS MTP ON MT.PeriodUID = MTP.PeriodUID INNER JOIN
                          dbo.MSP_TimesheetResource AS MTR ON MT.OwnerResourceNameUID = MTR.ResourceNameUID
    WHERE MT.TimesheetUID NOT IN
    (SELECT TS_UID
    FROM ProjectServer_PUBLISHED.DBO.MSP_TIMESHEETS)

    If you get any record(s), You may need to open a support call with Microsoft support to clean the database.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Friday, April 27, 2012 6:22 AM
  • Hi, Thanks Amit.

    Sorry for the delay, we had some public holidays here.

    There is one record that comes up and the is the one i have issues with.

    If anyone know how to fix this please let me know but i will start logging a call so long.

    Thanks

    Thursday, May 3, 2012 6:56 AM
  • You are welcome :) Finally we found the culprit

    I would suggest to log a call with MS Premier support to fix the same. Any updating/deletion of records in Project Server database using T-SQL would need to be executed by MS Or you may get another solution to fix it.

    Thanks,


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, May 3, 2012 7:05 AM
  • One of our developers apparently know's how to do this...

    Was told to get him to do it. Will see how that pans out.

    Thanks

    Thursday, May 3, 2012 7:22 AM
  • Hi there!

    There are some Workarounds about that Timesheet Problems!

    We got something nearly similar.

    Open a Call, they can help!

    We got an Error Message > Something like "Error with Server Connection".

    There are one rejected Task, we have to send the Timesheet again with changed Values (Actuals) and a Switch of the View "My Timesheet" that works...(should be an example)

    Best Regards good Luck!

    Dennis


    Thursday, May 3, 2012 2:00 PM
  • Hi Danie

    We have the same trouble. What did you discovered about the cause for this VIOLATION KEY error ?


    Didier Maignan | http://didiermaignan.unblog.fr

    Wednesday, December 3, 2014 5:11 PM