OGG-00919 Error in COLMAP clause.

2018-02-12 10:04:35  ERROR   OGG-00919  Error in COLMAP clause.

报此错。

使用版本OGG 12.3.0.1

查官方 文档：

报错：ERROR OGG-00919 Error in COLMAP clause.

问题解析：

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 to 12.1.2.1.2 [Release 12.1]

Information in this document applies to any platform.

Symptoms

Using @GETENV("GGHEADER", "OPTYPE") function with COLMAP

will now result in the following error when using GG Version 12.1.2.1.x

INFO OGG-01298 Column function diagnostic message: could not find column "GGHEADER".

...STREQ(@GETENV("GGHEADER", "OPT...

^

Error in COLMAP clause. Invalid function or argument.

ERROR OGG-00919 Error in COLMAP clause.

Cause

Syntax has changed for @GETENV function and options in version 12. These now use single quotes instead of double quotes.

ERROR OGG-00919 Error in COLMAP clause.

Solution

For version 11 Use double quotes for the GETENV options

@GETENV("GGHEADER", "OPTYPE")

For version 12 Use single quotes for the GETENV options

@GETENV('GGHEADER', 'OPTYPE')

Please refer to the Version 12 documentation for further clarifications.

想到此进程包含 两个自己添加rowid同步的表

map vindamis.tls_location_detail,target stg_vindamis.tls_location_detail colmap (usedefaults, row_id = @token ("TKN-ROWID")) keycols (row_id);

需要修改为【双引号改为单引号】

map vindamis.tls_location_detail,target stg_vindamis.tls_location_detail colmap (usedefaults, row_id = @token ('TKN-ROWID')) keycols (row_id);