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);

展开阅读全文

没有更多推荐了,返回首页