Project Attribute Value Missing from DWH when Status Report is Edited During DWH Incremental Load

Products

• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce:

1. Create an OData interface for the environment.
2. Create a process on the Status Report object, that updates the Project Overall Status when the report is Final.
3. On the Project object, create an object based multi-valued lookup and add it to the DWH.
4. Update the Project instance with a value in the MVL field you created.
5. On the same Project instance, create a Status Report instance.
6. Run the DWH Incremental job.
7. When the job is completed, validate you can see the Project Instance MVL value and the Status Report instance information in the OData V4 interface.
8. Run the DWH Incremental job again.
9. While the DHW Incremental job is running, edit the Status Report instance and Save the edits.
10. When the job is completed, validate you can see the Project Instance MVL value and the Status Report instance information in the OData V4 interface.

Expected Results:

• DWH contains the Project Instance information with the MVL field value.
• DWH contains the Status Report Instance information.

Actual Results:

• DWH contains the Project Instance information, but NOT the MVL field value.
• DWH contains the Status Report instance information.

Environment

Release : 15.9.1

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

DE60023

Resolved in 15.9.2