使用kettle同时调度多个job的时候会出现很多报错。求各位指点。

前田光 发布于 2013/04/08 15:33
阅读 6K+
收藏 0
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) : 

加载中
0
f
fredking
把job合并到一个执行试试
0
前田光
前田光

引用来自“fredking”的答案

把job合并到一个执行试试
还是不行。我现在在一个job中循环调用全部job,但是一次只能执行一个job,我想知道我能不能在job中并行循环执行job呢?
0
m
maofujun

job的开始里有个选项是是否重复执行,估计你是没选中

0
前田光
前田光

引用来自“maofujun”的答案

job的开始里有个选项是是否重复执行,估计你是没选中

不是这个呢。我的意思是设置并行很多job,然后肯定会报错。
0
肥而不腻
把游标上限设置大点就好了
返回顶部
顶部