OGG-00918 Oracle GoldenGate Delivery for Oracle, XXX.prm: Key column COLUMN_NAME is missing from map

On Goldengate 11.1,  Replicat PROCESS ABENDING and gives following error on ggserr.log when you try to start it: 

OGG-00918  Oracle GoldenGate Delivery for Oracle, XXX.prm:  Key column COLUMN_NAME is missing from map

When you look at the ggsci with info all:

GGSCI (prod1.com) 2> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     XPPP        00:00:02      00:00:09    
REPLICAT    ABENDED     RTTT        00:00:00      00:57:46    
REPLICAT    RUNNING     RSSS        00:00:00      00:00:02    


This error occured because Replicat abends when trying to replicate a table with NLS (e.g. Turkish) characters like "Ş" in a column name.

GoldenGate 11.1 does not support non-ASCII characters in the column name. 

You have to either upgrade to OGG version 11.2.1 or change the column name  to a valid name with NLS characters. 

You can find details on Doc ID 1325109.1

However, changing the column_name on extract does not help to start abending replicat. Because non-ASCII column_name is still exist on target. You can put a line on parameter file to skip this problematic table as follows.


MAPEXCLUDE SHEMA_NAME.PROBLEM_TABLE; 


Other solution may probably changing the column name to a ASCII character on target side.
I did not tried that solution yet, but it should help.