My Oracle Support Banner

IR Fails To Handle FK Constraint Exception Records When Auto CDR Is Enabled On The Table (Doc ID 2946761.1)

Last updated on SEPTEMBER 04, 2023

Applies to:

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

Symptoms

When Auto CDR is enabled and when there is Foreign Key violation, the exception table does not gets populated and also the replicat abends.

WARNING OGG-02544 Unhandled error (ORA-02291: integrity

constraint (<schema>.<constraint name>) violated - parent key not found) while

processing the record at SEQNO 0, RBA 0 in Integrated mode. REPLICAT will

retry in Direct mode.

WARNING OGG-00869 OCI Error ORA-02091: transaction rolled back

ORA-02291: integrity constraint (<schema>.<constraint name>) violated - parent key not found (status = 2091-calling OCITransCommit).

ERROR OGG-00664 OCI Error ORA-02091: transaction rolled back

But it handles fine for other exceptions. Such as ORA-1403.

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.