kettle 执行转换的时候报错,但是错误不详,分析不出具体什么原因

D_Fly 发布于 2018/06/14 16:32
阅读 1K+
收藏 0

2018/06/14 16:27:38 - 表输出sg 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Because of an error, this step can't continue:
2018/06/14 16:27:38 - 表输出sg 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2018/06/14 16:27:38 - 表输出sg 2.0 - Error performing rollback on connection
2018/06/14 16:27:38 - 表输出sg 2.0 - 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 - 
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:854)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:832)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:332)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at java.lang.Thread.run(Thread.java:745)
2018/06/14 16:27:38 - 表输出sg 2.0 - Caused by: java.sql.SQLException: 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1160)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:845)
2018/06/14 16:27:38 - 表输出sg 2.0 -     ... 5 more
2018/06/14 16:27:38 - 表输出sg 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error committing the database connection.
2018/06/14 16:27:38 - 表输出sg 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2018/06/14 16:27:38 - 表输出sg 2.0 - Error comitting connection
2018/06/14 16:27:38 - 表输出sg 2.0 - 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 - 
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.commit(Database.java:773)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.commit(Database.java:745)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1356)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:575)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at java.lang.Thread.run(Thread.java:745)
2018/06/14 16:27:38 - 表输出sg 2.0 - Caused by: java.sql.SQLException: 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1130)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.commit(Database.java:764)
2018/06/14 16:27:38 - 表输出sg 2.0 -     ... 5 more
2018/06/14 16:27:38 - 表输出sg 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2018/06/14 16:27:38 - 表输出sg 2.0 - Error comitting connection
2018/06/14 16:27:38 - 表输出sg 2.0 - 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 - 
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.commit(Database.java:773)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.commit(Database.java:745)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1356)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:575)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at java.lang.Thread.run(Thread.java:745)
2018/06/14 16:27:38 - 表输出sg 2.0 - Caused by: java.sql.SQLException: 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1130)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.commit(Database.java:764)
2018/06/14 16:27:38 - 表输出sg 2.0 -     ... 5 more
2018/06/14 16:27:38 - 表输出sg 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error rolling back the database connection.
2018/06/14 16:27:38 - 表输出sg 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2018/06/14 16:27:38 - 表输出sg 2.0 - Error performing rollback on connection
2018/06/14 16:27:38 - 表输出sg 2.0 - 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 - 
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:854)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:832)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:610)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at java.lang.Thread.run(Thread.java:745)
2018/06/14 16:27:38 - 表输出sg 2.0 - Caused by: java.sql.SQLException: 关闭的连接
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1160)
2018/06/14 16:27:38 - 表输出sg 2.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:845)
2018/06/14 16:27:38 - 表输出sg 2.0 -     ... 4 more
2018/06/14 16:27:38 - 表输出sg 2.0 - 完成处理 (I=0, O=990000, R=1020000, W=990000, U=0, E=1)
2018/06/14 16:27:38 - tb_sale_157 - 转换被检测
2018/06/14 16:27:38 - tb_sale_157 - 转换正在杀死其他步骤!
2018/06/14 16:27:38 - 表输入 2 2.0 - Finished reading query, closing connection.
2018/06/14 16:27:39 - 表输入 2 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException: 
2018/06/14 16:27:39 - 表输入 2 2.0 - Couldn't close query: resultset or prepared statements
2018/06/14 16:27:39 - 表输入 2 2.0 - Cancel has been invoked on this Statement.
2018/06/14 16:27:39 - 6.9 - Connection to database closed!
2018/06/14 16:27:39 - 表输入 2 2.0 - 完成处理 (I=1030002, O=0, R=0, W=1030001, U=0, E=1)
2018/06/14 16:27:39 - tb_sale_157 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 错误被检测到!
2018/06/14 16:27:39 - Spoon - 转换完成!!
2018/06/14 16:27:39 - tb_sale_157 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 错误被检测到!
2018/06/14 16:27:39 - tb_sale_157 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 错误被检测到!
2018/06/14 16:27:39 - tb_sale_157 - 转换被检测
2018/06/14 16:27:39 - tb_sale_157 - 转换正在杀死其他步骤!

加载中
返回顶部
顶部