GoldenGate Informix Extract Not Capturing Some Inserts Which Were Committed (Doc ID 2173775.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.10 to 12.1.2.1.0 [Release 12.1]
IBM AIX on POWER Systems (64-bit)

Symptoms

We have discovered that some(but not all) inserts which are committed on Informix
are NOT being captured by GoldenGate.
This was noticed when numerous (captured) updates were failing on the Target apply
with "key not found".
Indeed for these rows, we have verified they were successfully inserted into Informix,
but they do not appear in the GG extract trailfile.
Interestingly, some of these "missing" rows are part of a parent child relationship
on the Source DB, and the child is being successfully captured and replicated!
NO errors appear in the ggserr.log, nor the extract reportfile, nor the mgr reportfile.

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