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 Nov 14 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.PALLET_HDR_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 PDB_PKMS.D00PKMS.PALLET_HDR_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_BRDS.D00PKMS.PALLET_HDR_SIG to target tablePDB_PKMS.D00PKMS.PALLET_HDR_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_BRDS.D00PKMS.PALLET_HDR_SIG to PDB_PKMS.D00PKMS.PALLET_HDR_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.PALLET_HDR_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.PALLET_HDR_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.PALLET_HDR_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.PALLET_HDR_SIG
ORA-01403: no data found
ORA-01403: no data found

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Oct 16 2024
1 comment
237 views