none
Project data are not being pushed to the SQL database! RRS feed

  • Question

  • Hi,

    We are getting an error while pushing a particular project data to the SQL database. Currently facing this problem with only one project.

    Scenario : Created a new project ,baseline and published. Now in few of the major fields like Project Department, Project State...etc value arel not be getting updated in SQL database. Adding error details for your reference.

    Just an fyi : We recently upgraded our environment with June 2012 CU.

    Error Detail :-

    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='9c693132-2196-4c80-8b75-c9bbd61a148c' QueueMessageBody='Project UID='1ee8961c-2005-44c3-920e-f35625a4fbd7'.

    PublishType='All'' 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.'.

    Thanks

    Anuranjan Prasad


    Thanks & Regards Anuranjan Prasad

    Wednesday, January 2, 2013 12:52 PM

Answers

All replies