My Oracle Support Banner

The Contents Of DBA_APPLY_ERROR Are Not Reported Into The Report File when Integrated Replicat Abends (Doc ID 2971948.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate - Version 19.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When Integrated Replicat abends, DBA_APPLY_ERROR messages are not reported into the replicat report file:

  SQL> 2 SOURCE_DATABASE,
  LOCAL_TRANSACTION_ID,
  ERROR_NUMBER,
  ERROR_MESSAGE,
  MESSAGE_COUNT
  FROM DBA_APPLY_ERROR; 3 4 5 6 7

Apply Local Messages in
Process Source Transaction Error
Name Database ID Error Number Error Message Transaction
---------- ---------- ----------- ------------ -------------------- -----------
OGG$<REP_NAME> NULL 1X.X.XXXXXXX 26787 ORA-26787: The row with key ("TEST") =(XXXXXX) does not exist in table <SCHEMA>.<TABLE>
  ORA-01403: no data found

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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