My Oracle Support Banner

OGG For Google BigQuery - Records Are Not Merged Even AuditLogMode Is Set To False (Doc ID 2623255.1)

Last updated on MAY 27, 2020

Applies to:

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

Symptoms

In OGG for Google BigQuery, records are not merged even auditLogMode is set to false, see below details:

Source - Oracle Database
Target - Google BigQuery

Steps to reproduce the behavior:

On the source site (Oracle database):

+ Insert a record in source Oracle Database
+ Delete the record in Oracle Database after a long time (such as the next day).

Even after setting "auditLogMode" to "false" in replication as per the below document, the BigQuery records are still not merged in the first scenario.
https://docs.oracle.com/en/middleware/goldengate/big-data/19.1/gadbd/using-bigquery-handler.html#GUID-3FDB406B-BDFB-4F70-852C-A00C90009BF3

Changes

 None, new replication environment from Oracle to Google BigQuery using OGG.

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
Changes
Cause
Solution
References


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