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 OCTOBER 09, 2017

Applies to:

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

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 PJACOB.TEST. Add the column to GETBEFORECOLS.

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

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