Load DWH job fails with "LPX-00202: could not open" error

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Load Data Warehouse (DWH) - Incremental job fails with "ORA-06502: PL/SQL: numeric or value error" "LPX-00202: could not open"

Detailed Error message below:

Failure message: NJS-0401: Execution of job failed.

Error   2/3/2020 17:35 ClarityDB - isOracle? - An error occurred executing this job entry :

  Couldn't execute SQL: BEGIN
  CMN_SAVEDROP_CREATE_INDEXES_SP('DWH_X_INV_PLAN_PER_FACTS_MV','SAVE_DROP');
  DBMS_SNAPSHOT.REFRESH('DWH_X_INV_PLAN_PER_FACTS_MV');
  CMN_SAVEDROP_CREATE_INDEXES_SP('DWH_X_INV_PLAN_PER_FACTS_MV','CREATE');
  
  CMN_GATHER_TABLE_STATS_SP('DWH_X_INV_PLAN_PER_FACTS_MV');
  
  CMN_SAVEDROP_CREATE_INDEXES_SP('DWH_X_INV_BEN_PER_FACTS_MV','SAVE_DROP');
  DBMS_SNAPSHOT.REFRESH('DWH_X_INV_BEN_PER_FACTS_MV');
  CMN_SAVEDROP_CREATE_INDEXES_SP('DWH_X_INV_BEN_PER_FACTS_MV','CREATE');
  
  CMN_GATHER_TABLE_STATS_SP('DWH_X_INV_BEN_PER_FACTS_MV');
  END;
  
  [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INTERNAL_MD. SQLERRM : ORA-06502: PL/SQL: numeric or value error
  LPX-00202: could not open "/oradb/SYS/METASTYLESHEET/ROW[NAME='kuindex'%20and%20MODEL='ORACLE']/STYLESHEET/text()" (error 263)
  ORA-06512: at "[schema].CMN_SAVEDROP_CREATE_INDEXES_SP", line 43
  ORA-06512: at line 2

Environment

Release : 15.7.1

Component : Data Warehouse

Resolution

Run the full Load DWH job. If that doesn't help, please contact Broadcom support for assistance.  

Additional Information

Reference also:

• Load DWH job failures - troubleshooting
• Data Warehouse (DWH) known issues
• Load DWH Full - When to run to prevent failures