My Oracle Support Banner

Replicat Abend- ERROR OGG-01920 Missing COMPARECOLS column xx in before image, while mapping to target table xxx. Add the column to GETBEFORECOLS (Doc ID 2153017.1)

Last updated on JULY 18, 2023

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Generic (Platform Independent)

Symptoms

Ogg Integrated replicat(IR) abend with

ERROR OGG-01920 Missing COMPARECOLS column SYS_STS6YT18CGHZP$M3995$QCG656 in before image, while mapping to target table <schema>.<table>. Add the column to GETBEFORECOLS.

The specified column seems to be a virtual column/ system generated column

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.