org.pentaho.di.core.exception.KettleDatabaseException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • "Getting started Transformation.ktr" fails on mavericks, while using shipped 1.7.0_60 java version. This is a mac-specific issue. Transformation works as expected while using java version 1.6 or 1.7.0_25. notice: If I run "Run all sample transformations" job - all samples pass. And if I run "Getting started Transformation.ktr" after the job - it will pass. After spoon restart the transformation is failing again. path: 1. Launch spoon, using 1.7.0_60 java version. 2. Open Sample "Getting started Transformation.ktr" and run it. Stacktrace: 2014/09/24 12:40:19 - Spoon - Launching transformation [Getting Started Transformation]... 2014/09/24 12:40:19 - Spoon - Started the transformation execution. 2014/09/24 12:40:20 - Getting Started Transformation - Dispatching started for transformation [Getting Started Transformation] 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : An error occurred intialising this step: 2014/09/24 12:40:20 - Write to Database.0 - Error occured while trying to connect to the database 2014/09/24 12:40:20 - Write to Database.0 - 2014/09/24 12:40:20 - Write to Database.0 - javax.naming.NoInitialContextException: Cannot instantiate class: org.osjava.sj.SimpleContextFactory [Root exception is java.lang.ClassNotFoundException: org.osjava.sj.SimpleContextFactory] 2014/09/24 12:40:20 - Write to Database.0 - Cannot instantiate class: org.osjava.sj.SimpleContextFactory 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Error initializing step [Write to Database] 2014/09/24 12:40:20 - Getting Started Transformation - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Step [Write to Database.0] failed to initialize! 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Unexpected error rolling back the database connection. 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2014/09/24 12:40:20 - Write to Database.0 - Unable to get database metadata from this database connection 2014/09/24 12:40:20 - Write to Database.0 - at java.lang.Thread.run (Thread.java:745) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.ui.spoon.trans.TransGraph$27.run (TransGraph.java:3989) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:1120) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:606) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:826) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:834) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2774) 2014/09/24 12:40:20 - Write to Database.0 - 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2777) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:834) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:826) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:606) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1120) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.ui.spoon.trans.TransGraph$27.run(TransGraph.java:3989) 2014/09/24 12:40:20 - Write to Database.0 - at java.lang.Thread.run(Thread.java:745) 2014/09/24 12:40:20 - Write to Database.0 - Caused by: java.lang.NullPointerException 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2774) 2014/09/24 12:40:20 - Write to Database.0 - ... 6 more 2014/09/24 12:40:20 - Spoon - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Getting Started Transformation: preparing transformation execution failed 2014/09/24 12:40:20 - Spoon - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/09/24 12:40:20 - Spoon - We failed to initialize at least one step. Execution can not begin! 2014/09/24 12:40:20 - Spoon - 2014/09/24 12:40:20 - Spoon - 2014/09/24 12:40:20 - Spoon - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1149) 2014/09/24 12:40:20 - Spoon - at org.pentaho.di.ui.spoon.trans.TransGraph$27.run(TransGraph.java:3989) 2014/09/24 12:40:20 - Spoon - at java.lang.Thread.run(Thread.java:745) 2014/09/24 12:40:20 - Getting Started Transformation - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Errors detected! 2014/09/24 12:40:20 - Getting Started Transformation - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Errors detected!
    via by Ihar Chekan,
  • "Getting started Transformation.ktr" fails on mavericks, while using shipped 1.7.0_60 java version. This is a mac-specific issue. Transformation works as expected while using java version 1.6 or 1.7.0_25. notice: If I run "Run all sample transformations" job - all samples pass. And if I run "Getting started Transformation.ktr" after the job - it will pass. After spoon restart the transformation is failing again. path: 1. Launch spoon, using 1.7.0_60 java version. 2. Open Sample "Getting started Transformation.ktr" and run it. Stacktrace: 2014/09/24 12:40:19 - Spoon - Launching transformation [Getting Started Transformation]... 2014/09/24 12:40:19 - Spoon - Started the transformation execution. 2014/09/24 12:40:20 - Getting Started Transformation - Dispatching started for transformation [Getting Started Transformation] 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : An error occurred intialising this step: 2014/09/24 12:40:20 - Write to Database.0 - Error occured while trying to connect to the database 2014/09/24 12:40:20 - Write to Database.0 - 2014/09/24 12:40:20 - Write to Database.0 - javax.naming.NoInitialContextException: Cannot instantiate class: org.osjava.sj.SimpleContextFactory [Root exception is java.lang.ClassNotFoundException: org.osjava.sj.SimpleContextFactory] 2014/09/24 12:40:20 - Write to Database.0 - Cannot instantiate class: org.osjava.sj.SimpleContextFactory 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Error initializing step [Write to Database] 2014/09/24 12:40:20 - Getting Started Transformation - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Step [Write to Database.0] failed to initialize! 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Unexpected error rolling back the database connection. 2014/09/24 12:40:20 - Write to Database.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2014/09/24 12:40:20 - Write to Database.0 - Unable to get database metadata from this database connection 2014/09/24 12:40:20 - Write to Database.0 - at java.lang.Thread.run (Thread.java:745) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.ui.spoon.trans.TransGraph$27.run (TransGraph.java:3989) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:1120) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:606) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:826) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:834) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2774) 2014/09/24 12:40:20 - Write to Database.0 - 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2777) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:834) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:826) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:606) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1120) 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.ui.spoon.trans.TransGraph$27.run(TransGraph.java:3989) 2014/09/24 12:40:20 - Write to Database.0 - at java.lang.Thread.run(Thread.java:745) 2014/09/24 12:40:20 - Write to Database.0 - Caused by: java.lang.NullPointerException 2014/09/24 12:40:20 - Write to Database.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2774) 2014/09/24 12:40:20 - Write to Database.0 - ... 6 more 2014/09/24 12:40:20 - Spoon - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Getting Started Transformation: preparing transformation execution failed 2014/09/24 12:40:20 - Spoon - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/09/24 12:40:20 - Spoon - We failed to initialize at least one step. Execution can not begin! 2014/09/24 12:40:20 - Spoon - 2014/09/24 12:40:20 - Spoon - 2014/09/24 12:40:20 - Spoon - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1149) 2014/09/24 12:40:20 - Spoon - at org.pentaho.di.ui.spoon.trans.TransGraph$27.run(TransGraph.java:3989) 2014/09/24 12:40:20 - Spoon - at java.lang.Thread.run(Thread.java:745) 2014/09/24 12:40:20 - Getting Started Transformation - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Errors detected! 2014/09/24 12:40:20 - Getting Started Transformation - ERROR (version 5.2.0.0, build 1 from 2014-09-21_16-13-06 by buildguy) : Errors detected!
    via by Ihar Chekan,
  • When a new MySQL connection is created, and the native JDBC Driver is used, the host has to be specified. If it's left blank, connection test doesn't show any error message, but when the connection is used for an output step it returns this error: 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : An error occurred intialising this step: 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error occured while trying to connect to the database 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error connecting to database: (using class org.gjt.mm.mysql.Driver) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.UnknownHostException MESSAGE: null STACKTRACE: java.net.UnknownHostException: null 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAddressFromNameService(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAllByName0(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAllByName(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAllByName(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:137) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.Connection.<init>(Connection.java:1485) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.sql.DriverManager.getConnection(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.sql.DriverManager.getConnection(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:416) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.normalConnect(Database.java:296) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.connect(Database.java:261) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.connect(Database.java:223) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:563) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:48) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. 2009/05/13 20:41:54 - Table output - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error initializing step [Table output] 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Step [Table output.0] failed to initialize! 2009/05/13 20:41:54 - hcv.0 - Finished reading query, closing connection. 2009/05/13 20:41:54 - hbsag.0 - Finished reading query, closing connection. 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error rolling back the database connection. 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unable to get database metadata from this database connection 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run (null:-1) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run (TransGraph.java:3188) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:651) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:661) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback (Database.java:641) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback (Database.java:652) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:3211) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3215) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:652) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:661) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:651) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3188) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Caused by: java.lang.NullPointerException 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3211) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ... 6 more 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Preparing transformation execution failed 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : org.pentaho.di.core.exception.KettleException: 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:676) 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3188) 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run(Unknown Source) 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Errors detected!
    via by Iuri Fanti,
  • Pentaho Spoon OK, Pentaho Kitchen ERROR
    via Stack Overflow by Isabelle
    ,
  • When a new MySQL connection is created, and the native JDBC Driver is used, the host has to be specified. If it's left blank, connection test doesn't show any error message, but when the connection is used for an output step it returns this error: 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : An error occurred intialising this step: 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error occured while trying to connect to the database 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error connecting to database: (using class org.gjt.mm.mysql.Driver) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.UnknownHostException MESSAGE: null STACKTRACE: java.net.UnknownHostException: null 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAddressFromNameService(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAllByName0(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAllByName(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.net.InetAddress.getAllByName(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:137) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.Connection.<init>(Connection.java:1485) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.sql.DriverManager.getConnection(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.sql.DriverManager.getConnection(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:416) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.normalConnect(Database.java:296) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.connect(Database.java:261) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.connect(Database.java:223) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:563) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:48) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. 2009/05/13 20:41:54 - Table output - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error initializing step [Table output] 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Step [Table output.0] failed to initialize! 2009/05/13 20:41:54 - hcv.0 - Finished reading query, closing connection. 2009/05/13 20:41:54 - hbsag.0 - Finished reading query, closing connection. 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error rolling back the database connection. 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unable to get database metadata from this database connection 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run (null:-1) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run (TransGraph.java:3188) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:651) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:661) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback (Database.java:641) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback (Database.java:652) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:3211) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3215) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:652) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:661) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:651) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3188) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run(Unknown Source) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Caused by: java.lang.NullPointerException 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3211) 2009/05/13 20:41:54 - Table output.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ... 6 more 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Preparing transformation execution failed 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : org.pentaho.di.core.exception.KettleException: 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:676) 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3188) 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.Thread.run(Unknown Source) 2009/05/13 20:41:54 - hcv_hbv_by_risk - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Errors detected!
    via by Iuri Fanti,
    • org.pentaho.di.core.exception.KettleDatabaseException: Unable to get database metadata from this database connection at java.lang.Thread.run (Thread.java:745) at org.pentaho.di.ui.spoon.trans.TransGraph$27.run (TransGraph.java:3989) at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:1120) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:606) at org.pentaho.di.core.database.Database.rollback (Database.java:826) at org.pentaho.di.core.database.Database.rollback (Database.java:834) at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2774) at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2777) at org.pentaho.di.core.database.Database.rollback(Database.java:834) at org.pentaho.di.core.database.Database.rollback(Database.java:826) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:606) at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1120) at org.pentaho.di.ui.spoon.trans.TransGraph$27.run(TransGraph.java:3989) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2774) ... 6 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,