Replicat Abends with Error OGG-00918 Key Column <Column Name> is Missing from Map (Doc ID 1958451.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

On : 11.2.1.0.26 version, 1 - Oracle DB backend

When attempting to start the replicat, the following error occurs.

ERROR
-----------------------

WARNING OGG-00869  No unique key is defined for table 'employee'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using the following default columns with matching names:    ID = ID, NAME = NAME, SAL = SAL
The following target columns were not mapped: =
GG_COMMIT_TIME

ERROR OGG-00918 Key column GG_COMMIT_TIME  is missing from map

MAP statement used

 

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