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

Document ID : KB000103272
Last Modified Date : 25/06/2018
Show Technical Document Details
Issue:
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 
Environment:
CA PPM SaaS and CA PPM On Premise
Cause:
Load Data Warehouse Job fails while trying to insert NULL value for INVESTMENT_NAME into DWH_PFM_INVESTMENT_MAPPING.
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 filed for the Project and Synchronize Portfolios.

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