Load DWH job fails: ORA-00904: "custom attribute": invalid identifier - Unchecking/rechecking in DWH doesn't help

book

Article ID: 196989

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

  • We are unable to compete the Full or Incremental Load Data Warehouse (DWH) job.
  • KB:108003 - unchecking/rechecking the attribute for inclusion in DWH doesn't help
  • In Home -> Report and Jobs ->Logs, the following is seen in the error message:

User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_INVESTMENT

  • In the bg-dwh.logs:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_INV_INVESTMENT). SQLERRM : ORA-00904: "custom attribute": invalid identifier
ORA-06512: at line 31

Environment

Release : All Supported Releases

Component : CA PPM DATA WAREHOUSE

Resolution

  • If the steps in KBs 108003 don't help: Rebuild the DWH - see steps at 4413
  • Note: Prior to rebuilding the DWH, it's recommended to search in our Knowledge base for other known causes of the invalid identifier 
    • See KB: 141061 for tips on how to optimize use of Self Service for Clarity 
    • You can also open a support case to check with Broadcom support on this particular error

Additional Information

If the above doesn't help, see 196962 - How to troubleshoot Load DWH Job Failures