OGG Extract Fails with "failed to retrieve all chained row fragments" or "failed to retrieve overflow segment data" (Doc ID 1364407.1)

Last updated on AUGUST 12, 2014

Applies to:

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

Symptoms

OGG Extract errors with failed to retrieve overflow segment or chained row fragments like below

2011-03-15 16:18:21 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, ext1.prm: failed
to retrieve all chained row fragments for table HR.TEST, record #19401, in transaction 34.165.3
(0x0022.0a5.00000003). Position (24502, 39484028).


or

2011-05-12 08:28:03 ERROR OGG-01028 failed to retrieve overflow segment data on table HR.EMP

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