Few Updates Made To Boolean Columns In MSSQL Database Were Not Captured By OGG (Oracle Goldengate). (Doc ID 2286628.1)

Last updated on JULY 24, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 to 12.2.0.1.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Using GG version 12.1.2.1.3 for MSSQL Database , running on windows 2008 R2,

 a column is updated with value from 1 to 0. and the change is captured by extract. When the same column is updated from 0 to 1 extract fails to capture the change.

This filter is being used. is

FILTER ( @EVAL(@AFTER(Encroached_Account_Fl) OR @AFTER(Encroached_Account_Fl) = 0 , 1,@COLTEST(Encroached_Account_Fl, NULL), 1,0)),

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