求解大神!Kettle上一分钟跑一次的job,偶尔会出现下面这个报错,然后job就异常停止了。重新启动又是正常运行的,是什么原因呀?

0
2017/06/19 00:42:14 - 开始项[TR_SET_JOBSTARTTIME]
2017/06/19 00:42:14 - Loading transformation from repository [TR_SET_JOBSTARTTIME] in directory [/Transformation/OracleToOrcale/Public]
2017/06/19 00:42:15 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException:
2017/06/19 00:42:15 - Unexpected error during transformation metadata load
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1208)
2017/06/19 00:42:15 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:648)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.execute(Job.java:716)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.execute(Job.java:859)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.execute(Job.java:532)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.run(Job.java:424)
2017/06/19 00:42:15 - Caused by: org.pentaho.di.core.exception.KettleException:
2017/06/19 00:42:15 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278)
2017/06/19 00:42:15 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1172)
2017/06/19 00:42:15 -  ... 5 more
2017/06/19 00:42:15 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -  at org.pentaho.di.core.RowMetaAndData.getBoolean(RowMetaAndData.java:223)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getTransAttributeBoolean(KettleDatabaseRepositoryConnectionDelegate.java:774)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransAttribute.getAttributeBoolean(KettleDatabaseRepositoryTransAttribute.java:41)
2017/06/19 00:42:15 -  at org.pentaho.di.core.logging.BaseLogTable.loadFromRepository(BaseLogTable.java:160)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:630)
2017/06/19 00:42:15 -  ... 7 more
2017/06/19 00:42:15 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : A serious error occurred during job execution:
2017/06/19 00:42:15 - 当启动项目[TR_SET_JOBSTARTTIME.0]时发生无法预料的错误
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unexpected error during transformation metadata load
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException:
2017/06/19 00:42:15 - 当启动项目[TR_SET_JOBSTARTTIME.0]时发生无法预料的错误
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unexpected error during transformation metadata load
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.execute(Job.java:862)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.execute(Job.java:532)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.run(Job.java:424)
2017/06/19 00:42:15 - Caused by: org.pentaho.di.core.exception.KettleException:
2017/06/19 00:42:15 - Unexpected error during transformation metadata load
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1208)
2017/06/19 00:42:15 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:648)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.execute(Job.java:716)
2017/06/19 00:42:15 -  at org.pentaho.di.job.Job.execute(Job.java:859)
2017/06/19 00:42:15 -  ... 2 more
2017/06/19 00:42:15 - Caused by: org.pentaho.di.core.exception.KettleException:
2017/06/19 00:42:15 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/19 00:42:15 -
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278)
2017/06/19 00:42:15 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1172)
2017/06/19 00:42:15 -  ... 5 more
2017/06/19 00:42:15 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2017/06/19 00:42:15 - Unknown column 'VALUE_STR'
2017/06/19 00:42:15 -
2017/06/19 00:42:15 -  at org.pentaho.di.core.RowMetaAndData.getBoolean(RowMetaAndData.java:223)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getTransAttributeBoolean(KettleDatabaseRepositoryConnectionDelegate.java:774)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransAttribute.getAttributeBoolean(KettleDatabaseRepositoryTransAttribute.java:41)
2017/06/19 00:42:15 -  at org.pentaho.di.core.logging.BaseLogTable.loadFromRepository(BaseLogTable.java:160)
2017/06/19 00:42:15 -  at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:630)
2017/06/19 00:42:15 -  ... 7 more
 
还有一个也出现这样的问题,报错有点不一样
 
2017/06/17 00:38:41 - 开始项[TR_PRODUCT]
2017/06/17 00:38:41 - Loading transformation from repository [TR_PRODUCT] in directory [/Transformation/OracleToOrcale/MESTOEDBANDYMS]
2017/06/17 00:38:41 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException:
2017/06/17 00:38:41 - Unexpected error during transformation metadata load
2017/06/17 00:38:41 -
2017/06/17 00:38:41 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/17 00:38:41 -
2017/06/17 00:38:41 - Unable to get list of rows from ResultSet :
2017/06/17 00:38:41 -
2017/06/17 00:38:41 - Couldn't get row from result set
2017/06/17 00:38:41 -
2017/06/17 00:38:41 - Unable to get value 'Integer(38)' from database resultset, index 1
2017/06/17 00:38:41 - 无法转换为内部表示
2017/06/17 00:38:41 -
2017/06/17 00:38:41 -
2017/06/17 00:38:41 -
2017/06/17 00:38:41 -
2017/06/17 00:38:41 -
2017/06/17 00:38:41 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1208)
2017/06/17 00:38:41 -  at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:648)
2017/06/17 00:38:41 -  at org.pentaho.di.job.Job.execute(Job.java:716)
2017/06/17 00:38:41 -  at org.pentaho.di.job.Job.execute(Job.java:859)
2017/06/17 00:38:41 -  at org.pentaho.di.job.Job.execute(Job.java:859)
2017/06/17 00:38:41 -  at org.pentaho.di.job.Job.execute(Job.java:532)
2017/06/17 00:38:41 -  at org.pentaho.di.job.Job.run(Job.java:424)
2017/06/17 00:38:41 - Caused by: org.pentaho.di.core.exception.KettleException:
2017/06/17 00:38:41 - 一个数据库错误发生在从资源库文件读取转换时
2017/06/17 00:38:41 -
2017/06/17 00:38:41 - Unable to get list of rows from ResultSet :
2017/06/17 00:38:41 -
2017/06/17 00:38:41 - Couldn't get row from result set
2017/06/17 00:38:41 -
2017/06/17 00:38:41 - Unable to get value 'Integer(38)' from database resultset, index 1
2017/06/17 00:38:41 - 无法转换为内部表示
已邀请:
0

王小色1991 - 90后it男 2018-09-07 回答

遇到同样的问题 请问你的问题解决了吗?
0

伯乐快乐 2018-09-08 回答

某大型IT公司现在招大量的BI人员(有研发,有管理岗)薪资范围(10--33K/月)
需要技能:有数据仓库项目经验、熟识数据仓库体系架构、必须熟识ETL流程;
熟识Datastage、PLSQL开发技术;
有数据建模经验或报表开发经验者优先;
思路清晰、沟通表达能力强、工作态度积极;
待遇优厚,五险一金,双休,带薪年假,每年例行体检。
工作地:南京
有意者私聊,张女士15951725143(微信同号)

要回复问题请先登录注册