job kettle 执行多次_各位大神，kettle有个job执行经常报错如下，但是数据跑成功了，求解啊...-CSDN博客

本文链接：https://blog.csdn.net/weixin_39589644/article/details/111747067

这篇博客记录了一个使用Kettle作业执行数据迁移时遇到的问题，虽然作业报错显示ORA-08103：对象不再存在，但实际数据迁移已完成。错误出现在表输入步骤，可能是由于数据库对象已删除导致。尽管作业结束时报告错误，但后续步骤如插入/更新等仍能正常完成。

摘要由CSDN通过智能技术生成

2017/06/19 12:07:31 - 开始项[TR_CT_PANELINFO]

2017/06/19 12:07:31 - Loading transformation from repository [TR_CT_PANELINFO] in directory [/Transformation/OracleToOrcale/EDBTOEDB]

2017/06/19 12:07:31 - TR_CT_PANELINFO - 为了转换解除补丁开始 [TR_CT_PANELINFO]

2017/06/19 12:07:43 - 表输入.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected error

2017/06/19 12:07:43 - 表输入.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:

2017/06/19 12:07:43 - 表输入.0 - Couldn't get row from result set

2017/06/19 12:07:43 - 表输入.0 - ORA-08103: 对象不再存在

2017/06/19 12:07:43 - 表输入.0 -

2017/06/19 12:07:43 - 表输入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2397)

2017/06/19 12:07:43 - 表输入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2368)

2017/06/19 12:07:43 - 表输入.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)

2017/06/19 12:07:43 - 表输入.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2017/06/19 12:07:43 - 表输入.0 - at java.lang.Thread.run(Unknown Source)

2017/06/19 12:07:43 - 表输入.0 - Caused by: java.sql.SQLException: ORA-08103: 对象不再存在

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1222)

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:379)

2017/06/19 12:07:43 - 表输入.0 - at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:284)

2017/06/19 12:07:43 - 表输入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2385)

2017/06/19 12:07:43 - 表输入.0 - ... 4 more

2017/06/19 12:07:43 - 表输入.0 - Finished reading query, closing connection.

2017/06/19 12:07:43 - TR_CT_PANELINFO - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : 错误被检测到!

2017/06/19 12:07:43 - 插入 / 更新.0 - 完成处理 (I=95, O=55, R=95, W=94, U=0, E=0

2017/06/19 12:07:43 - 表输入.0 - 完成处理 (I=100, O=0, R=0, W=99, U=0, E=1

2017/06/19 12:07:43 - TR_CT_PANELINFO - 转换被检测

2017/06/19 12:07:43 - TR_CT_PANELINFO - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : 错误被检测到!

2017/06/19 12:07:43 - TR_CT_PANELINFO - 转换正在杀死其他步骤!

2017/06/19 12:07:43 - 开始项[发送邮件]

2017/06/19 12:07:44 - 完成作业项[发送邮件] (结果=[true])

2017/06/19 12:07:44 - 完成作业项[TR_CT_PANELINFO] (结果=[true])

2017/06/19 12:07:44 - 完成作业项[TR_SET_JOBSTARTTIME] (结果=[true])

2017/06/19 12:07:44 - Job_CT_PanelInfo