GG Extract Report Shows "Purging Transaction", WARNING OGG-00723, OGG-00715, Updating I/O Checkpoint after Purging Orphaned Transactions, Has Secondary Transaction ID That Is Duplicate of Existing Open Uncommitted Transaction (Doc ID 1458472.1)

Last updated on AUGUST 15, 2017

Applies to:

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

Symptoms

Extract report shows following messages:

2012-03-05 09:14:54  WARNING OGG-00723  Oracle GoldenGate Capture for Oracle, ext_bi.prm:  Record with class# 34, slt# 4, at seqno 77324,
rba 32995856 SCN 27.2929925862 (118894042854) has secondary transaction ID that is duplicate of existing open uncommitted transaction.

2012-03-05 09:14:54  WARNING OGG-00715  Oracle GoldenGate Capture for Oracle, ext_bi.prm:  [Thread #1] Purging transaction
(transaction id: 9.4.26367119, start time: 2012-03-05 09:11:35, start seqno: 77323, start RBA: 154945040).

2012-03-05 09:14:54  WARNING OGG-00712  Oracle GoldenGate Capture for Oracle, ext_bi.prm:  Updating I/O checkpoint after purging
orphaned transactions on thread 1 with current position (Seq#: 77324, RBA: 32998564). s

 

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