Hello experts,
Till day before yesterday gg extract/relicate was working fine but yesterday replicate process(R_EIM1) keep on abending with below error in log file.
2020-07-10T09:36:41.278-0700 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: REPLICAT R_EIM1 started.
2020-07-10T09:36:41.292-0700 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Opened trail file /ogg/eimd3/replicat_eim1/op000000003 at 2020-07-10 09:36:41.292728.
2020-07-10T09:36:41.295-0700 WARNING OGG-02761 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Source definitions file, /oracle_homes/appogg/oracle/product/12.1.2.1.0/oggeimd/dirdef/E_CCB1.def, is ignored because trail file /ogg/eimd3/replicat_eim1/op000000003 contains table definitions.
2020-07-10T09:36:41.299-0700 INFO OGG-03506 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: The source database character set, as determined from the trail file, is CESU-8.
2020-07-10T09:36:41.305-0700 INFO OGG-06505 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: MAP resolved (entry CISADM.CI_AUDIT): map "CISADM"."CI_AUDIT", TARGET CCB_STAGE.CI_AUDIT, KEYCOLS (AUDIT_ID, CRE_DTTM),INSERTALLRECORDS, COLMAP ( USEDEFAULTS, SRC_CDC_CHNG_DTTM = @GETENV("GGHEADER" , "COMMITTIMESTAMP"), CDC_WINDOW_ID = @NUMSTR (@DATE ("YYYYMMDDHHMISS", "YYYY-MM-DD HH:MI:SS", @DATENOW())), ETL_RCRD_UPDT_DTTM = @DATENOW(), ETL_DML_CMD_TYPE = @STRSUB(@GETENV("GGHEADER" , "OPTYPE"),"TRUNCATE","DELETE"), CDC_APPLY_LAG_MS = @GETENV("LAG", "MSEC") ).
2020-07-10T09:36:46.409-0700 INFO OGG-02756 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: The definition for table CISADM.CI_AUDIT is obtained from the trail file.
2020-07-10T09:36:46.409-0700 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Using the following key columns for target table CCB_STAGE.CI_AUDIT: AUDIT_ID, CRE_DTTM.
2020-07-10T09:36:46.409-0700 INFO OGG-06505 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: MAP resolved (entry CISADM.CI_AUDIT): map "CISADM"."CI_AUDIT", target OGG_TEMP_CCB.J$CI_AUDIT, KEYCOLS (AUDIT_ID, CRE_DTTM, WINDOW_ID, ETL_RCRD_LD_DT), INSERTALLRECORDS, COLMAP ( AUDIT_ID = AUDIT_ID, CRE_DTTM = CRE_DTTM, WINDOW_ID = @NUMSTR (@DATE ("YYYYMMDDHHMISS", "YYYY-MM-DD HH:MI:SS", @DATENOW())), ETL_RCRD_LD_DT = @DATE ("YYYY-MM-DD", "YYYY-MM-DD HH:MI:SS", @DATENOW()) ).
2020-07-10T09:36:46.930-0700 WARNING OGG-06439 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: No unique key is defined for table J$CI_AUDIT. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2020-07-10T09:36:46.930-0700 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Using the following key columns for target table OGG_TEMP_CCB.J$CI_AUDIT: AUDIT_ID, CRE_DTTM, WINDOW_ID, ETL_RCRD_LD_DT.
2020-07-10T09:36:46.930-0700 INFO OGG-03010 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Performing implicit conversion of column data from character set CESU-8 to UTF-8.
2020-07-10T09:36:47.195-0700 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Aborted grouped transaction on CCB_STAGE.CI_AUDIT, Database error 1403 (No data found).
2020-07-10T09:36:47.195-0700 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Repositioning to rba 33910 in seqno 3.
2020-07-10T09:36:47.195-0700 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: SQL error 1403 mapping CISADM.CI_AUDIT to CCB_STAGE.CI_AUDIT No data found.
2020-07-10T09:36:47.195-0700 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Error mapping from CISADM.CI_AUDIT to CCB_STAGE.CI_AUDIT.
2020-07-10T09:36:47.284-0700 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: Reading /ogg/eimd3/replicat_eim1/op000000003, current RBA 33,910, 0 records, m_file_seqno = 3, m_file_rba = 34,331.
2020-07-10T09:36:47.292-0700 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, R_EIM1.prm: PROCESS ABENDING.
My initial research in oracle support side says it is due to presence of foreign key constraints with on delete cascasde option but I could not find any foreign key to this CI_AUDIT table.I have even tried below parameter in replicate parameter file
DBOPTIONS DEFERREFCONST but that is not helping to resolve this issue.
Regards
Dhritiman Deb
Regards
Dhritiman Deb