Oracle GoldenGate Veridata 比较表报错

swgsw

节点一（源）

操作系统版本：hpux 11.31
节点数：4
数据库类型：Rac
DB版本： 10.2.0.5


节点二（目标）

操作系统版本：OEL 6.5 64bit
数据库类型：单实例
DB版本： 11.2.0.4



Oracle GoldenGate Veridata 部署在< 节点二> 上面

版本：11.2.1.0  OGGVDT_11.2.1.0.0_PLATFORMS_121108.1625


比较源和目标的同一张表 报错

两个表均有主键


2015-03-27 03:00:38 Agent message (999): Expected inflated size to be 72 but got 71

Comparison terminated with errors.

望大家指点迷津！

swgsw

一些疑问

1、安装 Java Agent on a UNIX or Linux System

agent.properties文件内容中

database.url=  这个串填写的是 源端数据库连接串还是 veridata 库的连接串？

swgsw

跟踪了一下

源端的 veridata-agent.log 在运行  job 的比对时候 有一条关于 Could not set the Session Time Zone to 'GMT+08:00' 的警告。
这个有关系吗？

INFO:2015-03-27 23:53:59,088 (Session: 17) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:53:59,089 (Session: 17) - user 'veridata' connected to 'Oracle Database 10g Enterprise Edition Release 10.2.
0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:00,436 (Session: 17) - Starting source initial compare for BUSINESS.J_GRZHB [RowHashQuery:call, line 68]
INFO:2015-03-27 23:54:03,306 () - Starting session 18 [VeridataAgent$Handler:run, line 313]
WARN:2015-03-27 23:54:03,379 (Session: 18) - Could not set the Session Time Zone to 'GMT+08:00' [OracleDatabase:connect, line 1
745]
INFO:2015-03-27 23:54:03,380 (Session: 18) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:54:03,380 (Session: 18) - user 'veridata' connected to 'Oracle Database 10g Enterprise Edition Release 10.2.
0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:03,675 (Session: 18) - Session 18 stopped [VeridataAgent$Handler:run, line 371]
INFO:2015-03-27 23:54:03,910 (Session: 17) - Session 17 stopped [VeridataAgent$Handler:run, line 371]

目标端 veridata-agent.log 在运行  job 后内容如下：

INFO:2015-03-27 23:54:00,207 () - Starting session 29 [VeridataAgent$Handler:run, line 313]
INFO:2015-03-27 23:54:00,208 (Session: 29) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:54:00,209 (Session: 29) - user 'veridata' connected to 'Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:00,467 (Session: 29) - Starting target initial compare for BXBIZ.J_GRZHB [RowHashQuery:call, line 68]
INFO:2015-03-27 23:54:03,426 () - Starting session 30 [VeridataAgent$Handler:run, line 313]
INFO:2015-03-27 23:54:03,460 (Session: 30) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:54:03,461 (Session: 30) - user 'veridata' connected to 'Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:03,696 (Session: 30) - Session 30 stopped [VeridataAgent$Handler:run, line 371]
INFO:2015-03-27 23:54:03,959 (Session: 29) - Session 29 stopped [VeridataAgent$Handler:run, line 371]
INFO:2015-03-27 23:54:04,107 (Session: 29) - Processed 222912 rows and waited on full queue: 0 [RowHashQuery:call, line 232]