ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Incremental Load Data Warehouse Fails on table DWH_RES_PERIOD_FACTS
Article ID: 211839
Updated On:
Products
Clarity PPM On Premise
Issue/Introduction
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
Cause
This is reported as DE60143
Environment
Release : 15.8.1
Component : CA PPM DATA WAREHOUSE
Resolution
This is reported as DE60143 and is resolved in 15.9.2
Feedback
Yes
No
Powered by
