Context: As we work with clients to leverage the benefits of Project Server, clients frequently ask how they can migrate locally-saved master schedules to Project Server while retaining cross-project dependencies. The objective of this blog is not to cover the broader topic of schedule migration and general best practice, or how to create cross project dependencies (great
We recently received an issue where our client was unable to see a project in their Project Status Report. They had tried publishing the project and received a “Failed But Not Blocking Correlation”. The error below was found in the project server queue: ReportingProjectChangeMessageFailed (24006) – The INSERT statement conflicted with the FOREIGN KEY constraint “FK_MSP_EpmAssignmentByDay_ProjectUID_AssignmentUID”.