Kettle 采集数据报错，

Question

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unexpected error

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleStepException:

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error in step, asking everyone to stop because of:

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Couldn't get row from result set

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to get value 'String(9999999)' from database resultset, index 10

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Io 异常: Software caused connection abort: recv failed

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:307)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at java.lang.Thread.run(Thread.java:619)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Couldn't get row from result set

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to get value 'String(9999999)' from database resultset, index 10

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Io 异常: Software caused connection abort: recv failed

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.Database.getRow(Database.java:2796)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.Database.getRow(Database.java:2768)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.Database.getRow(Database.java:2742)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.Database.getLookup(Database.java:3105)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.Database.getLookup(Database.java:3093)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:80)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:290)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     ... 2 more

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to get value 'String(9999999)' from database resultset, index 10

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Io 异常: Software caused connection abort: recv failed

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1871)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2604)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.Database.getRow(Database.java:2788)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     ... 8 more

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: java.sql.SQLException: Io 异常: Software caused connection abort: recv failed

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.jdbc.driver.T4CConnection.getChunkSize(T4CConnection.java:2721)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.sql.CLOB.getChunkSize(CLOB.java:516)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.sql.CLOB.getBufferSize(CLOB.java:534)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.sql.CLOB.getCharacterStream(CLOB.java:278)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.jdbc.driver.ClobAccessor.getString(ClobAccessor.java:229)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.jdbc.driver.T4CClobAccessor.getString(T4CClobAccessor.java:70)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:397)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1841)

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :     ... 10 more

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to commit connection(s) :org.pentaho.di.core.exception.KettleDatabaseException:

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error performing rollback on connection

2012/07/14 18:44:01 - 插入 / 更新.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 关闭的连接

2012/07/14 18:44:01 - 插入 / 更新.0 - 完成处理 (I=10247, O=1964, R=10248, W=10247, U=0, E=1

2012/07/14 18:44:01 - 表输入.0 - Finished reading query, closing connection.

2012/07/14 18:44:01 - 获取系统信息.0 - 完成处理 (I=0, O=0, R=20249, W=20249, U=0, E=0

2012/07/14 18:44:01 - 表输入.0 - 完成处理 (I=30251, O=0, R=0, W=30250, U=0, E=0

2012/07/14 18:44:01 - Spoon - 转换完成!!

2012/07/14 18:44:01 -  - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 错误被检测到!

2012/07/14 18:44:01 -  - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 错误被检测到!

Answer 1

楼主的问题已近解决了吗？求答案

Answer 2

数据库连接上了吗？

Answer 3

……

采集数据的时候，运行一段时间就中断了，报这个错误。

找不到原因

Answer 4

你想表达什么呢？

（表示真的不知道。。不会通过一段log了解到你想问什么或者传达一个什么观点。。求指导。。）