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

book

Article ID: 144294

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse - Incremental job fails with

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
  

Cause

TBD

Environment

Release : 15.7.1

Component : CA PPM SAAS APPLICATION

Resolution

Run the full Load DWH job to see if the issue can be reproduced.

If so, the SaaS DBA team can be contacted by the Support team to request an investigation into the root cause.