Max % Load is not exporting to the MSP New Driver when Windows regional setting is not English

Document ID : KB000007561
Last Modified Date : 21/04/2018
Show Technical Document Details
Issue:

Even though Microsoft Project (MSP) Assignment Units Mapping with PPM Assignment 'Max % Load' is checked in PPM, Max % Load is not exporting to MSP when Windows regional setting is not set to English. 

Steps to Reproduce

Prerequisites:

  • Non English MSP2013 SP1 (Example: Portuguese or Spanish) with a supported Microsoft Project Update
  • Windows language: English with non English Regional setting (Example: Portuguese or Spanish)
  1. Go Administration -> Project Management->Settings 
  2. Check 'MSP Assignment Units Mapping with PPM Assignment 'Max % Load'' 
  3. Save the change
  4. Go to Home -> Projects and create a new project
  5. Add one team member to the project
  6. Create a task and assign the resource to the task
  7. Change the Max % Load of the assignment to 50%
  8. Export the project to MSP
  9. Double click on the task and view the Units for the Assignment

Expected Results: Units matches the Max % Load set for the assignment (in this example, 50%).

Actual Results: Units doesn't reflect the 'Max % Load' for the assignment (it will show as 0% regardless of what is set on the PPM side) as the Max % Load does value is not exported to MSP.

Environment:
This issue applies to Microsoft Project 2013 with 14.4, 15.1, and 15.2, and 15.3 MSP New Driver
Cause:

This is caused by DE33331

Resolution:

This issue is fixed in CA PPM 15.4 and also fixed in the following patches (and higher) 15.1 patch 8, 15.2 patch 7, and 15.3 patch 2.

Important: The latest supported Microsoft Project update must also be installed in order to reflect the fix, as a related MSP defect was fixed in the Microsoft Project July 2017 update (MSP2013: KB3213538 and MSP2016: KB3203476). 

Workaround: 

Change the OS level setting of 'Decimal symbol from comma ',' to period '.'

Steps to implement the workaround:
  • Go to Control Panel->Region->
  • Click the 'Additional Settings' button
  • Change Decimal symbol value to '.'
Additional Information:

Reference TEC1830355 for more information on supported Microsoft Project updates with the MSP New Driver
Reference KB000071385 - CA PPM and MSP integration - List of Knowledge Documents
Reference KB000015956 - CA PPM and MSP integration known defects - Support Technical Document Index