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.

Actual Costs missing from DWH intermittently when jobs are scheduled incorrectly

book

Article ID: 122439

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The Total Actual Costs for several projects and tasks are sporadically missing from the Data Warehouse (DWH) database.

Cause

This can be attributed to the way in which the jobs are scheduled as the incremental Load DWH job uses the investment last updated date attribute to compare and calculate what needs to be updated in the DWH database.

The incremental run differs from a full Load DWH run, which truncates and rebuilds the tables. Any querying of the DWH during a full run will not have data present.

Resolution

Run the below jobs (which influence the project attributes) and make sure they complete before the Load DWH job is run.

  • Investment Allocation
  • Purge Temporary Aggregated Data
  • Update Aggregated Data

Contact Broadcom support if you need the scheduled Clarity jobs reviewed.

Additional Information

Be sure the time zones are synchronized on the application server and database server as this can lead to data not being processed.

Reference also the Administration section of the documentation.