Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Replicat abended with ORA-26787.. The row with key does not exist in table..

York35Oct 16 2024 — edited Oct 16 2024

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
Comments
Post Details
Added on Oct 16 2024
0 comments
39 views