使用kettle同时调度多个job的时候会出现很多报错。求各位指点。：报错
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) :
写回答
-
把job合并到一个执行试试######
引用来自“fredking”的答案
把job合并到一个执行试试还是不行。我现在在一个job中循环调用全部job，但是一次只能执行一个job，我想知道我能不能在job中并行循环执行job呢？######job的开始里有个选项是是否重复执行，估计你是没选中
######
引用来自“maofujun”的答案
job的开始里有个选项是是否重复执行，估计你是没选中
不是这个呢。我的意思是设置并行很多job，然后肯定会报错。######把游标上限设置大点就好了2020-06-07 17:13:04赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
