Veridata Periodically Counts Table Rows Incorrectly

(Doc ID 2249078.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

I expect "Rows From Target" in GG veridata UI should be equal to following
SQLs:
.
SQL> select count(*) from POINT_BALANCE where UPDATE_DATE
between to_date('20150708 000000','YYYYMMDD HH24MISS')
and
to_date('20150708 235959','YYYYMMDD HH24MISS')
and
CAP_MEMBER_PARTITION_KEY in ('00','01','02');
.
COUNT(*)
----------
838717

But GG veridata UI shows less than SQL count above.



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