none
Plan not publishing to reporting database and not showing in capitalisation report RRS feed

  • Question

  • Hi,

    I have a certain plan which is giving the following error message in PWA after it was successfully published in MS Project to the server.

    THe plan the does not show in the excel capitalisation report (custom report) even though all tasks are capitalisation "YES" and the project itself is also capitalisation "YES".

    Any advice please??

    General
    Reporting message processor failed:
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='3c0aa63b-627e-416f-a181-47cb829c333f' QueueMessageBody='Project UID='cd04d0fa-3615-45a7-89c4-b442f8736f3a'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='25c10e7f-62a8-45c5-ba3d-68e8f00d7d1f' QueueMessageBody='Project UID='cd04d0fa-3615-45a7-89c4-b442f8736f3a'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='b2b80430-6897-4d51-b0ff-c3c47e1cb0ed' QueueMessageBody='Project UID='cd04d0fa-3615-45a7-89c4-b442f8736f3a'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='c9bfa7ca-e741-460d-a5e6-044b4ee34c8e' QueueMessageBody='Project UID='cd04d0fa-3615-45a7-89c4-b442f8736f3a'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='f40b8503-3ce4-45e9-b232-1fcba6fb522a' QueueMessageBody='Project UID='cd04d0fa-3615-45a7-89c4-b442f8736f3a'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='7e46ce6d-5fc7-4fa1-8126-ae64e5f4b6bf' QueueMessageBody='Project UID='cd04d0fa-3615-45a7-89c4-b442f8736f3a'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'.
    Queue:
    GeneralQueueJobFailed (26000) - ReportingProjectPublish.ReportProjectPublishMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='d7db335a-45f3-45d7-a660-8c821b0b7807' JobUID='22781211-1852-4c7d-9e54-4a4cefcdabc4' ComputerName='ZA01EPMPRD' GroupType='ReportingProjectPublish' MessageType='ReportProjectPublishMessageEx' MessageId='1' Stage=''. For more details, check the ULS logs on machine ZA01EPMPRD for entries with JobUID 22781211-1852-4c7d-9e54-4a4cefcdabc4.


    Regards, Jaco van der Riet Pioneer Foods (Pty) Ltd PMO

    Wednesday, December 5, 2012 1:36 PM

Answers

All replies