Load Data Warehouse Job failed with - ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_PFM_INVESTMENT_MAPPING)
Article ID: 103272
Clarity PPM On Premise
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
Load Data Warehouse Job fails while trying to insert NULL value for INVESTMENT_NAME into DWH_PFM_INVESTMENT_MAPPING.
CA PPM SaaS and CA PPM On Premise
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.