请教OGG的replicat的abending

Wizard

问题描述：
ogg的replicat的abend，在report中查看，在abend之前，有一长串的warning：
Parameter #: 1 Data Type: 130 DB Part: 7 Length: 24 Max Length: 30 Status: 8 Pre
cision: 15 Scale: 0 Unavailable
Parameter #: 2 Data Type: 129 DB Part: 5 Length: 23 Max Length: 29 Status: 8 Pre
cision: 23 Scale: 3 Unavailable
Parameter #: 3 Data Type: 130 DB Part: 7 Length: 0 Max Length: 24 Status: 8 Prec
ision: 12 Scale: 0 Unavailable
Parameter #: 4 Data Type: 130 DB Part: 7 Length: 0 Max Length: 30 Status: 8 Prec
ision: 15 Scale: 0 Unavailable
Parameter #: 5 Data Type: 130 DB Part: 7 Length: 18 Max Length: 24 Status: 8 Pre
cision: 12 Scale: 0 Unavailable
Parameter #: 6 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Preci
sion: 1 Scale: 0 Unavailable
Parameter #: 7 Data Type: 130 DB Part: 7 Length: 0 Max Length: 510 Status: 8 Pre
cision: 255 Scale: 0 Unavailable
Parameter #: 8 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Preci
sion: 1 Scale: 0 Unavailable
Parameter #: 9 Data Type: 130 DB Part: 7 Length: 0 Max Length: 300 Status: 8 Pre
cision: 150 Scale: 0 Unavailable
Parameter #: 10 Data Type: 130 DB Part: 7 Length: 12 Max Length: 30 Status: 8 Pr
ecision: 15 Scale: 0 Unavailable
Parameter #: 11 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Preci
sion: 15 Scale: 0 Unavailable
Parameter #: 12 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Preci
sion: 15 Scale: 0 Unavailable
Parameter #: 13 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Preci
sion: 15 Scale: 0 Unavailable
Parameter #: 14 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Preci
sion: 15 Scale: 0 Unavailable
Parameter #: 15 Data Type: 130 DB Part: 7 Length: 0 Max Length: 40 Status: 8 Pre
cision: 20 Scale: 0 Unavailable
Parameter #: 16 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Preci
sion: 15 Scale: 0 Unavailable
Parameter #: 17 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Preci
sion: 15 Scale: 0 Unavailable
但是我比较过source db和target db的两个表的结构，完全一样，该replication的特殊性是：resource table 没有主键，也没有unique column唯一标识记录

Maclean Liu(刘相兵

action plan:

1. upload complete ggserr.log (target server). 上传 完整的target 上的ggserr.log 日志

2. info <replicat-name>, showch                  -- 贴出该命令的输出

3. info <replicat-name>, detail                  --贴出该命令的输出

4.  如果有的话 上传 discard log

bailangfeng

通过这个命令 把其中的报错贴出
view report replicat

Wizard

error log
2012-05-03 17:16:52  INFO    OGG-00995  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  REPLICAT RMSS07H starting.
2012-05-03 17:16:53  INFO    OGG-00996  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  REPLICAT RMSS07H started.
2012-05-03 17:23:08  WARNING OGG-00869  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:   Parameter #: 1 Data Type: 130 DB Part: 7 Length: 18 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 2 Data Type: 129 DB Part: 5 Length: 23 Max Length: 29 Status: 8 Precision: 23 Scale: 3 Unavailable  Parameter #: 3 Data Type: 130 DB Part: 7 Length: 0 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 4 Data Type: 130 DB Part: 7 Length: 0 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 5 Data Type: 130 DB Part: 7 Length: 18 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 6 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 7 Data Type: 130 DB Part: 7 Length: 28 Max Length: 510 Status: 8 Precision: 255 Scale: 0 Unavailable  Parameter #: 8 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 9 Data Type: 130 DB Part: 7 Length: 0 Max Length: 300 Status: 8 Precision: 150 Scale: 0 Unavailable  Parameter #: 10 Data Type: 130 DB Part: 7 Length: 12 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 11 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 12 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 13 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 14 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 15 Data Type: 130 DB Part: 7 Length: 0 Max Length: 40 Status: 8 Precision: 20 Scale: 0 Unavailable  Parameter #: 16 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 17 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 18 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 19 Data Type: 5 DB.
2012-05-03 17:23:08  WARNING OGG-01004  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  Aborted grouped transaction on 'DBO.INVOICEHEAD', Database error -2147217887 ([SQL error -2147217887 (0x80040e21)] Parameter #: 1 Data Type: 130 DB Part: 7 Length: 18 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 2 Data Type: 129 DB Part: 5 Length: 23 Max Length: 29 Status: 8 Precision: 23 Scale: 3 Unavailable  Parameter #: 3 Data Type: 130 DB Part: 7 Length: 0 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 4 Data Type: 130 DB Part: 7 Length: 0 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 5 Data Type: 130 DB Part: 7 Length: 18 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 6 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 7 Data Type: 130 DB Part: 7 Length: 28 Max Length: 510 Status: 8 Precision: 255 Scale: 0 Unavailable  Parameter #: 8 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 9 Data Type: 130 DB Part: 7 Length: 0 Max Length: 300 Status: 8 Precision: 150 Scale: 0 Unavailable  Parameter #: 10 Data Type: 130 DB Part: 7 Length: 12 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 11 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 12 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 13 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 14 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 15 Data Type: 130 DB Part: 7 Length: 0 Max Length: 40 Status: 8 Precision: 20 Scale: 0 Unavailable  Parameter #: 16 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 17 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 18 Data Type: 5.
2012-05-03 17:23:08  WARNING OGG-01003  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  Repositioning to rba 3869049 in seqno 4.
2012-05-03 17:23:08  WARNING OGG-00869  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:   Parameter #: 1 Data Type: 130 DB Part: 7 Length: 18 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 2 Data Type: 129 DB Part: 5 Length: 23 Max Length: 29 Status: 8 Precision: 23 Scale: 3 Unavailable  Parameter #: 3 Data Type: 130 DB Part: 7 Length: 0 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 4 Data Type: 130 DB Part: 7 Length: 0 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 5 Data Type: 130 DB Part: 7 Length: 18 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 6 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 7 Data Type: 130 DB Part: 7 Length: 28 Max Length: 510 Status: 8 Precision: 255 Scale: 0 Unavailable  Parameter #: 8 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 9 Data Type: 130 DB Part: 7 Length: 0 Max Length: 300 Status: 8 Precision: 150 Scale: 0 Unavailable  Parameter #: 10 Data Type: 130 DB Part: 7 Length: 12 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 11 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 12 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 13 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 14 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 15 Data Type: 130 DB Part: 7 Length: 0 Max Length: 40 Status: 8 Precision: 20 Scale: 0 Unavailable  Parameter #: 16 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 17 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 18 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 19 Data Type: 5 DB.
2012-05-03 17:23:08  WARNING OGG-01154  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  SQL error -2147217887 mapping DBO.INVOICEHEAD to DBO.INVOICEHEAD [SQL error -2147217887 (0x80040e21)] Parameter #: 1 Data Type: 130 DB Part: 7 Length: 18 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 2 Data Type: 129 DB Part: 5 Length: 23 Max Length: 29 Status: 8 Precision: 23 Scale: 3 Unavailable  Parameter #: 3 Data Type: 130 DB Part: 7 Length: 0 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 4 Data Type: 130 DB Part: 7 Length: 0 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 5 Data Type: 130 DB Part: 7 Length: 18 Max Length: 24 Status: 8 Precision: 12 Scale: 0 Unavailable  Parameter #: 6 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 7 Data Type: 130 DB Part: 7 Length: 28 Max Length: 510 Status: 8 Precision: 255 Scale: 0 Unavailable  Parameter #: 8 Data Type: 129 DB Part: 5 Length: 1 Max Length: 2 Status: 8 Precision: 1 Scale: 0 Unavailable  Parameter #: 9 Data Type: 130 DB Part: 7 Length: 0 Max Length: 300 Status: 8 Precision: 150 Scale: 0 Unavailable  Parameter #: 10 Data Type: 130 DB Part: 7 Length: 12 Max Length: 30 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 11 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 12 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 13 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 14 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 15 Data Type: 130 DB Part: 7 Length: 0 Max Length: 40 Status: 8 Precision: 20 Scale: 0 Unavailable  Parameter #: 16 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 17 Data Type: 5 DB Part: 7 Length: 8 Max Length: 50 Status: 8 Precision: 15 Scale: 0 Unavailable  Parameter #: 18 Data Type: 5 DB Part: 7 L.
2012-05-03 17:23:08  WARNING OGG-01003  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  Repositioning to rba 3869049 in seqno 4.
2012-05-03 17:23:08  ERROR   OGG-01296  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  Error mapping from DBO.INVOICEHEAD to DBO.INVOICEHEAD.
2012-05-03 17:23:08  ERROR   OGG-01668  Oracle GoldenGate Delivery for ODBC, RMSS07H.prm:  PROCESS ABENDING.

info rmss07h, detail:


show rmss07h, showch:


discard file:
RMSS07h.DSC.txt (4.13 KB, 下载次数: 669)

2012-5-3 15:38 上传

点击文件名下载附件

Maclean Liu(刘相兵

SQL error -2147217887 (0x80040e21)

这是 oracle 到 SQL SERVER的 数据同步复制？

我对 SQL Server的了解不多 ，目前也找不到 任何相关的信息， 建议你提交SR 。

Wizard

对，是SQL Server到SQL Server的replication，因为是legacy application，所以用OGG可以克服表无主键的特殊情况。我分析trail文件，发现trail文件有误，如：column 3 被写成了column 1342，所以我觉得问题还是在OGG一侧

guanghai

对源的表生成 DEF定义文件，再把DEF定义文件复制到目标端后，在目标端使用（如sourcedefs ./dirdef/source_001.def ）即可解决长度不一致的问题。

Wizard

不是长度不一致，当使用skip跳过当前的transaction，后续的插入、更新，仍然可以正常进行，我感觉是是pump对trail的文件写到remote的时候，写的不对