Call Us Today! 1-800-895-3254
[email protected]
Microsoft Training
Integent offers a comprehensive portfolio of training services, with an ideal fit for every organization. Ranging from general courses to custom solutions, we have you covered.
Learn About TrainingSee Full list of Courses
Microsoft Consulting
Integent provides consulting services for a variety of Microsoft applications including Microsoft Project, Project Online, Project for the Web, Dynamics 365, and Microsoft SharePoint.
Learn About Consulting
Microsoft Support
Microsoft technologies set the standard for project portfolio management, business applications, collaboration, and more. Integent has flexible solutions to support every customer.
Learn About Support
Microsoft Project
Integent has the knowledge and experience to help design and deploy a solution to help your organization manage projects and resources more effectively
Learn More About Microsoft Project
Microsoft Dynamics 365
Integent can help you nsure business continuity with a custom cloud solution that connects sales, service, finance, and operations teams to deliver results.
Learn More About Dynamics 365
Microsoft SharePoint
SharePoint is Microsoft’s collaboration platform that is a place where team members can communicate, exchange data, share files and much more.
Learn More About Microsoft SharePoint
Microsoft Power Platform
Consisting of Power BI, Power Apps, Power Automate and Power Virtual Agents, the Microsoft Power Platform helps streamline and improve business functions.
Learn More About The Power Platform
About Integent
Integent was founded in 2009 on the principles of building long-lasting relationships with customers, exceeding expectations, and providing outstanding customer service. 

We’re dedicated to providing a customized solution backed by our knowledgeable team of Microsoft experts.
Discover What Makes Us Different
GSA Schedule
Integent is GSA Schedule Contract holder. A GSA schedule helps simplify selling our services to government customers.
Read More Here
Stay informed on Integent’s latest company updates and other important industry information. Our passion is customer success.
Read The Latest News
Learning new software doesn’t have to be difficult with our library of dozens of free training videos. Our video training always has something new.
Browse Our Training Video Library
Our industry experts share best practices and common pitfalls to avoid, in order to get the most out of your technology solutions.
Discover More

September 25, 2014

Error: ReportingProjectChangeMessageFailed with Microsoft Project Server 2010


We recently had a customer who was receiving the error below when publishing one of their projects.  The error was a Reporting job fail, therefore, the reporting database was not reflecting the correct information for the project.  This error is related to baseline records containing incorrect values for certain fields, such as a blank date value rather than N/A, or a blank Work value instead of some numeric value.  In short, the issue is ghost or orphan baseline records.  We performed the procedure below to resolve this issue:


The Error

: ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "2010_PWA_Reporting_DB", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='30902cda-a8fd-43e8-b465-c43711e0c015' QueueMessageBody='Project UID='6c602bd4-7ccb-4b15-a393-386bc8fb010f'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "2010_PWA_Reporting_DB", table "dbo.MSP_EpmTask". The statement has been terminated.'.

The Fix

    1. Run the query below to confirm there are indeed orphan records:

USE ProjectServer_Draft -- specify the appropriate draft database

select PROJ_NAME, MTB.PROJ_UID,TASK_UID,TB_BASE_NUM from MSP_TASK_BASELINES MTB inner join MSP_PROJECTS MP on MTB.proj_uid=MP.proj_uid where TASK_UID not in (select TASK_UID from MSP_TASKS)

    1. Run the scripts below to delete the orphan records

-- Script to run on the draft DB

USE ProjectServer_Draft -- specify your draft database

delete from MSP_TASK_BASELINES where TASK_UID not in (select TASK_UID from MSP_TASKS)

-- Script to run on the published DB

USE ProjectServer_Published -- specify your published database

delete from MSP_TASK_BASELINES where TASK_UID not in (select TASK_UID from MSP_TASKS)

  1. Have any user that has opened the affected project clear their local cache in order to prevent the issue from recurring
  2. Republish the project to confirm the Reporting queue job completes successfully

Be sure to comment or Contact Us with any questions.

Good Luck!


© Copyright 2023 | | All Rights Reserved
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram