Incremental Load Data Warehouse Fails on table DWH_RES_PERIOD_FACTS

book

Article ID: 211839

calendar_today

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