none
Timesheet submission error RRS feed

  • Question

  • Hi,

    The following error is encountered when submitting a timesheet for approval.

    ReportingTimesheetSaveMessageFailed (24014) - Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (f0982bab-1aca-e311-9fe7-00155d012e45, 77da50d1-06aa-4e51-b8b7-7dd54f440594). The statement has been terminated.. Details: id='24014' name='ReportingTimesheetSaveMessageFailed' uid='348e6f6c-a2d6-e311-a046-00155d012e45' QueueMessageBody='TimesheetUid='aeea9941-25d5-e311-82cb-00155d012e45'' Error='Violation of UNIQUE KEY constraint 'UK_MSP_Timesheet'. Cannot insert duplicate key in object 'dbo.MSP_Timesheet'. The duplicate key value is (f0982bab-1aca-e311-9fe7-00155d012e45, 77da50d1-06aa-4e51-b8b7-7dd54f440594). The statement has been terminated.'.
    • Queue:
    • GeneralQueueJobFailed (26000) - ReportingTimesheetSave.ReportTimesheetSaveMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='358e6f6c-a2d6-e311-a046-00155d012e45' JobUID='ceb7576c-a2d6-e311-a046-00155d012e45' ComputerName='75db8f0b-5cb0-412b-8513-12e8840aedb4' GroupType='ReportingTimesheetSave' MessageType='ReportTimesheetSaveMessageEx' MessageId='1' Stage='' CorrelationUID='acdb8e9c-ebe8-e0f8-aedb-451d2c43943c'. For more details, check the ULS logs on machine 75db8f0b-5cb0-412b-8513-12e8840aedb4 for entries with JobUID ceb7576c-a2d6-e311-a046-00155d012e45
    Thursday, May 8, 2014 11:26 AM

Answers

  • Hi Jaco Van der Riet,

    This looks like issue with orphan records in reporting database.

    Use this query to find the orphan timesheet records in reporting DB

      SELECT RESOURCENAME, PERIODNAME, TIMESHEETUID FROM MSP_TIMESHEET AS MT

    INNER JOIN MSP_TIMESHEETPERIOD AS MTP

    ON MT.PERIODUID=MTP.PERIODUID

    INNER JOIN MSP_TIMESHEETRESOURCE AS MTR

    ON MT.OWNERRESOURCENAMEUID=MTR.RESOURCENAMEUID

    WHERE TIMESHEETUID NOT IN

    (SELECT TS_UID

    FROM <ProjectServer_Published>.DBO.MSP_TIMESHEETS

    After you remove the orphan timesheet records in Reporting DB, Timesheet save job would be successful.

    Cheers Troubleshooting

    Phani

    Thursday, May 8, 2014 2:48 PM