My Oracle Support Banner

OGGBD - BigQuery replicat abend - Alter table functionality is disabled in the BigQuery Handler (Doc ID 2756275.1)

Last updated on MAY 12, 2022

Applies to:

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

Symptoms

Oracle GoldenGata Big data replicat fails when adding new columns in Source

=ERROR 2021-02-25 17:13:50.000919 [main] - The expected schema does not match the schema in BigQuery for table <Table name>.
=ERROR 2021-02-25 17:13:50.000920 [main] - Current schema definition in BigQuery [Schema{fields=[Field{name=optype, type=STRING, mode=REQUIRED,
--
--
=ERROR 2021-02-25 17:13:50.000921 [main] - Alter table functionality is disabled in the BigQuery Handler.
Exception in thread "main" oracle.goldengate.util.GGException: Error detected handling metadata changed event.
at oracle.goldengate.datasource.UserExitDataSource.newTableMetaData(UserExitDataSource.java:2259)
at oracle.goldengate.datasource.UserExitDataSource.newTableMetaData(UserExitDataSource.java:2097)



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
References


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