?yuezc 2020-04-02 09:25 采纳率: 0%
浏览 1460

kettle在抽取数据时,总出现一个描述不清的问题,我也很难搞懂。

这个是问题:请教一下大神看看。很需要帮忙。

图片说明

2020/04/02 02:05:23 - 字段选择.0 - 行号 2170000
2020/04/02 02:06:02 - 数据源.0 - linenr 2180000
2020/04/02 02:10:40 - 表输出.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:
2020/04/02 02:10:40 - 表输出.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: 
2020/04/02 02:10:40 - 表输出.0 - Error performing rollback on connection
2020/04/02 02:10:40 - 表输出.0 - Communications link failure during rollback(). Transaction resolution unknown.
2020/04/02 02:10:40 - 表输出.0 - 
2020/04/02 02:10:40 - 表输出.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:854)
2020/04/02 02:10:40 - 表输出.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:832)
2020/04/02 02:10:40 - 表输出.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:332)
2020/04/02 02:10:40 - 表输出.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
2020/04/02 02:10:40 - 表输出.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/04/02 02:10:40 - 表输出.0 -     at java.lang.Thread.run(Thread.java:745)
2020/04/02 02:10:40 - 表输出.0 - Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
2020/04/02 02:10:40 - 表输出.0 -     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2020/04/02 02:10:40 - 表输出.0 -     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2020/04/02 02:10:40 - 表输出.0 -     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2020/04/02 02:10:40 - 表输出.0 -     at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
2020/04/02 02:10:40 - 表输出.0 -     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
2020/04/02 02:10:40 - 表输出.0 -     at com.mysql.jdbc.Util.getInstance(Util.java:408)
2020/04/02 02:10:40 - 表输出.0 -     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
2020/04/02 02:10:40 - 表输出.0 -     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
2020/04/02 02:10:40 - 表输出.0 -     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
2020/04/02 02:10:40 - 表输出.0 -     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
2020/04/02 02:10:40 - 表输出.0 -     at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4584)
2020/04/02 02:10:40 - 表输出.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:845)
2020/04/02 02:10:40 - 表输出.0 -     ... 5 more
2020/04/02 02:10:40 - t_sdrs_xscj - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 
2020/04/02 02:10:40 - t_sdrs_xscj - Unable to get database metadata from this database connection
2020/04/02 02:10:40 - t_sdrs_xscj -  at java.lang.Thread.run (Thread.java:745)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow (TableOutput.java:132)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2863)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.Trans.stopAll (Trans.java:1861)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.steps.sql.ExecSQL.stopRunning (ExecSQL.java:268)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.core.database.Database.cancelQuery (Database.java:678)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2745)
2020/04/02 02:10:40 - t_sdrs_xscj - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2020/04/02 02:10:40 - t_sdrs_xscj - Unable to get database metadata from this database connection
2020/04/02 02:10:40 - t_sdrs_xscj -  at java.lang.Thread.run (Thread.java:745)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow (TableOutput.java:132)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2863)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.Trans.stopAll (Trans.java:1861)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.trans.steps.sql.ExecSQL.stopRunning (ExecSQL.java:268)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.core.database.Database.cancelQuery (Database.java:678)
2020/04/02 02:10:40 - t_sdrs_xscj -  at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2745)
2020/04/02 02:10:40 - t_sdrs_xscj - 
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2747)
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.core.database.Database.cancelQuery(Database.java:678)
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.trans.steps.sql.ExecSQL.stopRunning(ExecSQL.java:268)
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.trans.Trans.stopAll(Trans.java:1861)
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2863)
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:132)
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/04/02 02:10:40 - t_sdrs_xscj -     at java.lang.Thread.run(Thread.java:745)
2020/04/02 02:10:40 - t_sdrs_xscj - Caused by: java.lang.NullPointerException
2020/04/02 02:10:40 - t_sdrs_xscj -     at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2745)
2020/04/02 02:10:40 - t_sdrs_xscj -     ... 7 more
  • 写回答

1条回答 默认 最新

  • 数据小控 2022-09-26 17:46
    关注

    请问解决了吗?

    评论

报告相同问题?

悬赏问题

  • ¥15 树莓派与pix飞控通信
  • ¥15 自动转发微信群信息到另外一个微信群
  • ¥15 outlook无法配置成功
  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题