ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 144294


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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
  [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


Release : 15.7.1

Component : Data Warehouse


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

Additional Information

Reference also: