Kettle 采集数据报错,

karsong 发布于 2012/07/14 19:06
阅读 5K+
收藏 0
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) : 错误被检测到!

加载中
0
叶国伟
叶国伟
你想表达什么呢?
(表示真的不知道。。不会通过一段log了解到你想问什么或者传达一个什么观点。。求指导。。)
0
karsong
karsong

……

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

找不到原因

0
a
aihukoo

数据库连接上了吗?

0
前田光
前田光
楼主的问题已近解决了吗?求答案
返回顶部
顶部