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 laterInformation 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 |