Replicat Abends with "ERROR OGG-01920 Missing COMPARECOLS column ... in before image, while mapping to target table .... Add the column to GETBEFORECOLS" (Doc ID 1965284.1)

Last updated on MARCH 20, 2017

Applies to:

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

Symptoms

 OGG Trail has only inserts & deletes and Replicat abends with following error 

2014-06-16 09:16:52 ERROR OGG-01920 Missing COMPARECOLS column INTERACTION_ID in before image, while mapping to target table
"GGS"."INTERACTIONS". Add the column to GETBEFORECOLS.

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