My Oracle Support Banner

After applying patch 18891094, replicat got ERROR OGG-00919 Error in COLMAP clause, with GETENV (Doc ID 1939229.1)

Last updated on JULY 17, 2017

Applies to:

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


After applying a fix for Bug 177984670, replicat abneds with:

MAPEXCEPTION resolved (entry "TPE2TX"."FTRANS"): 

2014-09-12 10:29:14  WARNING OGG-06439  No unique key is defined for table EXCEPTIONS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
...CDR_CONFLICTS'), cnt_cdr_resol... 
Error in COLMAP clause. Invalid function or argument. 

Source Context : 
  SourceModule            : [er.mapping] 
  SourceID                : [/scratch/mmar/view_storage/mmar_19196859_sparc/oggcore/OpenSys/src/app/er/mapping.cpp] 
  SourceFunction          : [get_map_entry] 
  SourceLine              : [2326] 

2014-09-12 10:29:14  ERROR   OGG-00919  Error in COLMAP clause. 


after removing "@GETENV('GGHEADER','TABLENAME')", replicat runs fine.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.