kettle报错无效的 ROWID,很可能是因为同时执行的转换都操作一个表引起的。
其实下面也有其他信息:'转换被检测'、'转换正在杀死其他步骤!'。
2020/03/26 15:44:10 - ETL_W_XXX_ALL - 开始执行任务
2020/03/26 15:44:10 - ETL_W_XXX_ALL - 开始项[ETL_W_XXX_ALL]
2020/03/26 15:44:10 - ETL_W_XXX_ALL - Loading transformation from repository [ETL_W_XXX_ALL] in directory [/2.DW]
2020/03/26 15:44:11 - ETL_W_XXX_ALL - 为了转换解除补丁开始 [ETL_W_XXX_ALL]
2020/03/26 15:44:11 - 表输出.0 - Connected to database [DS_DW] (commit=1000)
2020/03/26 15:44:50 - 表输出.0 - linenr 50000
2020/03/26 15:45:20 - 表输入 2.0 - linenr 50000
2020/03/26 15:45:22 - 表输入.0 - linenr 50000
2020/03/26 15:45:25 - 表输出.0 - linenr 100000
2020/03/26 15:46:01 - 表输出.0 - linenr 150000
2020/03/26 15:46:20 - 表输入 2.0 - linenr 100000
2020/03/26 15:46:29 - 表输入.0 - linenr 100000
2020/03/26 15:46:30 - 表输出.0 - linenr 200000
2020/03/26 15:47:02 - 表输出.0 - linenr 250000
2020/03/26 15:47:18 - 表输入 2.0 - linenr 150000
2020/03/26 15:47:28 - 表输入.0 - linenr 150000
2020/03/26 15:47:28 - 表输出.0 - linenr 300000
2020/03/26 15:48:05 - 表输出.0 - linenr 350000
2020/03/26 15:48:25 - 表输入 2.0 - linenr 200000
2020/03/26 15:48:38 - 表输出.0 - linenr 400000
2020/03/26 15:48:46 - 表输入.0 - linenr 200000
2020/03/26 15:48:58 - 表输入 2.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected error
2020/03/26 15:48:58 - 表输入 2.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2020/03/26 15:48:58 - 表输入 2.0 - Couldn't get row from result set'
2020/03/26 15:48:58 - 表输入 2.0 - ORA-01410: 无效的 ROWID
2020/03/26 15:48:58 - 表输入 2.0 -
2020/03/26 15:48:58 - 表输入 2.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2357)
2020/03/26 15:48:58 - 表输入 2.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2328)
2020/03/26 15:48:58 - 表输入 2.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)
2020/03/26 15:48:58 - 表输入 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/03/26 15:48:58 - 表输入 2.0 - at java.lang.Thread.run(Unknown Source)
2020/03/26 15:48:58 - 表输入 2.0 - Caused by: java.sql.SQLException: ORA-01410: 无效的 ROWID
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1074)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:369)
2020/03/26 15:48:58 - 表输入 2.0 - at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:273)
2020/03/26 15:48:58 - 表输入 2.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2345)
2020/03/26 15:48:58 - 表输入 2.0 - ... 4 more
2020/03/26 15:48:58 - 表输入 2.0 - Finished reading query, closing connection.
2020/03/26 15:48:58 - ETL_W_XXX_ALL - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : 错误被检测到!
2020/03/26 15:48:58 - 表输入 2.0 - 完成处理 (I=225890, O=0, R=0, W=225889, U=0, E=1
2020/03/26 15:48:58 - ETL_W_XXX_ALL - 转换被检测
2020/03/26 15:48:58 - ETL_W_XXX_ALL - 转换正在杀死其他步骤!
2020/03/26 15:48:58 - 表输入.0 - Finished reading query, closing connection.
2020/03/26 15:48:58 - DS_STG - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Error disconnecting from database:
2020/03/26 15:48:58 - DS_STG -
2020/03/26 15:48:58 - DS_STG - Error comitting connection
2020/03/26 15:48:58 - DS_STG - ORA-01013: 用户请求取消当前的操作
2020/03/26 15:48:58 - DS_STG - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2020/03/26 15:48:58 - DS_STG - Error comitting connection
2020/03/26 15:48:58 - DS_STG - ORA-01013: 用户请求取消当前的操作
2020/03/26 15:48:58 - DS_STG -
2020/03/26 15:48:58 - DS_STG - at org.pentaho.di.core.database.Database.commit(Database.java:755)
2020/03/26 15:48:58 - DS_STG - at org.pentaho.di.core.database.Database.commit(Database.java:727)
2020/03/26 15:48:58 - DS_STG - at org.pentaho.di.core.database.Database.disconnect(Database.java:609)
2020/03/26 15:48:58 - DS_STG - at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:271)
2020/03/26 15:48:58 - DS_STG - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
2020/03/26 15:48:58 - DS_STG - at java.lang.Thread.run(Unknown Source)
2020/03/26 15:48:58 - DS_STG - Caused by: java.sql.SQLException: ORA-01013: 用户请求取消当前的操作
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4C7Ocommoncall.processError(T4C7Ocommoncall.java:93)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:558)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3674)
2020/03/26 15:48:58 - DS_STG - at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
2020/03/26 15:48:58 - DS_STG - at org.pentaho.di.core.database.Database.commit(Database.java:746)
2020/03/26 15:48:58 - DS_STG - ... 5 more
2020/03/26 15:48:58 - 表输入.0 - 完成处理 (I=209391, O=0, R=0, W=209389, U=0, E=0
2020/03/26 15:48:58 - 表输出.0 - 完成处理 (I=0, O=433249, R=433249, W=433000, U=0, E=0
2020/03/26 15:48:58 - ETL_W_XXX_ALL - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : 错误被检测到!
2020/03/26 15:48:58 - ETL_W_XXX_ALL - 完成作业项[ETL_W_XXX_ALL] (结果=[false])
2020/03/26 15:48:58 - ETL_W_XXX_ALL - 任务执行完毕
网友评论