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
查看状态,恢复正常