ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Microsoft Project Scheduler tool deletes rows from 'nbi_proj_res_rates_and_costs' table

book

Article ID: 142035

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Microsoft Project Scheduler tool deletes internal task id rows from 'nbi_proj_res_rates_and_costs' table when a project is open in it while 'On-the-fly Rate Matrix' is enabled in Clarity PPM.


STEPS TO REPRODUCE:

1. In the Clarity PPM enable 'On-the-fly Rate Matrix'.
2. Create a project and allocate two labor resources who have rates defined for them in Rate Matrix, assign them to a single Task.
3. In the 'nbi_proj_res_rates_and_costs' table four rows of data are created (each resource having an entry for the internal task id as well task_id: -1) which is expected.
4. Open the Project created in step two in Microsoft Project scheduler tool and observe that the rates are populated in MSP.
5. Check the entries in 'nbi_proj_res_rates_and_costs' table.

Expected: 

All rows for the resources in 'nbi_proj_res_rates_and_costs' table are intact.

Actual:

In the 'nbi_proj_res_rates_and_costs' table all the rows which have the internal taskids are deleted and the remaining ones are those rows with Task_id = -1

Cause

Caused by Defect id: DE50808

Environment

Release : (15.4.1,15.6.1, 15.7, 15.7.1)

Component : CA PPM APPLICATION

Resolution

Fix targeted for Clarity PPM 15.7.1 Patch 1