千泷先生 2022-02-25 23:59 采纳率: 0%
浏览 421

linux kettle project 执行转换报错,如何解决?

问题遇到的现象和发生背景

我下载了一个开源的kettle master project,打到war包发布到windows下可以正在的执行转换和工作,
发布到linux下执行失败,请帮忙看一下,报错如下:

运行结果及报错内容

2022/02/19 21:30:00 - test001 - Dispatching started for transformation [test001]
2022/02/19 21:30:00 - resource table.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : An error occurred, processing will be stopped:
2022/02/19 21:30:00 - resource table.0 - Error occurred while trying to connect to the database
2022/02/19 21:30:00 - resource table.0 -
2022/02/19 21:30:00 - resource table.0 - Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2022/02/19 21:30:00 - resource table.0 - Communications link failure
2022/02/19 21:30:00 - resource table.0 -
2022/02/19 21:30:00 - resource table.0 - The last packet successfully received from the server was 1 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
2022/02/19 21:30:00 - test001 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
2022/02/19 21:30:00 - test001 - Unable to get database metadata from this database connection
2022/02/19 21:30:00 - test001 - at java.lang.Thread.run (Thread.java:750)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:69)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:356)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2897)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.Trans.stopAll (Trans.java:1875)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:299)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.core.database.Database.cancelQuery (Database.java:727)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2911)
2022/02/19 21:30:00 - test001 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2022/02/19 21:30:00 - test001 - Unable to get database metadata from this database connection
2022/02/19 21:30:00 - test001 - at java.lang.Thread.run (Thread.java:750)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:69)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:356)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2897)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.Trans.stopAll (Trans.java:1875)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:299)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.core.database.Database.cancelQuery (Database.java:727)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2911)
2022/02/19 21:30:00 - test001 -
2022/02/19 21:30:00 - test001 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2913)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:727)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:299)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1875)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2897)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.steps.tableinput.TableInput.init(TableInput.java:356)
2022/02/19 21:30:00 - test001 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
2022/02/19 21:30:00 - test001 - at java.lang.Thread.run(Thread.java:750)
2022/02/19 21:30:00 - test001 - Caused by: java.lang.NullPointerException
2022/02/19 21:30:00 - test001 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2911)
2022/02/19 21:30:00 - test001 - ... 7 more
2022/02/19 21:30:00 - resource table.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Error initializing step [resource table]
2022/02/19 21:30:00 - Insert / Update.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : An error occurred during initialization, processing will be stopped:
2022/02/19 21:30:00 - Insert / Update.0 - Error occurred while trying to connect to the database
2022/02/19 21:30:00 - Insert / Update.0 -
2022/02/19 21:30:00 - Insert / Update.0 - Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2022/02/19 21:30:00 - Insert / Update.0 - Communications link failure
2022/02/19 21:30:00 - Insert / Update.0 -
2022/02/19 21:30:00 - Insert / Update.0 - The last packet successfully received from the server was 0 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
2022/02/19 21:30:00 - Insert / Update.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Error initializing step [Insert / Update]
2022/02/19 21:30:00 - test001 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Step [resource table.0] failed to initialize!
2022/02/19 21:30:00 - test001 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Step [Insert / Update.0] failed to initialize!
2022/02/19 21:30:00 - resource table.0 - Finished reading query, closing connection.
2022/02/19 21:30:00 - test001 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Errors detected!

我的解答思路和尝试过的方法
我想要达到的结果
  • 写回答

1条回答 默认 最新

  • IT民工金鱼哥 运维领域新星创作者 2022-02-26 11:44
    关注

    看报错提示 Unable to get database metadata from this database connection
    查查数据上的设置是否正确,包括日志下半部分,也提示你,数据库尝试连接时出现问题
    Error occurred while trying to connect to the database


    检查一下配置文件是否正确,数据库是否已配置正确。

    评论

报告相同问题?

问题事件

  • 创建了问题 2月25日

悬赏问题

  • ¥15 使用yolov5-7.0目标检测报错
  • ¥15 对于这个问题的解释说明
  • ¥200 询问:python实现大地主题正反算的程序设计,有偿
  • ¥15 smptlib使用465端口发送邮件失败
  • ¥200 总是报错,能帮助用python实现程序实现高斯正反算吗?有偿
  • ¥15 对于squad数据集的基于bert模型的微调
  • ¥15 为什么我运行这个网络会出现以下报错?CRNN神经网络
  • ¥20 steam下载游戏占用内存
  • ¥15 CST保存项目时失败
  • ¥20 java在应用程序里获取不到扬声器设备