Clarity PPM: Actual Costs Missing from DWH intermittently

Document ID : KB000122439
Last Modified Date : 05/12/2018
Show Technical Document Details
Issue:
The Total Actual Costs for several projects are sporadically missing from the DWH database.
 
Cause:

This can be attributed to the way in which the jobs are scheduled as the incremental Load DWH job uses the investments' last updated date attribute to compare and calculate what needs to be updated in the DWH database versus a full Load DWH run, which truncates and rebuilds the tables.

 

Resolution:

Please contact Support if you need the scheduled Clarity jobs reviewed.

The jobs that influence the project attributes are:

-Investment Allocation 
-Purge Temporary Aggregated Data 
-Update Aggregated Data

This is still under investigation for root cause.