OGG-01298 、OGG-00375、OGG-01668 could not find column "TRANSACTION". Error in FILTER clause

1、查看OGG状态

OGG TARGET库出现：ABENDED

2、查看ogg日志

tail -200f /ogg/ggserr.log

INFO OGG-01298 Oracle GoldenGate Delivery for Oracle, r_sh.prm: Column function diagnostic message: could not find column "TRANSACTION".

ERROR OGG-00375 Oracle GoldenGate Delivery for Oracle, r_sh.prm: Error in FILTER clause.
ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r_sh.prm: PROCESS ABENDING.

3、问题原因

区别：版本11的ogg需要使用双引号"TRANSACTION","CSN"，如果使用的是版本12的ogg要使用单引号.

4、查看当前配置

view param R_SH

修改前：MAP UCCBIZ.T_HW_AGENT_SIGN_RECORD, TARGET UCCBIZ.T_HW_AGENT_SIGN_RECORD,FILTER(@GETENV("TRANSACTION","CSN")>14670006404868);

 

5、编辑配置文件 edit param R_SH

修改后：

MAP UCCBIZ.T_HW_AGENT_SIGN_RECORD, TARGET UCCBIZ.T_HW_AGENT_SIGN_RECORD,FILTER(@GETENV('TRANSACTION','CSN')>14670006404868);

6、启动复制进程R_SH

GGSCI (B) 1> start R_SH

查看状态，恢复正常