My Oracle Support Banner

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

Last updated on MAY 11, 2022

Applies to:

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


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.


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

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