t2t_KDD_CASE_EXTERNAL_ENTITY_MEMBERSHIP has been failed with ORA-02291 (Doc ID 2776180.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Symptoms

t2t_KDD_CASE_EXTERNAL_ENTITY_MEMBERSHIP has been failed with ORA-02291.

Log Message here 1: May 3, 2021 at 4:21:22 PM CEST||DEBUG||ClsUBatchLoader::Bulk, DEBUG INFO,insert query for load data formulated =insert into KDD_CASE_EXTRNL_NTITY_MBRSHP(EXTRL_NTITY_LIST_SEQ_ID,CASE_INTRL_ID,LIST_ADD_DT,LIST_DESC_TX,LIST_MATCH_TX,LIST_NTITY_TYPE_CD,LIST_RMVL_DT,LIST_SRC_CD,DATA_DUMP_DT,CASE_EXTRL_NTITY_SEQ_ID)SELECT CM_EXTERNAL_ENTITY_LIST_SEQ.nextval,FCC_PRECASE_CASE_MAP.V_CASE_ID,FCC_EXTERNAL_NTITY_MEMBERSHIP.LIST_ADD_DT,FCC_EXTERNAL_NTITY_MEMBERSHIP.LIST_DESC_TX,FCC_EXTERNAL_NTITY_MEMBERSHIP.LIST_MATCH_TX,FCC_EXTERNAL_NTITY_MEMBERSHIP.LIST_NTITY_TYPE_CD,FCC_EXTERNAL_NTITY_MEMBERSHIP.LIST_RMVL_DT,FCC_EXTERNAL_NTITY_MEMBERSHIP.LIST_SRC_CD,FCC_EXTERNAL_NTITY_MEMBERSHIP.MIS_DATE,to_char(FCC_EXTERNAL_NTITY_MEMBERSHIP.EXTERNAL_ENTITY_SKEY) FROM Fcc_Precase inner join fcc_precase_case_map on Fcc_Precase.n_event_correlation_skey=fcc_precase_case_map.n_event_correlation_skey INNER JOIN FCC_CORRELATION_ENTITY_MAP ON Fcc_Precase.n_event_correlation_skey=FCC_CORRELATION_ENTITY_MAP.n_event_correlation_skey AND FCC_CORRELATION_ENTITY_MAP.V_ENTITY_TYPE='EXTERNAL_ENTITY' and ( (Fcc_Precase.n_run_skey <> fcc_precase_case_map.n_run_skey and Fcc_Precase.n_run_skey=FCC_CORRELATION_ENTITY_MAP.n_run_skey) or Fcc_Precase.n_run_skey=fcc_precase_case_map.n_run_skey) INNER JOIN fcc_external_ntity_membership on fcc_external_ntity_membership.External_Entity_Skey=FCC_CORRELATION_ENTITY_MAP.N_ENTITY_SKEY WHERE ((1=1) AND (1=1) AND (9=9)) AND Fcc_Precase.f_promotion_flag='Y' and Fcc_Precase.f_process_flag='N' and Fcc_Precase.N_RUN_SKEY in (select fcc_batch_run.n_run_skey from fcc_batch_run where fcc_batch_run.v_batch_run_id in ( 'ECMINFO_1601566571496_20210430_1') AND fcc_batch_run.N_RUN_STATUS = 1) LOG ERRORS INTO KDD_CASE_EXTRNL_NTITY_MBRSHP$ ('ECMINFO_1601566571496_20210430_1_Task169') REJECT LIMIT 0

Log Message here 1: May 3, 2021 at 4:21:22 PM CEST||DEBUG||Executing Insert Query
FAILED: ORA ERROR : ORA-02291: integrity constraint (PRD_OFSAAECM.FK_142_1) violated - parent key not found

Log Message here 1: May 3, 2021 at 4:21:23 PM CEST||SEVERE||ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. ERROR Message: ORA-02291: integrity constraint (PRD_OFSAAECM.FK_142_1) violated - parent key not found

Log Message here 1: May 3, 2021 at 4:21:23 PM CEST||DEBUG||ClsUBatchLoader::Bulk : Error Messaage : ORA-02291: integrity constraint (PRD_OFSAAECM.FK_142_1) violated - parent key not found

Log Message here 1: May 3, 2021 at 4:21:23 PM CEST||DEBUG||ClsUTableToTableLoad::Bulk, Number of rows loaded: 1
Log Message here 1: May 3, 2021 at 4:21:23 PM CEST||SEVERE||Loading Failed, Number of erroneous records exceeded the reject limit
Log Message here 1: May 3, 2021 at 4:21:23 PM CEST||DEBUG||ClsUTableToTableLoad::updateETLLoadHistory, INFO, insert query for ETLLoadHistory table : INSERT into ETLLoadHistory values('ECMINFO_1601566571496_20210430_1','Task169','ECMINFO','ECM_Source',1,'KDD_CASE_EXTRNL_NTITY_MBRSHP','t2t_KDD_CASE_EXTERNAL_ENTITY_MEMBERSHIP',to_date('20210430','YYYYMMDD'),to_date('2021-5-3 16:21:00','yyyy-mm-dd HH24:mi:ss'),to_date('2021-5-3 16:21:00','yyyy-mm-dd HH24:mi:ss'),0,0,0,1,'LF',0,'',1,null,null,null,null,null,'t2t_KDD_CASE_EXTERNAL_ENTITY_MEMBERSHIP',0,'NO')

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.