Hi All,
Salam kenal, saya Andrey, newbie, baru banget pakai pentaho kettle hehe..
Saya ada problem dengan kettle terutama transformation,,
Saya buat Job untuk narik data selisih dari host external dan ditransformasi menjadi output ke database local.
Saya mendapatkan error dari JTDS, dan error tersebut intermitten, namun frekuensinya sering.
Berikut error transformasinya :
2013/09/26 11:47:40 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : An error occurred intialising this step:
2013/09/26 11:47:40 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error occured while trying to connect to the database
2013/09/26 11:47:40 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/09/26 11:47:40 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
2013/09/26 11:47:40 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Cannot open database "tani" requested by the login. The login failed.
2013/09/26 11:47:40 - Delete_existing.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : An error occurred, processing will be stopped:
2013/09/26 11:47:40 - Delete_existing.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error occured while trying to connect to the database
2013/09/26 11:47:40 - Delete_existing.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/09/26 11:47:40 - Delete_existing.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
2013/09/26 11:47:40 - Delete_existing.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Cannot open database "tani" requested by the login. The login failed.
2013/09/26 11:47:44 - Delete_existing.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error initializing step [Delete_existing]
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error initializing step [insert_rows_harga_prov_sipt]
2013/09/26 11:47:44 - data_harga_prov - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Step [Delete_existing.0] failed to initialize!
2013/09/26 11:47:44 - data_harga_prov - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Step [insert_rows_harga_prov_sipt.0] failed to initialize!
2013/09/26 11:47:44 - harga_prov_current_sipt.0 - Finished reading query, closing connection.
2013/09/26 11:47:44 - get_rows_harga_prov_pusdatin.0 - Finished reading query, closing connection.
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unexpected error rolling back the database connection.
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unable to get database metadata from this database connection
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at java.lang.Thread.run (Thread.java:662)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$22.run (TransGraph.java:3652)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:906)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:708)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.rollback (Database.java:713)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.rollback (Database.java:724)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:3101)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3105)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:724)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:713)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:708)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:906)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$22.run(TransGraph.java:3652)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at java.lang.Thread.run(Thread.java:662)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: java.lang.NullPointerException
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3101)
2013/09/26 11:47:44 - insert_rows_harga_prov_sipt.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : ... 6 more
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : data_harga_prov: preparing transformation execution failed
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleException:
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : We failed to initialize at least one step. Execution can not begin!
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:932)
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$22.run(TransGraph.java:3652)
2013/09/26 11:47:44 - Spoon - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at java.lang.Thread.run(Thread.java:662)
2013/09/26 11:47:44 - data_harga_prov - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
2013/09/26 11:47:44 - data_harga_prov - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
Any kind of help, i'll appreciate..
Thnx :-)..
Regards,
Andreanus.