Project Publish Error: the INSERT statement conflicted with the Foreign Key constraint

Posted By Posted by: EPM Partners on April 23, 2012

The below error can be found in the Project Server queue when a project cannot be succesfully published: General Reporting message processor failed: OR ProjectPublish Failed:  ReportingProjectChangeMessageFailed (24006) – The INSERT statement conflicted with the FOREIGN KEY constraint   Cause: In the majority of cases, the cause of this is due to baselined tasks being

Read More


Blog Posted In 

BCM mode Problem in Project Server 2010

Posted By Posted by: EPM Partners on December 14, 2011

This issue has recently affected more than one of my customers, so I thought after a few months working with Microsoft support it is definitely worth sharing; Problem: When attempting to disable BCM mode from Server Settings in a migrated Project Server 2010 environment, unchecking the BCM mode option leads to corruption in multiple project

Read More


Blog Posted In 

Error in MS Project: ‘The value you entered does not exist in the lookup table of this code. All values must be predefined in the code lookup table. Contact your server administrator to get new values

Posted By Posted by: EPM Partners on June 29, 2011

  The following error can appear in MS Project. In my case it was when I was attempting to insert sub projects into a Master Schedule. It may also appear in regards to modifying resource custom fields such as the RBS. Cause: It seems that MS Project is unable to handle custom lookup fields that

Read More


Blog Posted In 

Resetting Lost Permissions in Project Server 2010

Posted By Posted by: EPM Partners on February 26, 2011

I came across an unexplained issue recently with an ‘old’ Project Server 2010 customer, in short what happened was many of the permissions across the Project workspace sites were lost. Unfortunately the loss was triggered by performing a Playbooks (2010 version) backup of the server configuration which was even more concerning, considering that is such

Read More


Blog Posted In Comments Off on Resetting Lost Permissions in Project Server 2010

SQL Reporting Services Integration Errors

Posted By Posted by: EPM Partners on December 2, 2010

When trying to configure the SQL Reporting Services Add-in for SharePoint 2010 from Central Admin you might see the following error:   (Error Text: Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. …) Most common cause: Kerberos There are actually a few causes

Read More


Blog Posted In Comments Off on SQL Reporting Services Integration Errors

Attempts to access the PWA site return an error page

Posted By Posted by: EPM Partners on November 18, 2010

  Issue:   Attempts to access the PWA site return an error page. Further investigation revealed that a recent Windows security update failed last Thursday evening (11/11/2010) – Windows Security Update KB968389 “Extended Protection for Authentication” (http://support.microsoft.com/kb/968389).     Approach taken to recover system:   The last known good state of the Application server (MPOS2)

Read More


Blog Posted In Comments Off on Attempts to access the PWA site return an error page

Error saving projects to Project Server 2010 from 2007 client

Posted By Posted by: EPM Partners on October 25, 2010

  This is one of the first major impact 2010 issue we’ve experienced at EPM Partners, and so even though the problem is not yet closed, it’s about time it was added to the blog. Problem: For no apparent reason when attempting to Save a project from Microsoft Project Professional 2007 to the Project Server

Read More


Blog Posted In Comments Off on Error saving projects to Project Server 2010 from 2007 client

Unable to delete Published version of Project in 2010

Posted By Posted by: EPM Partners on October 25, 2010

Symptoms: Certain Projects cannot be opened in either PWA or MS Project. Oddly the same projects do not appear to exist in the Draft database, but DO appear in the Published database. Projects cannot be deleted from Server Settings after selecting the Published version and hitting delete. Errors: Delete Queue job fails and review of

Read More


Blog Posted In Comments Off on Unable to delete Published version of Project in 2010

Timesheet Error – ‘There has been an error processing a timesheet for which you are/were responsible’

Posted By Posted by: EPM Partners on September 28, 2010

Timesheet Error – ‘There has been an error processing a timesheet for which you are/were responsible’ This error will appear in the project server queue as ‘Failed and Blocking Correlation’ generally as a ‘Timesheet Review’ job type: Reason: The timesheet manager is trying to approve timesheets and due to either a large amount of traffic

Read More


Blog Posted In Blog Posted In: Troubleshooting
Blog Posted In Comments Off on Timesheet Error – ‘There has been an error processing a timesheet for which you are/were responsible’

Error Message Project Server Encountered a Problem with this Error Code 9000 Occurs

Posted By Posted by: EPM Partners on July 7, 2010

his is a new error that has been bugging me for a few weeks now: The error message “Project Server encountered a problem with this error code:9000” occurs when attempting to save a project in Project Professional 2007 client: Additionally you may receive a blank “Job failed” window when trying to check-in a project: This

Read More


Blog Posted In Comments Off on Error Message Project Server Encountered a Problem with this Error Code 9000 Occurs