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:

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

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