My Oracle Support Banner

BATCHSQL Suspended, Aborting Transaction Warnings (Doc ID 1519339.1)

Last updated on APRIL 05, 2023

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

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.