BATCHSQL Suspended, Aborting Transaction Warnings (Doc ID 1519339.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Goal

Replicat with BATCHSQL indicates that BATCHSQL suspended and Aborting BATCHSQL transaction, example:

2013-01-06 11:12:29 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rhd73.prm: Aborting BATCHSQL transaction. Database error 1 (ORA-00001: unique constraint (MYSCHEMA.TABLEA) violated).
2013-01-06 11:12:29 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, rhd73.prm: BATCHSQL suspended, continuing in normal mode.
2013-01-06 11:12:29 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rhd73.prm: Repositioning to rba 29284 in seqno 0.
2013-01-06 11:12:29 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rrp71.prm: Aborting BATCHSQL transaction. Database error 1 (ORA-00001: unique constraint (MYSCHEMA.TABLEB) violated).
2013-01-06 11:12:29 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, rrp71.prm: BATCHSQL suspended, continuing in normal mode.
2013-01-06 11:12:29 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rrp71.prm: Repositioning to rba 121688 in seqno 0.
2013-01-06 11:12:29 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rrp73.prm: Aborting BATCHSQL transaction. Database error 1 (ORA-00001: unique constraint (MYSCHEMA.TABLEB) violated).
2013-01-06 11:12:29 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, rrp73.prm: BATCHSQL suspended, continuing in normal mode.
2013-01-06 11:12:29 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rrp73.prm: Repositioning to rba 120891 in seqno 0.
2013-01-06 11:12:29 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rrp62.prm: Aborting BATCHSQL transaction. Database error 1 (ORA-00001: unique constraint (MYSCHEMA.TABLEC) violated).
2013-01-06 11:12:29 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, rrp62.prm: BATCHSQL suspended, continuing in normal mode.
2013-01-06 11:12:29 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rrp62.prm: Repositioning to rba 59341 in seqno 0.
2013-01-06 11:12:30 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rhd72.prm: Aborting BATCHSQL transaction. Database error 1 (ORA-00001: unique constraint (MYSCHEMA.TABLEA) violated).
2013-01-06 11:12:30 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, rhd72.prm: BATCHSQL suspended, continuing in normal mode.
2013-01-06 11:12:30 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rhd72.prm: Repositioning to rba 23898 in seqno 0.
 

Solution

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