Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: KETTLE ERROR, Can anyone help me?

  1. #1
    Join Date
    Jul 2007
    Posts
    18

    Default KETTLE ERROR, Can anyone help me?

    I created a simple Transformation, used Spoon. After runing Transformation i saw thie error...
    Its a Mysql Database, JDBC Connection...


    2007/08/06 17:26:06 - Spoon - Main window is created.
    2007/08/06 17:26:06 - Spoon - Asking for repository
    2007/08/06 17:26:06 - Kettle - Reading repositories XML file: C:\Documents and Settings\ssuetcue\.kettle\repositories.xml
    2007/08/06 17:26:32 - Spoon - edit job graph entry: testtrans
    2007/08/06 17:26:56 - Spoon - edit job graph entry: testtrans
    2007/08/06 17:27:12 - Spoon - Transformation opened.
    2007/08/06 17:27:12 - Spoon - Launching transformation [testtrans]...
    2007/08/06 17:27:12 - Spoon - Started the transformation execution.
    2007/08/06 17:27:12 - testtrans - Dispatching started for transformation [testtrans]
    2007/08/06 17:27:12 - testtrans - Nr of arguments detected:10
    2007/08/06 17:27:12 - testtrans - This is not a replay transformation
    2007/08/06 17:27:12 - testtrans - This transformation can be replayed with replay date: 2007/08/06 17:27:12
    2007/08/06 17:27:12 - testtrans - Initialising 2 steps...
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : An error occurred during initialization, processing will be stopped:
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Error occured while trying to connect to the database
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) :
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Communications link failure due to underlying exception:
    ** BEGIN NESTED EXCEPTION **
    java.net.UnknownHostException
    MESSAGE: null: null
    STACKTRACE:
    java.net.UnknownHostException: null: null
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at java.net.InetAddress.getAllByName0(Unknown Source)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at java.net.InetAddress.getAllByName0(Unknown Source)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at java.net.InetAddress.getAllByName(Unknown Source)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:163)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:268)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.Connection.createNewIO(Connection.java:2745)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at java.sql.DriverManager.getConnection(Unknown Source)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at java.sql.DriverManager.getConnection(Unknown Source)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.connectUsingClass(Database.java:387)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.normalConnect(Database.java:273)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.connect(Database.java:238)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.connect(Database.java:200)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.insertupdate.InsertUpdate.init(InsertUpdate.java:262)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.StepInitThread.run(StepInitThread.java:45)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at java.lang.Thread.run(Unknown Source)
    2007/08/06 17:27:19 - Insert / Update.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) :
    ** END NESTED EXCEPTION **

    Last packet sent to the server was 0 ms ago.
    2007/08/06 17:27:19 - Insert / Update - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Error initializing step [Insert / Update]
    2007/08/06 17:27:19 - testtrans - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Step [Insert / Update.0] failed to initialize!
    2007/08/06 17:27:19 - testtrans - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : We failed to initialize at least one step. Execution can not begin!
    2007/08/06 17:27:19 - Spoon - The transformation has finished!!

  2. #2

    Default

    Gemelos,
    It seens that your connection is not properly set. Could you please post your database config?

    Regards,

    Reinaldo

  3. #3
    Join Date
    Jul 2007
    Posts
    18

    Default

    Hi Reinaldo..
    (Sorry for my bad english)

    i tried to compile the job without the Repository. If i use a repository then i have no problems with the transformation... but I need the *.ktr and *.kjb files for using in the Pentaho Plattform.

    Table output Settings:

    Connectionname: Test
    Connection type: Mysql
    Method of access: Native (JDBC)
    Server host nameempty)
    Database name:test
    port number:3306
    Username: root
    password:*****

    Thx Gemelos

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Compile... compile what ... the repository is just storage. So whether you run from the repository or separate files it should not really matter. Depending on your setup you may have to change your connection settings. So:

    1) export to .ktr and .kjb
    2) check all of the connections and test them via the test button.

    Regards,
    Sven

  5. #5
    Join Date
    Jul 2007
    Posts
    18

    Default

    Ok ...

    You are right...
    Do you know.
    Is it possiblile to run Kettle jobs in Pentaho Platform or only Transformations and using Quartz for schedule.

    regards,
    gemelos

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    Jobs should also work. Carte only supports transformations for the moment.

    Regards,
    Sven

  7. #7
    Join Date
    Jul 2007
    Posts
    18

    Default

    Hi sven..

    Thank you for your quick answer.

    Now it works problem-free.

    regards,
    Gemelos

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.