Integrated Replicat Abends With ORA-00001: unique constraint Even With REPERROR Set (Doc ID 2074852.1)

Last updated on APRIL 16, 2017

Applies to:

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

Symptoms

Integrated replicat fails with ORA-00001: unique constraint even with REPERROR set.

REPERROR (1, DISCARD)

2015-05-22 17:57:36 WARNING OGG-02544 Unhandled error (ORA-00001: unique constraint (.) violated
ORA-00001: unique constraint (HR.UI_DEVICE) violated) while processing the record at SEQNO 936, RBA 67975402 in Integrated mode. REP
LICAT will retry in Direct mode.

2015-05-22 17:57:36 ERROR OGG-00665 OCI Error calling OCITransCommit (status = 2091-ORA-02091: transaction rolled back
ORA-00001: unique constraint (HR.UI_DEVICE) violated), SQL<BEGIN dbms_apply_adm.delete_error(:1); END;>.

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