Replicat Abends Due To New Column Added to the target. (Doc ID 2127639.1)

Last updated on APRIL 15, 2016

Applies to:

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

Symptoms



Add a column (COMP_ID) on the target table which does not exist on the source and as a result, the replicat abends with the following:

ERROR   OGG-01920  Missing COMPARECOLS column COMP_ID in before image, while mapping to target table PREMIER.CAT_ITEM. Add the column to GETBEFORECOLS

  

Using the following COLMAP statements to the Replicat parameter file:

MAP PREMIER.P_CAT_ITEM, TARGET PREMIER.P_CAT_ITEM, COLMAP(USEDEFAULTS, COMP_ID=@COLSTAT(NULL)), #FromTrusted();

 

 

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