My Oracle Support Banner

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

Last updated on AUGUST 07, 2023

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 (<OWNER>.<NAME>) 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

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.