Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Executing job on remote server - MySQL Driver issue

  1. #1
    Join Date
    Feb 2013
    Posts
    13

    Default Executing job on remote server - MySQL Driver issue

    Hello,

    I am having some trouble running transformations on a remote server that utilize MySQL DB connections. I can run the transformation from my Windows environment without issue. I can run the same tranformation using Pan on my remote server without issue. But, I cannot run the transformation from my Windows environment on the Slave server without getting the error below. I see this line - "Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed." - I have installed mysql-connector-java-5.1.17.jar in /data-integration/lib as well as /tomcat/lib. I am not sure where else this may need to go to allow MySQL queries to run when kicked off remotely. Any help would be greatly appreciated, thank you!

    Version is 5.0.1


    org.pentaho.di.core.exception.KettleException:
    There was an error preparing the transformation for excution on the remote server:
    Initialisation of transformation failed:
    2014/04/25 12:41:31 - RepositoriesMeta - Reading repositories XML file: /home/pentaho/.kettle/repositories.xml
    2014/04/25 12:41:31 - Generate Rows Test - Dispatching started for transformation [Generate Rows Test]
    2014/04/25 12:41:31 - Table input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : An error occurred, processing will be stopped:
    2014/04/25 12:41:31 - Table input.0 - Error occured while trying to connect to the database
    2014/04/25 12:41:31 - Table input.0 -
    2014/04/25 12:41:31 - Table input.0 - Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
    2014/04/25 12:41:31 - Table input.0 - org.gjt.mm.mysql.Driver
    2014/04/25 12:41:31 - Generate Rows Test - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
    2014/04/25 12:41:31 - Generate Rows Test - Unable to get database metadata from this database connection
    2014/04/25 12:41:31 - Generate Rows Test - at java.lang.Thread.run (null:-1)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:65)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:363)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2605)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.Trans.stopAll (Trans.java:1729)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:303)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.core.database.Database.cancelQuery (Database.java:640)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2653)
    2014/04/25 12:41:31 - Generate Rows Test - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2014/04/25 12:41:31 - Generate Rows Test - Unable to get database metadata from this database connection
    2014/04/25 12:41:31 - Generate Rows Test - at java.lang.Thread.run (null:-1)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:65)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:363)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2605)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.Trans.stopAll (Trans.java:1729)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:303)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.core.database.Database.cancelQuery (Database.java:640)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2653)
    2014/04/25 12:41:31 - Generate Rows Test -
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2655)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:640)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1729)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2605)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.steps.tableinput.TableInput.init(TableInput.java:363)
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:65)
    2014/04/25 12:41:31 - Generate Rows Test - at java.lang.Thread.run(Unknown Source)
    2014/04/25 12:41:31 - Generate Rows Test - Caused by: java.lang.NullPointerException
    2014/04/25 12:41:31 - Generate Rows Test - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2653)
    2014/04/25 12:41:31 - Generate Rows Test - ... 7 more
    2014/04/25 12:41:31 - Table input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Error initializing step [Table input]
    2014/04/25 12:41:31 - Generate Rows Test - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Step [Table input.0] failed to initialize!
    2014/04/25 12:41:31 - Table input.0 - Finished reading query, closing connection.
    Last edited by perekl; 04-25-2014 at 01:51 PM.

  2. #2
    Join Date
    Feb 2013
    Posts
    13

    Default

    I killed the java processes on the remote server and restarted - seems to have fixed my issue. Restarting after adding the drivers is important...

  3. #3
    Join Date
    Nov 2008
    Posts
    777

    Default

    Yes that makes sense. I believe the jars are added to the Java classpath at JVM startup so will you have to restart when another jar is added in order for it to be "found".
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.