Load Data Warehouse Job failed with - ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_PFM_INVESTMENT_MAPPING)

book

Article ID: 103272

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Both Full or Partial Load Data Warehouse job failed with given error message:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_PFM_INVESTMENT_MAPPING). SQLERRM : ORA-01400: cannot insert NULL into ("XXXXXXXXXX"."DWH_PFM_INVESTMENT_MAPPING"."INVESTMENT_NAME") 
ORA-06512: at line 31 

Cause

Load Data Warehouse Job fails while trying to insert NULL value for INVESTMENT_NAME into DWH_PFM_INVESTMENT_MAPPING.

Environment

CA PPM SaaS and CA PPM On Premise

Resolution


a) Execute given query to identify which Investments / Portfolios are impacted with NULL Investment Name:
     - select * from INV_INVESTMENTS where NAME is null
     - select * from DWH_PFM_INVESTMENT_MAPPING_V where INVESTMENT_NAME is null 

b) Once identified navigate to impacted Investment to populate the missing NAME field for the Project and Synchronize Portfolios.

c) Rerun Load Data Warehouse with (Full Load) option.