When opening a project in Microsoft Project (MSP)/MS Project Interface get a couple of different errors:
Steps to Reproduce:
0. Make sure that the on the fly Rate Matrix Extraction job is turned off:
The below query should return 0.
select value from cmn_option_values
where option_id = (select id from cmn_options where option_code='PRJ_RT_RATES_EXTRACTION');
1. Create a rate matrix including the dates between 1/1/1990 - 12/31/2017 for all resources
2. Create a project and associated it to a rate matrix.
3. Staff 1 team member to the project
4. Export the project to MSP
5. Open the project XML in notepad and note that the rate dates go from the years 1984-1990 and 1990-2079.
<Rates>
<Rate>
<RatesFrom>1984-01-01T00:00:00</RatesFrom>
<RatesTo>1990-02-01T00:00:00</RatesTo>
...
</Rate>
<Rate>
<RatesFrom>1990-02-01T00:00:00</RatesFrom>
<RatesTo>2079-02-01T00:00:00</RatesTo>
...
</Rate>
</Rates>
6. Run the Rate Matrix Extraction job with the first 3 options checked
7. Export the project to MSP. The project opens.
Notice how the dates on the rates for this first role are as expected:
<Rates>
<Rate>
<RatesFrom>1984-01-01T00:00:00</RatesFrom>
<RatesTo>1990-01-01T00:00:00</RatesTo>
...
</Rate>
<Rate>
<RatesFrom>1990-01-01T00:00:00</RatesFrom>
<RatesTo>2018-01-01T00:00:00</RatesTo>
...
</Rate>
</Rates>
8. Close the project in MSP
9. In PPM, add one more resource/role to the team
10. Export the project to MSP
Expected Results: The project opens successfully in MSP and the newly added resource (from Step 8) has rate dates for the years between 1984-1990 and 1990-2079 as the initial role had after Step 5.
Actual Results: The project attempts to open, but then throws a 'SchedLink MFC Application has stopped working' error.
Notice how the dates on the rates are 1984-1900 and 1900-2079 for the second resource/role:
<Rates>
<Rate>
<RatesFrom>1984-01-01T00:00:00</RatesFrom>
<RatesTo>1900-01-01T00:00:00</RatesTo>
...
</Rate>
<Rate>
<RatesFrom>1900-01-01T00:00:00</RatesFrom>
<RatesTo>2079-06-03T00:00:00</RatesTo>
...
</Rate>
</Rates>
Caused by DE34986.
DE34986 is fixed in CA PPM 15.3 and 15.2 Patch 5 and higher.
Workaround: Run the Rate Matrix Extraction (RME) job with the first 3 options checked after adding the second resource.
Note: In order to see this fix in the new driver, (and any other CA PPM MSP Interface fixes) after upgrading Clarity PPM, the latest MSP New Driver version will also need to be installed.
MSP Related Articles:
Rate Matrix articles:
Release Notes:
Self Service Tips: