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

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 Mac系统vs code使用phpstudy如何配置debug来调试php
  • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
  • ¥60 pb数据库修改与连接
  • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)