Load Data Warehouse job failed with - EXCEPTION IN DWH_DIM_LOAD (DWH_INV_PROJECT)

Document ID : KB000098913
Last Modified Date : 31/05/2018
Show Technical Document Details
Issue:
Load Data Warehouse job with <Full Load> option failed:
[Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_INV_PROJECT). SQLERRM : ORA-01427: single-row subquery returns more than one row
 
Environment:
CA PPM SaaS and CA PPM On Premise
Cause:
This is because the subquery to DWH_PROJECT_V view available under PPM Schema returned more than one row resulting the parent SELECT query to fail.
Resolution:
Going through each custom attribute on PROJECT object once by one to identify the one causing failure and reset it.
Rerun Load DWH job with <Full load> option to verify.