Coordinated Replicat Reports Run Time Statistics with Negative values (Doc ID 2246444.1)

Last updated on MARCH 28, 2017

Applies to:

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

Symptoms

Oracle GoldenGate Delivery for SQL Server
Version 12.2.0.1.0 OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2
Windows x64 (optimized), Microsoft SQL Server on Nov 10 2015 23:11:31

Coordinated Replicat may report negative statistics when STATOPTIONS RESETREPORTSTATS is used with "report at".

The Report file would show negative statistics like below

***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************

Reading .\dirdat\ab000002, current RBA 7197676, 16026 records, m_file_seqno = 0, m_file_rba = 0

Report at 2016-02-09 23:59:00 (activity since 2016-02-08 23:59:00)

From Table DBO.DIAG to DBO.DIAG:
# inserts: -4
# updates: -7
# deletes: 0
# discards: 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