Trandata Temporarily Disabled For Some Tables (Doc ID 2273996.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

On : 12.2.0.1.0 version, 2 - Non Oracle DB backend

ACTUAL BEHAVIOR
---------------
trandata temporarily disabled for some tables

After setting up a new replication with GG 12, data was replicated for all tables as expected.
One month later we noticed a different row count between the source and the target table without entries in the discard file.
In the ggserr.log we found for this tables several of these entries:

2016-11-02 21:51:24 INFO OGG-00178 Oracle GoldenGate Capture for SQL Server, CPCRBF1.prm: VAM Client Report .
2016-11-02 21:51:25 INFO OGG-00178 Oracle GoldenGate Capture for SQL Server, CPCRBF1.prm: VAM Client Report .
2016-11-02 22:14:44 INFO OGG-00178 Oracle GoldenGate Capture for SQL Server, CPCRBF1.prm: VAM Client Report .
2016-11-02 22:46:15 INFO OGG-00178 Oracle GoldenGate Capture for SQL Server, CPCRBF1.prm: VAM Client Report .

Executing INFO TRANDATA confirms that trandata is enabled for these tables and in the ggserr.log there is no 'DELETE TRANDATA' entry.
So we need to clarify what's happening here.

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