My Oracle Support Banner

OGG Replicat - REPERROR(2291, TRANSDISCARD) is not working when encountered Ora-02291 (Doc ID 2825299.1)

Last updated on JANUARY 24, 2022

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information 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;>.

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


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