Incremental Load Data Warehouse job fails intermittently fails with error:
ORA-02298: cannot validate (PPM_DWH.DWH_RES_PER_FACTS_FK1) - parent keys not found
CMN_ENABLE_CONSTRAINTS_SP('DWH_RES_PERIOD_FACTS');
END;
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ERROR ENABLING CONSTRAINT. SQLERRM : ORA-02298: cannot validate (PPM_DWH.DWH_RES_PER_FACTS_FK1) - parent keys not found
ORA-06512: at "PPM_DWH.CMN_ENABLE_CONSTRAINTS_SP", line 27
ORA-06512: at line 2
Release : 15.8.1
Component : CA PPM DATA WAREHOUSE
This is reported as DE60143
This is reported as DE60143 and is resolved in 15.9.2