Replicat Process abends with ORA-02291: integrity constraint

(Doc ID 2170825.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

Replicat abend with ORA-02291 despite using DBOPTIONS _NO_DISABLE_ON_RETRY_ERROR

2016-05-17 18:09:49 ERROR OGG-00665 OCI Error calling OCITransCommit (status = 2091-ORA-02091: transaction rolled back
ORA-02291: integrity constraint (SESTGT.CONTACT_FK) violated - parent key not found), SQL.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms