2013-01-29 14:23:17 ERROR OGG-01028 Formatting error on: table name 000.TBCONTRACTBALANCE, rowid AAAMb2AB+AABp6KAAj, XID 33.22.36594, position (Seqno 878, RBA 1170383260). Invalid numeric data detected. Error converting numeric from Oracle to ASCII on column RENTMOENY, raw length 1, raw data: 105C41A0: 00 |.|.
2013-02-22 10:55:54 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, exta.prm: Formatting error on: table name 000.TBCONTRACTBALANCE, rowid AAAMb2AB+AABp6vAA4, XID 6.26.49261, position (Seqno 1348, RBA 382752208). Invalid numeric data detected. Error converting numeric from Oracle to ASCII on column RENTMOENY, raw length 1, raw data: 105C41A0: 00 |.|.
2013-02-22 10:55:54 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, exta.prm: PROCESS ABENDING.
检查了表结构和数据记录都没有发现问题。
解决办法:
1.跳过这条需要同步的记录
2.修改检查点
3.排除该表后再进行初始化,从新同步这张表,
以上方法在后面可能还会发生同样的问题。
4.TRANLOGOPTIONS _INFINITYTOZERO