Environment:
Oracle Goldengate version 21.3
Both source and target DBs are in 19c Oracle on Oracle Linux.
One of my replicats has abended. Following is the error message from view report <replicat name>
What exactly is the root cause of the replicat going to ABENDED state ?
What can I do to fix this ?
2024-10-16 15:35:59 WARNING OGG-02544 Unhandled error (ORA-26787: The row with key ("ADM_ID", "SIG_TYPE") = (24197568, CUSTOMERSTATECHANGED) does not exist in table D00PKMS.SYNCMBR_SIG
ORA-01403: no data found
ORA-01403: no data found) while processing the record at SEQNO 266917, RBA 29646272 in Integrated mode. REPLICAT will retry in Direct mode.
2024-10-16 15:35:59 WARNING OGG-01004 Canceled grouped transaction on table P_DB1_P.D00PKMS.SYNCMBR_SIG. Database error 1403, (No data found).
2024-10-16 15:35:59 WARNING OGG-01003 Repositioning to rba 29646272 in seqno 266917.
2024-10-16 15:35:59 WARNING OGG-01154 SQL error 1403 mapping source table PDB_SYN_P.D00PKMS.SYNCMBR_SIG to target tableP_DB1_P.D00PKMS.SYNCMBR_SIG. Database error: No data fou
nd.
Source Context :
SourceModule : [er.replicat.errors]
SourceID : [er/replicat/reperrors.cpp]
SourceMethod : [repError]
SourceLine : [1832]
ThreadBacktrace : [15] elements
: [/u02/oracle/goldengate/version/21.3/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
: [/u02/oracle/goldengate/version/21.3/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u02/oracle/goldengate/version/21.3/bin/../lib/libgglog.so(_MSG_QualTableName_QualTableName(CSourceContext*, int, ggs::gglib::ggapp::CQualDBObjName<(DBObjTy
pe)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition))]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(ggs::er::ReplicatContext::repError(short, int, char const*, extr_ptr_def*, ggs::gglib::gglcr::CommonLCR con
st*, std_rec_hdr_def*, char*, ObjectMetadata*, bool))]
: [/u02/oracle/goldengate/version/21.3/bin/replicat()]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(ggs::er::ReplicatContext::processRecord(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*,
extr_ptr_def*&, extr_ptr_def*&, bool&, int&, bool, RepCsn&))]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(ggs::er::ReplicatContext::processReplicatLoop())]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(ggs::er::ReplicatContext::run())]
: [/u02/oracle/goldengate/version/21.3/bin/replicat()]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/u02/oracle/goldengate/version/21.3/bin/replicat(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/u02/oracle/goldengate/version/21.3/bin/replicat()]
2024-10-16 15:35:59 ERROR OGG-01296 Error mapping from PDB_SYN_P.D00PKMS.SYNCMBR_SIG to P_DB1_P.D00PKMS.SYNCMBR_SIG.
================================================================================
DBA_APPLY_ERRORS
1. Error:26,787 flags:0x0014 startseq/rba:266,917/29,646,272 errorseq/rba:266,917/29,646,272 localtxn:89.21.1464067 errmsg:ORA-26787: The row with key ("ADM_ID", "SIG_TYPE") = (24197568
, CUSTOMERSTATECHANGED) does not exist in table D00PKMS.SYNCMBR_SIG
ORA-01403: no data found
ORA-01403: no data found
2. Error:26,787 flags:0x0014 startseq/rba:266,917/29,657,960 errorseq/rba:266,917/29,657,960 localtxn:9.7.1408075 errmsg:ORA-26787: The row with key ("ADM_ID", "SIG_TYPE") = (53188319,
CUSTOMERSTATECHANGED) does not exist in table D00PKMS.SYNCMBR_SIG
ORA-01403: no data found
ORA-01403: no data found
3. Error:26,787 flags:0x0014 startseq/rba:266,917/29,682,971 errorseq/rba:266,917/29,682,971 localtxn:92.22.1543987 errmsg:ORA-26787: The row with key ("ADM_ID", "SIG_TYPE") = (53187920
, CUSTOMERSTATECHANGED) does not exist in table D00PKMS.SYNCMBR_SIG
ORA-01403: no data found
ORA-01403: no data found
4. Error:26,786 flags:0x0014 startseq/rba:266,917/29,698,739 errorseq/rba:266,917/29,698,739 localtxn:66.29.1168653 errmsg:ORA-26786: A row with key ("ADM_ID", "SIG_TYPE") = (566081, CU
STOMERSTATECHANGED) exists but has conflicting column(s) "SIGNATURE" in table D00PKMS.SYNCMBR_SIG
ORA-01403: no data found
ORA-01403: no data found