OGG Big Data Replicat Abends With The UPDATE Operation Record In The Trail At Pos[0/XXXXXXX] For Table [<Schema.TableName>] Has Missing Columns (Doc ID 2826560.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

OGG Big Data replicat is abended with below errors:

=ERROR 2021-11-18 22:33:47.000507 [main] - The UPDATE operation record in the trail at pos[0/XXXXXXX] for table [SCHEMA.TABLENAME] has missing columns.
Configure extract to generate trail records with all the column values.
Alternatively you can disable this check by setting gg.abend.on.missing.columns=false.
Exception in thread "main" java.lang.IllegalStateException: The UPDATE operation record in the trail at pos[0/XXXXXXX] for table [SCHEMA.TABLENAME] has missing columns.
Configure extract to generate trail records with all the column values.
Alternatively you can disable this check by setting gg.abend.on.missing.columns=false.
...........................
.................................
2021-11-18 22:33:47  ERROR   OGG-15051  Java or JNI exception:
java.lang.IllegalStateException: The UPDATE operation record in the trail at pos[0/XXXXXXX] for table [SCHEMA.TABLENAME] has missing columns.
Configure extract to generate trail records with all the column values.
Alternatively you can disable this check by setting gg.abend.on.missing.columns=false.

Cause

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