My Oracle Support Banner

Veridata Periodically Counts Table Rows Incorrectly (Doc ID 2249078.1)

Last updated on FEBRUARY 10, 2020

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

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
Symptoms
Cause
Solution


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