Replicat Process abends with ORA-02291: integrity constraint

(Doc ID 2170825.1)

Last updated on FEBRUARY 07, 2018

Applies to:

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


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.


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