Integrated Replicat Abends with Error ORA-02091: Transaction Rolled Back, ORA-26786, ORA-01403, ORA-00001 - violated SQL BEGIN dbms_apply_adm.delete_error(:1); END (Doc ID 2273865.1)

Last updated on JULY 05, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.
Replicat failed with the following error:
ORA-26786: A row with key ("PYMNT_VNDR_RULES_UUID") = (e18f718348b849e495dee0e4084d0691) exists but has conflicting column(s) "GG_LAST_DML" in table PAYMENT_MANAGER.PAYMENT_VENDOR_RULES_
ORA-01403: no data found) while processing the record at SEQNO 41, RBA 31551454 in Integrated mode. REPLICAT will retry in Direct mode.

2017-05-26 13:54:37 ERROR OGG-00870 Database error 2091 (ORA-02091: transaction rolled back
ORA-00001: unique constraint (PAYMENT_MANAGER.UK_PAYMENT_VENDOR_RULES) violated SQL BEGIN dbms_apply_adm.delete_error(:1); END;)

Symptoms

Integrated Replicat failed with combination of ORA-26786, ORA-01403 , ORA-02091, ORA-00001 - violated SQL BEGIN dbms_apply_adm.delete_error(:1); END;

From the report file the warning is:

2017-05-26 13:54:36 WARNING OGG-02544 Unhandled error (ORA-00001: unique constraint (PAYMENT_MANAGER.UK_PAYMENT_VENDOR_RULES) violated
ORA-26786: A row with key ("PYMNT_VNDR_RULES_UUID") = (e18f718348b849e495dee0e4084d0691) exists but has conflicting column(s) "GG_LAST_DML" in table PAYMENT_MANAGER.PAYMENT_VENDOR_RULES_
ORA-01403: no data found

ORA-26786: A row with key ("PYMNT_VNDR_RULES_UUID") = (e18f718348b849e495dee0e4084d0691) exists but has conflicting column(s) "GG_LAST_DML" in table PAYMENT_MANAGER.PAYMENT_VENDOR_RULES_
ORA-01403: no data found) while processing the record at SEQNO 41, RBA 31551454 in Integrated mode. REPLICAT will retry in Direct mode.

and the error is:

2017-05-31 17:40:43 ERROR OGG-00665 OCI Error calling OCITransCommit (status = 2091-ORA-02091: transaction rolled back
ORA-00001: unique constraint (PAYMENT_MANAGER.UK_PAYMENT_VENDOR_RULES) violated), 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