search cancel

Load DWH job failed after the upgrade to 16.0.2

book

Article ID: 244032

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The Load DWH job failed after the upgrade to 16.0.2 from 15.8.1. Please see the error below and attached log for the detailed info on the error

Check for Missing Indexes (O) - An error occurred executing this job entry : Couldn't execute SQL: BEGIN  DWH_CREATE_MISSING_ODF_IDX_SP (    P_DBLINK => 'pncl'  );END;[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE CREATING INDEXES. SQLERRM : ORA-00972: identifier is too longORA-06512: at "NIKUDBA.DWH_CREATE_MISSING_ODF_IDX_SP", line 100ORA-06512: at line 2

Environment

Release : 16.0.2

Component : Clarity Data Warehouse

Resolution

Oracle Compatibility to be 12.2+ in DWH schema.

The below two article specified the resolution of the issues .

https://community.bonitasoft.com/questions-and-answers/migration-issue-oracle-ora-00972-identifier-too-long

https://oracle-base.com/articles/12c/long-identifiers-12cr2