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
CA PPM SaaS and CA PPM On Premise
Load Data Warehouse Job fails while trying to insert NULL value for INVESTMENT_NAME into DWH_PFM_INVESTMENT_MAPPING.
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.