Few Updates Made To Boolean Columns In MSSQL Database Were Not Captured By OGG (Oracle Goldengate).
Last updated on JULY 24, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.1 to 22.214.171.124.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.
Using GG version 126.96.36.199.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)),
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