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:
ID | Troubleshooting Step | Details |
1 | Is the Full or Incremental Load DWH job failing or both? |
|
2 | Investigate where the error is happening |
|
3 | Review the bg-dwh.logs |
|
4 | Self Service / Knowledge Base Search |
|
5 | Generate the Health Report to Review for any issues |
|
6 |
On Premise customers: The Attached SQL Query can point out the most common issues |
|
7 |
If the above doesn't help, open a case with Broadcom Support, providing the following information: |
|