The Load Datawarehouse Job Execution Finished However the CA PPM Advanced Reporting Ad Hoc Views and Reports are Still Showing Inconsistent Results

Article Id: 102692

Status: Published

Updated On: 27-07-2018 12:56

Products:

CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM

Issue/Introduction:

Sometimes Ad Hoc views and reports generate less records than expected or show inconsistent results in the data.
This could happen even though you have run the Load DWH job and the logs display job execution completion and checked the PPM jobs sequence to ensure everything is ok.

Environment:

Release:
Component: ODJSP

Resolution:

If selected a Full Load rebuilds the Data Warehouse from scratch. If the full load option is not selected, the DWH job only looks for incremental changes since the last time you ran it. Thus to troubleshoot data issues in Ad Hoc views and reports, or get a full DWH load complete result set, run the DWH job with the full load option selected. Then run the report again and check the results are ok.