Tips on how to debug Load Data Warehouse (DWH) Job failures to uncover root cause/fix.
If just the incremental is failing: Try running the Full load, then see if the incremental job completes successfully.
TIP: Review the following KB: Load DWH Full - When to run to prevent failures to determine if the issue is due to the full Load needing to be run.
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: You can also check 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:
Review the Health Report to review for any issues
The SQL query attached to this KB can point out the most common issues:
There are at times a rebuild of the DWH may be needed. See the following KB When to rebuild the Data Warehouse (DWH) database for some times where this may be required.
If the above doesn't help, open a case with Broadcom Support, providing the following information:
Output of below queries can also help expedite troubleshooting:
SELECT * FROM dwh_cfg_audit ORDER BY dw_load_start_date DESC