OGG Replicat - REPERROR(2291, TRANSDISCARD) is not working when encountered Ora-02291
(Doc ID 2825299.1)
Last updated on JULY 18, 2023
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
The target tables are out of sync with the source and so the replicat failed with error like
ERROR OGG-00665 OCI Error calling OCITransCommit
(status = 2091-ORA-02091: transaction rolled back
ORA-02291: integrity constraint (<schema>.<table_FK1)
violated - parent key not found), SQL<BEGIN dbms_apply_adm.delete_error(:1,
FALSE); END;>.
(status = 2091-ORA-02091: transaction rolled back
ORA-02291: integrity constraint (<schema>.<table_FK1)
violated - parent key not found), SQL<BEGIN dbms_apply_adm.delete_error(:1,
FALSE); END;>.
Need to skip the specified transaction causing the Ora-02291 and want to get the replicat applying the rest of the records
Tried using the below and the replicat still fails with the same error and will not discard the record and move on
REPERROR(2291, TRANSDISCARD)
The case is same when encountering ORA-02292 as well
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 |
| Cause |
| Solution |
| References |