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