使用kettle同时调度多个job的时候会出现很多报错。求各位指点。
0
悬赏园豆：100
[已关闭问题]
关闭于 2014-06-27 15:47
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 一个数据库错误发生在从资源库文件读取转换时
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unable to get list of rows from ResultSet :
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Couldn't get row from result set
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unable to get value 'Integer(38)' from database resultset, index 1
2013/04/08 15:10:03 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 无法转换为内部表示
2013/04/08 15:10:03 - Spoon - 任务已经结束.
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 当读共享文件时发生错误(继续加载): org.pentaho.di.core.exception.KettleException:
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 无法从资源库读取数据库:
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error loading database connection from repository (id_database=19)
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unable to get list of rows from ResultSet :
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Couldn't get row from result set
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unable to get value 'String(9999999)' from database resultset, index 4
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 无效的列索引
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleException:
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 无法从资源库读取数据库:
2013/04/08 15:10:05 - 32_JAVADB_DW_META - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
所有回答(3)
0
我也遇到了这个问题，求解啊
2018/12/16 19:45:03 - readdate.0 - Unable to get value 'Integer(38)' from database resultset, index 38
2018/12/16 19:45:03 - readdate.0 - Numeric Overflow
请问怎么解决啊，愁死我了。
0
你好！！！你这个问题是怎么解决的 求方法 谢谢了！！！
2018/12/16 19:45:03 - readdate.0 - Unable to get value 'Integer(38)' from database resultset, index 38
2018/12/16 19:45:03 - readdate.0 - Numeric Overflow
大哥，请问这个问题怎么解决啊，愁死我了。
0
2019/08/21 11:45:52 - 数据接入 - Unable to get value 'Integer(38)' from database resultset, index 2
定时job，单次执行不报错，每分钟执行一次，过几个小时后就报这个错误，什么原因，有大佬知道kettle怎么优化