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 

Portfolio Management reports white papers

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

A number of Microsoft bloggers have recently announced some great new content for Project Server reporting and I thought that it is well worth repeating here.   Copied from Christophe’s Blog: I’m thrilled to announce the release of the following two white papers which provide step by step guidance on surfacing key Project Portfolio Management

Read More


Blog Posted In Blog Posted In: Project Server, Reporting
Blog Posted In 

Auto-publish of Task Status Updates in SP1

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

While investigating a solution for a customer who has a pretty common problem I came across another new feature to be included in Project Server 2010 Service Pack 1. The problem comes about from the requirement to regularly publish project schedules to ensure that reporting data is kept up to date, this is particularly important

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In Comments Off on Auto-publish of Task Status Updates in SP1

Resource Utilisation Report

Posted By Posted by: Laith Adel on March 10, 2011

I have been asked so many times to develop/configure a resource Utilisation report that would be simple, easy to read by users and accurate. Although Project Server comes with a nice graphical (and tabular) view of resource availably and Utilisation through Project Web Application (PWA) – “Resource Availability” , like the graph below: I find

Read More


Blog Posted In Comments Off on Resource Utilisation Report

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

How to Check the Version of SharePoint / Project Server Installed

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

It seems SharePoint 2010 gives a nice new way to say exactly what versions of the binaries are installed on any given server in your farm, this is a great enhancement from 2007 which effectively required a Windows Explorer properties check at times to be absolutely sure that all the servers had been updated! Find

Read More


Blog Posted In Blog Posted In: How to, Project Server, SharePoint
Blog Posted In Comments Off on How to Check the Version of SharePoint / Project Server Installed

How to create an out of hours calendar

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

In Microsoft Project you can create as many calendars as you like and assign these calendars to the Project or individual resources. However in the scenario where you have a task which may for some reason need to be scheduled out of normal business working hours one option is to create what is known as

Read More


Blog Posted In Blog Posted In: How to, Project Client
Blog Posted In Comments Off on How to create an out of hours calendar

Deploying and Using the Bulk Import Tool Solution Starter

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

This is a very brief overview of how to get the Bulk Import Tool Solution Starter going in your environment. Sorry no screenshots!   Basically this feature allows you to bulk update project information from an external list. It also allows you to create projects based on an external list. This is very useful if

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In Comments Off on Deploying and Using the Bulk Import Tool Solution Starter

Retaining the current schedule task start and finish dates when using my tasks in PWA

Posted By Posted by: Dan Stopher on September 24, 2010

  When using My Tasks in Project Server a Team member can submit a proposed revision to the task start and finish dates to the PM for review by updating the start and finish dates and submitting for approval. If the PM rejects the update the Team Member is notified of this by the display of the

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In Comments Off on Retaining the current schedule task start and finish dates when using my tasks in PWA