诡异的OGG-01004 Database error 1403 no data found

配置某个客户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 <UPDATE /*+ RESTRICT_ALL_REF_CONS */ ""."*" SET "PROCESS_STATUS" = :a1,"ERROR_MSG" = :a2,"TRANSACTION_HEADER_ID" = :a3 WHERE "BATCH_CODE" = :b0>).
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 <UPDATE /*+ RESTRICT_ALL_REF_CONS */ * " SET "PROCESS_STATUS" = :a1,"ERROR_MSG" = :a2,"TRANSACTION_HEADER_ID" = :a3 WHERE "BATCH_CODE" = :b0>.
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> info trandata h2.t_ap_inv_header_iface
Logging of supplemental redo log data is enabled for table H2.T_AP_INV_HEADER_IFACE.
Columns supplementally logged for table H2.T_AP_INV_HEADER_IFACE: TRANSACTION_HEADER_ID.

目标端：
GGSCI (yserpvdrd01) 14> info trandata h2.t_ap_inv_header_iface
Logging of supplemental redo log data is enabled for table H2.T_AP_INV_HEADER_IFACE.
Columns supplementally logged for table H2.T_AP_INV_HEADER_IFACE: BATCH_CODE.

恍然大悟

问了问开发人员，主键有调整。

修复：在源端执行
delete trandata h2. t_ap_inv_header_iface
add trandata h2.t_ap_inv_header_iface

重启进程之后数据复制OK

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8520577/viewspace-2128702/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8520577/viewspace-2128702/