How to Migrate Projects to PWA & Retain Cross-Project Dependencies

Posted By Posted by: Dan Stopher on April 22, 2015

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

Read More


Blog Posted In Blog Posted In: How to, Troubleshooting
Blog Posted In 

Error and Solution: The INSERT statement conflicted with the FOREIGN KEY constraint

Posted By Posted by: Peter Williams on April 13, 2015

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”.

Read More


Blog Posted In