Baseline incorrect in Microsoft Project

Document ID : KB000028699
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

 

When a project is baselined in MSP, the baseline data becomes corrupted when the project is saved and opened again in MSP.

The baseline work total for project, tasks and assignments may be increased, reduced, while the daily hours from the time-scaled task usage detail view either show blank or are incorrect for certain days.

 

Steps to Reproduce:

  1. Create a project in CA PPM, add a resource to the team
  2. Create a new task with 5 days duration (Monday to Friday)
  3. Assign the resource to the task, set Loading Pattern to Uniform. The ETC for the assignment in this example is 40 hours, that is 8 hours a day
  1. Open project in MSP
  1. Set a new baseline in MSP for the entire project
  1. Go to Tasks > Task Usage view, display the Baseline Work column; configure the time-scaled view to show both Work and Baseline Work. The Baseline Work column is showing 40 hours for the task, 40 hours for the assignment, 40 hours for the project; 8 hours a day in the TSV, as expected.
  1. Save this view as 'My Baseline View'
  1. Save the project back to CA PPM
  1. Without making any change in CA PPM, open the project to MSP and go to the 'My Baseline View'

 

Expected Result: The Baseline Work column is showing 40 hours for the task, 40 hours for the assignment, 40 hours for the project; 8 hours a day in the TSV as seen on step 6

Actual Result: The Baseline Work column is showing 40 hours for the task, 32 hours for the assignment, 40 hours for the project; in the TSV, Friday is showing 6.4 hours while other days show 8 hours 

 

After setting Project baseline and before saving to CA PPM/XML file:

Capture.JPG 

 

After opening the project to MSP again:

capture2.jpg

 

Cause:

This problem is caused by a Microsoft Project issue where baseline information is not saved and loaded correctly using the XML format. See Microsoft KB: KB2956091 for more information. It can be reproduced by baselining, saving and reopening a project from MSP to an XML file.

The MSP drivers for CA PPM 14.1 and above save projects using the XML format. Once the issue is fixed by Microsoft, CA PPM users will no longer experience this problem using the 14.x new drivers.

Workaround:

Create the baseline in PPM. 

Resolution:

    • This issue has been fixed by Microsoft Project for MSP 2013 only as part of February 2015 Update: KB2956091. This has not been resolved yet for MSP2010. 
    • The best practice in using baselines with MSP and PPM is to create baselines in PPM.  

 

Additional Information:

- See KB TEC1503689 if you are running into an issue baseline usage not saving back to PPM. 

Baseline Usage is not saving back to PPM when baeline is created in MSP using New Driver