配置某个客户OGG环境时,同事报告某个表数据没有同步过去
错误是:
2016-11-18 14:53:46 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep_zt.prm: Aborted grouped transaction on '*', Database error 1403 (OCI Error ORA-01403: no data found, SQL ).
2016-11-18 14:53:46 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep_zt.prm: Repositioning to rba 86746 in seqno 51.
2016-11-18 14:53:46 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep_zt.prm: SQL error 1403 mapping * to * OCI Error ORA-01403: no data found, SQL .
2016-11-18 14:53:46 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rep_zt.prm: Error mapping from * to *.
2016-11-18 14:53:46 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_zt.prm: PROCESS ABENDING.
检查配置文件没有发现异常。
检查数据,源端与目标端数据都一致。
尝试在源端看了一下这个表的trandata, 目标端的主键是COL1
GGSCI (ysbpmvsrd02) 31> i