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
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
CA PPM SaaS and CA PPM On Premise
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.
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.