Tips on how to debug Load Data Warehouse (DWH) Job failures to uncover root cause/fix
Release : All Supported Releases
Component : CA PPM DATA WAREHOUSE
See the below table for troubleshooting steps:
In the Clarity UI, go to Administration → Data Warehouse.
Click on the Load Start Date label to order by the Load Start Date descending.
This tells you the table the DWH failed on
On Premise customers, if you want to do this via a query:
Run SELECT * FROM dwh_cfg_audit ORDER BY dw_load_start_date DESC
The first record will have the table that the load aborted on
Run SELECT * FROM dwh_cmn_error_message
This should give you the error and the statement that was running
Once you have as much information as possible regarding the exact error causing the issue, search in the Support Knowledge base for any known issues related to that error:
Output of below queries can also help expedite troubleshooting:
SELECT * FROM dwh_cfg_audit ORDER BY dw_load_start_date DESC