error.. mohon bantuannya
8 views
Skip to first unread message
arkan sopian
Jan 26, 2011, 3:26:48 AM1/26/11
to penta...@googlegroups.com
Maaf kalau penjelasannya kurang jelas.
menggunakan kettle - spoon v 3.2
Mohon penjelasannya.
penjelasan :
tujuan design : utk mendapatkan variabel/parameter koneksi ke mysql yang diambil dari salah satu isi tabel di mysql (cabang).
get_xml : digunakan untuk mengcapture data yg ada di file xml yg selanjutnya di gunakan untuk parameter awal koneksi ke db mysql.
isi file xml nya sbb :
<?xml version="1.0"?>
<CONNECTIONS>
<CON>
<CABANG>PUSAT</CABANG>
<HOST>192.168.21.78</HOST>
<PORT>33010</PORT>
<USERNAME>innomodule</USERNAME>
<PASSWORD>innomodule</PASSWORD>
<DB>bisjk2</DB>
</CON>
</CONNECTIONS>
get n set variabel : setting data yg ada di xml tuk dijadikan variabel koneksi.
cek_ada_cabang : digunakan tuk mengecek data yg di cari ada atau ga.
executeSQL : digunakan tuk mendapatkan data yg akan di gunakan sbg variabel di tahap selanjutnya.
LIST ERROR :
2011/01/26 07:56:07 - SharedObjects - Reading the shared objects file [file:///C:/Users/sopian/.kettle/shared.xml]
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - The shared object fie [null] is empty!
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - We have 1 connections...
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at connection #0
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Reading 12 steps...
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #0
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Copy rows to result 2)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Copy rows to result 2
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #1
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Dummy (do nothing))
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Dummy (do nothing)
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #2
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (ExecuteSQLscript_cabang)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for ExecuteSQLscript_cabang
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #3
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Get data from XML)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Get data from XML
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #4
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (cek_ada_cabang)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for cek_ada_cabang
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #5
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (found_cabang)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for found_cabang
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #6
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (get_row_from_sql_result)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for get_row_from_sql_result
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #7
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Copy rows to result)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Copy rows to result
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #8
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Select values)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Select values
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #9
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Get rows from result)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Get rows from result
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #10
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Get Variables)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Get Variables
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #11
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Set Variables)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Set Variables
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - We have 11 hops...
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #0
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #1
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #2
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #3
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #4
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #5
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #6
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #7
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #8
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #9
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #10
2011/01/26 07:56:07 - get_var_connection_db - nr of steps read : 12
2011/01/26 07:56:07 - get_var_connection_db - nr of hops read : 11
2011/01/26 07:56:07 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened.
2011/01/26 07:56:07 - Spoon - Launching transformation [get_var_connection_db]...
2011/01/26 07:56:07 - Spoon - Started the transformation execution.
2011/01/26 07:56:07 - get_var_connection_db - Dispatching started for transformation [get_var_connection_db]
2011/01/26 07:56:07 - get_var_connection_db - Nr of arguments detected:0
2011/01/26 07:56:07 - get_var_connection_db - This is not a replay transformation
2011/01/26 07:56:07 - get_var_connection_db - Natural sort of steps executed in 0ms (12 time previous steps calculated)
2011/01/26 07:56:07 - get_var_connection_db - I found 12 different steps to launch.
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets...
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 0 --> cek_ada_cabang
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [cek_ada_cabang.0 - found_cabang.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 1 rowsets for step 0 --> cek_ada_cabang
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 1 --> found_cabang
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [found_cabang.0 - Dummy (do nothing).0]
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [found_cabang.0 - ExecuteSQLscript_cabang.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 3 rowsets for step 1 --> found_cabang
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 2 --> Dummy (do nothing)
2011/01/26 07:56:07 - get_var_connection_db - Allocated 3 rowsets for step 2 --> Dummy (do nothing)
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 3 --> ExecuteSQLscript_cabang
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [ExecuteSQLscript_cabang.0 - Copy rows to result 2.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 4 rowsets for step 3 --> ExecuteSQLscript_cabang
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 4 --> Copy rows to result 2
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Copy rows to result 2.0 - get_row_from_sql_result.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 5 rowsets for step 4 --> Copy rows to result 2
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 5 --> get_row_from_sql_result
2011/01/26 07:56:07 - get_var_connection_db - Allocated 5 rowsets for step 5 --> get_row_from_sql_result
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 6 --> Get data from XML
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Get data from XML.0 - Select values.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 6 rowsets for step 6 --> Get data from XML
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 7 --> Select values
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Select values.0 - Copy rows to result.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 7 rowsets for step 7 --> Select values
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 8 --> Copy rows to result
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Copy rows to result.0 - Get rows from result.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 8 rowsets for step 8 --> Copy rows to result
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 9 --> Get rows from result
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Get rows from result.0 - Get Variables.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 9 rowsets for step 9 --> Get rows from result
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 10 --> Get Variables
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Get Variables.0 - Set Variables.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 10 rowsets for step 10 --> Get Variables
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 11 --> Set Variables
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Set Variables.0 - cek_ada_cabang.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 11 rowsets for step 11 --> Set Variables
2011/01/26 07:56:07 - get_var_connection_db - Allocating Steps & StepData...
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [cek_ada_cabang] of type [TableInput]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - cek_ada_cabang.0 - distribution activated
2011/01/26 07:56:07 - cek_ada_cabang.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - cek_ada_cabang.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - cek_ada_cabang.0 - Got previous step from [cek_ada_cabang] #0 --> Set Variables
2011/01/26 07:56:07 - cek_ada_cabang.0 - input rel is 1:1
2011/01/26 07:56:07 - cek_ada_cabang.0 - Found input rowset [Set Variables.0 - cek_ada_cabang.0]
2011/01/26 07:56:07 - cek_ada_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - cek_ada_cabang.0 - Found output rowset [cek_ada_cabang.0 - found_cabang.0]
2011/01/26 07:56:07 - cek_ada_cabang.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [cek_ada_cabang].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [found_cabang] of type [FilterRows]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - found_cabang.0 - distribution activated
2011/01/26 07:56:07 - found_cabang.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - found_cabang.0 - Step info: nrinput=1 nroutput=2
2011/01/26 07:56:07 - found_cabang.0 - Got previous step from [found_cabang] #0 --> cek_ada_cabang
2011/01/26 07:56:07 - found_cabang.0 - input rel is 1:1
2011/01/26 07:56:07 - found_cabang.0 - Found input rowset [cek_ada_cabang.0 - found_cabang.0]
2011/01/26 07:56:07 - found_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - found_cabang.0 - Found output rowset [found_cabang.0 - Dummy (do nothing).0]
2011/01/26 07:56:07 - found_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - found_cabang.0 - Found output rowset [found_cabang.0 - ExecuteSQLscript_cabang.0]
2011/01/26 07:56:07 - found_cabang.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [found_cabang].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Dummy (do nothing)] of type [Dummy]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Dummy (do nothing).0 - distribution activated
2011/01/26 07:56:07 - Dummy (do nothing).0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Dummy (do nothing).0 - Step info: nrinput=1 nroutput=0
2011/01/26 07:56:07 - Dummy (do nothing).0 - Got previous step from [Dummy (do nothing)] #0 --> found_cabang
2011/01/26 07:56:07 - Dummy (do nothing).0 - input rel is 1:1
2011/01/26 07:56:07 - Dummy (do nothing).0 - Found input rowset [found_cabang.0 - Dummy (do nothing).0]
2011/01/26 07:56:07 - Dummy (do nothing).0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Dummy (do nothing)].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [ExecuteSQLscript_cabang] of type [ExecSQL]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - distribution activated
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Got previous step from [ExecuteSQLscript_cabang] #0 --> found_cabang
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - input rel is 1:1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Found input rowset [found_cabang.0 - ExecuteSQLscript_cabang.0]
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Found output rowset [ExecuteSQLscript_cabang.0 - Copy rows to result 2.0]
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [ExecuteSQLscript_cabang].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Copy rows to result 2] of type [RowsToResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Copy rows to result 2.0 - distribution activated
2011/01/26 07:56:07 - Copy rows to result 2.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Copy rows to result 2.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Copy rows to result 2.0 - Got previous step from [Copy rows to result 2] #0 --> ExecuteSQLscript_cabang
2011/01/26 07:56:07 - Copy rows to result 2.0 - input rel is 1:1
2011/01/26 07:56:07 - Copy rows to result 2.0 - Found input rowset [ExecuteSQLscript_cabang.0 - Copy rows to result 2.0]
2011/01/26 07:56:07 - Copy rows to result 2.0 - output rel. is 1:1
2011/01/26 07:56:07 - Copy rows to result 2.0 - Found output rowset [Copy rows to result 2.0 - get_row_from_sql_result.0]
2011/01/26 07:56:07 - Copy rows to result 2.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Copy rows to result 2].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [get_row_from_sql_result] of type [RowsFromResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - get_row_from_sql_result.0 - distribution activated
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Step info: nrinput=1 nroutput=0
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Got previous step from [get_row_from_sql_result] #0 --> Copy rows to result 2
2011/01/26 07:56:07 - get_row_from_sql_result.0 - input rel is 1:1
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Found input rowset [Copy rows to result 2.0 - get_row_from_sql_result.0]
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [get_row_from_sql_result].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Get data from XML] of type [getXMLData]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Get data from XML.0 - distribution activated
2011/01/26 07:56:07 - Get data from XML.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Get data from XML.0 - Step info: nrinput=0 nroutput=1
2011/01/26 07:56:07 - Get data from XML.0 - output rel. is 1:1
2011/01/26 07:56:07 - Get data from XML.0 - Found output rowset [Get data from XML.0 - Select values.0]
2011/01/26 07:56:07 - Get data from XML.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Get data from XML].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Select values] of type [SelectValues]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Select values.0 - distribution activated
2011/01/26 07:56:07 - Select values.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Select values.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Select values.0 - Got previous step from [Select values] #0 --> Get data from XML
2011/01/26 07:56:07 - Select values.0 - input rel is 1:1
2011/01/26 07:56:07 - Select values.0 - Found input rowset [Get data from XML.0 - Select values.0]
2011/01/26 07:56:07 - Select values.0 - output rel. is 1:1
2011/01/26 07:56:07 - Select values.0 - Found output rowset [Select values.0 - Copy rows to result.0]
2011/01/26 07:56:07 - Select values.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Select values].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Copy rows to result] of type [RowsToResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Copy rows to result.0 - distribution activated
2011/01/26 07:56:07 - Copy rows to result.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Copy rows to result.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Copy rows to result.0 - Got previous step from [Copy rows to result] #0 --> Select values
2011/01/26 07:56:07 - Copy rows to result.0 - input rel is 1:1
2011/01/26 07:56:07 - Copy rows to result.0 - Found input rowset [Select values.0 - Copy rows to result.0]
2011/01/26 07:56:07 - Copy rows to result.0 - output rel. is 1:1
2011/01/26 07:56:07 - Copy rows to result.0 - Found output rowset [Copy rows to result.0 - Get rows from result.0]
2011/01/26 07:56:07 - Copy rows to result.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Copy rows to result].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Get rows from result] of type [RowsFromResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Get rows from result.0 - distribution activated
2011/01/26 07:56:07 - Get rows from result.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Get rows from result.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Get rows from result.0 - Got previous step from [Get rows from result] #0 --> Copy rows to result
2011/01/26 07:56:07 - Get rows from result.0 - input rel is 1:1
2011/01/26 07:56:07 - Get rows from result.0 - Found input rowset [Copy rows to result.0 - Get rows from result.0]
2011/01/26 07:56:07 - Get rows from result.0 - output rel. is 1:1
2011/01/26 07:56:07 - Get rows from result.0 - Found output rowset [Get rows from result.0 - Get Variables.0]
2011/01/26 07:56:07 - Get rows from result.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Get rows from result].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Get Variables] of type [GetVariable]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Get Variables.0 - distribution activated
2011/01/26 07:56:07 - Get Variables.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Get Variables.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Get Variables.0 - Got previous step from [Get Variables] #0 --> Get rows from result
2011/01/26 07:56:07 - Get Variables.0 - input rel is 1:1
2011/01/26 07:56:07 - Get Variables.0 - Found input rowset [Get rows from result.0 - Get Variables.0]
2011/01/26 07:56:07 - Get Variables.0 - output rel. is 1:1
2011/01/26 07:56:07 - Get Variables.0 - Found output rowset [Get Variables.0 - Set Variables.0]
2011/01/26 07:56:07 - Get Variables.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Get Variables].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Set Variables] of type [SetVariable]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Set Variables.0 - distribution activated
2011/01/26 07:56:07 - Set Variables.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Set Variables.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Set Variables.0 - Got previous step from [Set Variables] #0 --> Get Variables
2011/01/26 07:56:07 - Set Variables.0 - input rel is 1:1
2011/01/26 07:56:07 - Set Variables.0 - Found input rowset [Get Variables.0 - Set Variables.0]
2011/01/26 07:56:07 - Set Variables.0 - output rel. is 1:1
2011/01/26 07:56:07 - Set Variables.0 - Found output rowset [Set Variables.0 - cek_ada_cabang.0]
2011/01/26 07:56:07 - Set Variables.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Set Variables].0
2011/01/26 07:56:07 - get_var_connection_db - This transformation can be replayed with replay date: 2011/01/26 07:56:07
2011/01/26 07:56:07 - get_var_connection_db - Initialising 12 steps...
2011/01/26 07:56:07 - cek_ada_cabang.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - con2_master_pivot - New database connection defined
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred, processing will be stopped:
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error occured while trying to connect to the database
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Must specify port after ':' in connection string
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - cek_ada_cabang - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error initializing step [cek_ada_cabang]
2011/01/26 07:56:07 - found_cabang.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Dummy (do nothing).0 - Running on slave server #0/1.
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Copy rows to result 2.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - con2_master_pivot - New database connection defined
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Get data from XML.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred, processing will be stopped:
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error occured while trying to connect to the database
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Must specify port after ':' in connection string
2011/01/26 07:56:07 - Get data from XML.0 - Looping Xpath is : /CONNECTIONS/CON
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - ExecuteSQLscript_cabang - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error initializing step [ExecuteSQLscript_cabang]
2011/01/26 07:56:07 - Select values.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Copy rows to result.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Get rows from result.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Set Variables.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Get Variables.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Step [cek_ada_cabang.0] failed to initialize!
2011/01/26 07:56:07 - get_var_connection_db - Step [found_cabang.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Dummy (do nothing).0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Step [ExecuteSQLscript_cabang.0] failed to initialize!
2011/01/26 07:56:07 - get_var_connection_db - Step [Copy rows to result 2.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [get_row_from_sql_result.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Get data from XML.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Select values.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Copy rows to result.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Get rows from result.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Get Variables.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Set Variables.0] initialized flawlessly.
2011/01/26 07:56:07 - cek_ada_cabang.0 - Finished reading query, closing connection.
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Finished reading query, closing connection.
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Preparing transformation execution failed
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleException:
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : We failed to initialize at least one step. Execution can not begin!
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:677)
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3192)
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.lang.Thread.run(Thread.java:595)
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
2011/01/26 07:56:44 - org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate@39859 - Delete step: Get rows from result
terima kasih,
sopian.
menggunakan kettle - spoon v 3.2
Mohon penjelasannya.
penjelasan :
tujuan design : utk mendapatkan variabel/parameter koneksi ke mysql yang diambil dari salah satu isi tabel di mysql (cabang).
get_xml : digunakan untuk mengcapture data yg ada di file xml yg selanjutnya di gunakan untuk parameter awal koneksi ke db mysql.
isi file xml nya sbb :
<?xml version="1.0"?>
<CONNECTIONS>
<CON>
<CABANG>PUSAT</CABANG>
<HOST>192.168.21.78</HOST>
<PORT>33010</PORT>
<USERNAME>innomodule</USERNAME>
<PASSWORD>innomodule</PASSWORD>
<DB>bisjk2</DB>
</CON>
</CONNECTIONS>
get n set variabel : setting data yg ada di xml tuk dijadikan variabel koneksi.
cek_ada_cabang : digunakan tuk mengecek data yg di cari ada atau ga.
executeSQL : digunakan tuk mendapatkan data yg akan di gunakan sbg variabel di tahap selanjutnya.
LIST ERROR :
2011/01/26 07:56:07 - SharedObjects - Reading the shared objects file [file:///C:/Users/sopian/.kettle/shared.xml]
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - The shared object fie [null] is empty!
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - We have 1 connections...
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at connection #0
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Reading 12 steps...
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #0
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Copy rows to result 2)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Copy rows to result 2
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #1
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Dummy (do nothing))
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Dummy (do nothing)
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #2
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (ExecuteSQLscript_cabang)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for ExecuteSQLscript_cabang
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #3
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Get data from XML)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Get data from XML
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #4
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (cek_ada_cabang)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for cek_ada_cabang
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #5
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (found_cabang)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for found_cabang
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #6
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (get_row_from_sql_result)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for get_row_from_sql_result
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #7
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Copy rows to result)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Copy rows to result
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #8
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Select values)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Select values
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #9
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Get rows from result)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Get rows from result
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #10
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Get Variables)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Get Variables
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at step #11
2011/01/26 07:56:07 - StepMeta() - looking for the right step node (Set Variables)
2011/01/26 07:56:07 - StepMeta() - specifics loaded for Set Variables
2011/01/26 07:56:07 - StepMeta() - end of readXML()
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - We have 11 hops...
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #0
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #1
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #2
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #3
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #4
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #5
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #6
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #7
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #8
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #9
2011/01/26 07:56:07 - org.pentaho.di.trans.TransMeta - Looking at hop #10
2011/01/26 07:56:07 - get_var_connection_db - nr of steps read : 12
2011/01/26 07:56:07 - get_var_connection_db - nr of hops read : 11
2011/01/26 07:56:07 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened.
2011/01/26 07:56:07 - Spoon - Launching transformation [get_var_connection_db]...
2011/01/26 07:56:07 - Spoon - Started the transformation execution.
2011/01/26 07:56:07 - get_var_connection_db - Dispatching started for transformation [get_var_connection_db]
2011/01/26 07:56:07 - get_var_connection_db - Nr of arguments detected:0
2011/01/26 07:56:07 - get_var_connection_db - This is not a replay transformation
2011/01/26 07:56:07 - get_var_connection_db - Natural sort of steps executed in 0ms (12 time previous steps calculated)
2011/01/26 07:56:07 - get_var_connection_db - I found 12 different steps to launch.
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets...
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 0 --> cek_ada_cabang
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [cek_ada_cabang.0 - found_cabang.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 1 rowsets for step 0 --> cek_ada_cabang
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 1 --> found_cabang
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [found_cabang.0 - Dummy (do nothing).0]
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [found_cabang.0 - ExecuteSQLscript_cabang.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 3 rowsets for step 1 --> found_cabang
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 2 --> Dummy (do nothing)
2011/01/26 07:56:07 - get_var_connection_db - Allocated 3 rowsets for step 2 --> Dummy (do nothing)
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 3 --> ExecuteSQLscript_cabang
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [ExecuteSQLscript_cabang.0 - Copy rows to result 2.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 4 rowsets for step 3 --> ExecuteSQLscript_cabang
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 4 --> Copy rows to result 2
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Copy rows to result 2.0 - get_row_from_sql_result.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 5 rowsets for step 4 --> Copy rows to result 2
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 5 --> get_row_from_sql_result
2011/01/26 07:56:07 - get_var_connection_db - Allocated 5 rowsets for step 5 --> get_row_from_sql_result
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 6 --> Get data from XML
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Get data from XML.0 - Select values.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 6 rowsets for step 6 --> Get data from XML
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 7 --> Select values
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Select values.0 - Copy rows to result.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 7 rowsets for step 7 --> Select values
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 8 --> Copy rows to result
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Copy rows to result.0 - Get rows from result.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 8 rowsets for step 8 --> Copy rows to result
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 9 --> Get rows from result
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Get rows from result.0 - Get Variables.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 9 rowsets for step 9 --> Get rows from result
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 10 --> Get Variables
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Get Variables.0 - Set Variables.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 10 rowsets for step 10 --> Get Variables
2011/01/26 07:56:07 - get_var_connection_db - Allocating rowsets for step 11 --> Set Variables
2011/01/26 07:56:07 - get_var_connection_db - prevcopies = 1, nextcopies=1
2011/01/26 07:56:07 - get_var_connection_db - Transformation allocated new rowset [Set Variables.0 - cek_ada_cabang.0]
2011/01/26 07:56:07 - get_var_connection_db - Allocated 11 rowsets for step 11 --> Set Variables
2011/01/26 07:56:07 - get_var_connection_db - Allocating Steps & StepData...
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [cek_ada_cabang] of type [TableInput]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - cek_ada_cabang.0 - distribution activated
2011/01/26 07:56:07 - cek_ada_cabang.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - cek_ada_cabang.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - cek_ada_cabang.0 - Got previous step from [cek_ada_cabang] #0 --> Set Variables
2011/01/26 07:56:07 - cek_ada_cabang.0 - input rel is 1:1
2011/01/26 07:56:07 - cek_ada_cabang.0 - Found input rowset [Set Variables.0 - cek_ada_cabang.0]
2011/01/26 07:56:07 - cek_ada_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - cek_ada_cabang.0 - Found output rowset [cek_ada_cabang.0 - found_cabang.0]
2011/01/26 07:56:07 - cek_ada_cabang.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [cek_ada_cabang].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [found_cabang] of type [FilterRows]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - found_cabang.0 - distribution activated
2011/01/26 07:56:07 - found_cabang.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - found_cabang.0 - Step info: nrinput=1 nroutput=2
2011/01/26 07:56:07 - found_cabang.0 - Got previous step from [found_cabang] #0 --> cek_ada_cabang
2011/01/26 07:56:07 - found_cabang.0 - input rel is 1:1
2011/01/26 07:56:07 - found_cabang.0 - Found input rowset [cek_ada_cabang.0 - found_cabang.0]
2011/01/26 07:56:07 - found_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - found_cabang.0 - Found output rowset [found_cabang.0 - Dummy (do nothing).0]
2011/01/26 07:56:07 - found_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - found_cabang.0 - Found output rowset [found_cabang.0 - ExecuteSQLscript_cabang.0]
2011/01/26 07:56:07 - found_cabang.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [found_cabang].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Dummy (do nothing)] of type [Dummy]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Dummy (do nothing).0 - distribution activated
2011/01/26 07:56:07 - Dummy (do nothing).0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Dummy (do nothing).0 - Step info: nrinput=1 nroutput=0
2011/01/26 07:56:07 - Dummy (do nothing).0 - Got previous step from [Dummy (do nothing)] #0 --> found_cabang
2011/01/26 07:56:07 - Dummy (do nothing).0 - input rel is 1:1
2011/01/26 07:56:07 - Dummy (do nothing).0 - Found input rowset [found_cabang.0 - Dummy (do nothing).0]
2011/01/26 07:56:07 - Dummy (do nothing).0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Dummy (do nothing)].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [ExecuteSQLscript_cabang] of type [ExecSQL]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - distribution activated
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Got previous step from [ExecuteSQLscript_cabang] #0 --> found_cabang
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - input rel is 1:1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Found input rowset [found_cabang.0 - ExecuteSQLscript_cabang.0]
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - output rel. is 1:1
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Found output rowset [ExecuteSQLscript_cabang.0 - Copy rows to result 2.0]
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [ExecuteSQLscript_cabang].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Copy rows to result 2] of type [RowsToResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Copy rows to result 2.0 - distribution activated
2011/01/26 07:56:07 - Copy rows to result 2.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Copy rows to result 2.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Copy rows to result 2.0 - Got previous step from [Copy rows to result 2] #0 --> ExecuteSQLscript_cabang
2011/01/26 07:56:07 - Copy rows to result 2.0 - input rel is 1:1
2011/01/26 07:56:07 - Copy rows to result 2.0 - Found input rowset [ExecuteSQLscript_cabang.0 - Copy rows to result 2.0]
2011/01/26 07:56:07 - Copy rows to result 2.0 - output rel. is 1:1
2011/01/26 07:56:07 - Copy rows to result 2.0 - Found output rowset [Copy rows to result 2.0 - get_row_from_sql_result.0]
2011/01/26 07:56:07 - Copy rows to result 2.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Copy rows to result 2].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [get_row_from_sql_result] of type [RowsFromResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - get_row_from_sql_result.0 - distribution activated
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Step info: nrinput=1 nroutput=0
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Got previous step from [get_row_from_sql_result] #0 --> Copy rows to result 2
2011/01/26 07:56:07 - get_row_from_sql_result.0 - input rel is 1:1
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Found input rowset [Copy rows to result 2.0 - get_row_from_sql_result.0]
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [get_row_from_sql_result].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Get data from XML] of type [getXMLData]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Get data from XML.0 - distribution activated
2011/01/26 07:56:07 - Get data from XML.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Get data from XML.0 - Step info: nrinput=0 nroutput=1
2011/01/26 07:56:07 - Get data from XML.0 - output rel. is 1:1
2011/01/26 07:56:07 - Get data from XML.0 - Found output rowset [Get data from XML.0 - Select values.0]
2011/01/26 07:56:07 - Get data from XML.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Get data from XML].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Select values] of type [SelectValues]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Select values.0 - distribution activated
2011/01/26 07:56:07 - Select values.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Select values.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Select values.0 - Got previous step from [Select values] #0 --> Get data from XML
2011/01/26 07:56:07 - Select values.0 - input rel is 1:1
2011/01/26 07:56:07 - Select values.0 - Found input rowset [Get data from XML.0 - Select values.0]
2011/01/26 07:56:07 - Select values.0 - output rel. is 1:1
2011/01/26 07:56:07 - Select values.0 - Found output rowset [Select values.0 - Copy rows to result.0]
2011/01/26 07:56:07 - Select values.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Select values].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Copy rows to result] of type [RowsToResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Copy rows to result.0 - distribution activated
2011/01/26 07:56:07 - Copy rows to result.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Copy rows to result.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Copy rows to result.0 - Got previous step from [Copy rows to result] #0 --> Select values
2011/01/26 07:56:07 - Copy rows to result.0 - input rel is 1:1
2011/01/26 07:56:07 - Copy rows to result.0 - Found input rowset [Select values.0 - Copy rows to result.0]
2011/01/26 07:56:07 - Copy rows to result.0 - output rel. is 1:1
2011/01/26 07:56:07 - Copy rows to result.0 - Found output rowset [Copy rows to result.0 - Get rows from result.0]
2011/01/26 07:56:07 - Copy rows to result.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Copy rows to result].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Get rows from result] of type [RowsFromResult]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Get rows from result.0 - distribution activated
2011/01/26 07:56:07 - Get rows from result.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Get rows from result.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Get rows from result.0 - Got previous step from [Get rows from result] #0 --> Copy rows to result
2011/01/26 07:56:07 - Get rows from result.0 - input rel is 1:1
2011/01/26 07:56:07 - Get rows from result.0 - Found input rowset [Copy rows to result.0 - Get rows from result.0]
2011/01/26 07:56:07 - Get rows from result.0 - output rel. is 1:1
2011/01/26 07:56:07 - Get rows from result.0 - Found output rowset [Get rows from result.0 - Get Variables.0]
2011/01/26 07:56:07 - Get rows from result.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Get rows from result].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Get Variables] of type [GetVariable]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Get Variables.0 - distribution activated
2011/01/26 07:56:07 - Get Variables.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Get Variables.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Get Variables.0 - Got previous step from [Get Variables] #0 --> Get rows from result
2011/01/26 07:56:07 - Get Variables.0 - input rel is 1:1
2011/01/26 07:56:07 - Get Variables.0 - Found input rowset [Get rows from result.0 - Get Variables.0]
2011/01/26 07:56:07 - Get Variables.0 - output rel. is 1:1
2011/01/26 07:56:07 - Get Variables.0 - Found output rowset [Get Variables.0 - Set Variables.0]
2011/01/26 07:56:07 - Get Variables.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Get Variables].0
2011/01/26 07:56:07 - get_var_connection_db - Transformation is about to allocate step [Set Variables] of type [SetVariable]
2011/01/26 07:56:07 - get_var_connection_db - Step has nrcopies=1
2011/01/26 07:56:07 - Set Variables.0 - distribution activated
2011/01/26 07:56:07 - Set Variables.0 - Starting allocation of buffers & new threads...
2011/01/26 07:56:07 - Set Variables.0 - Step info: nrinput=1 nroutput=1
2011/01/26 07:56:07 - Set Variables.0 - Got previous step from [Set Variables] #0 --> Get Variables
2011/01/26 07:56:07 - Set Variables.0 - input rel is 1:1
2011/01/26 07:56:07 - Set Variables.0 - Found input rowset [Get Variables.0 - Set Variables.0]
2011/01/26 07:56:07 - Set Variables.0 - output rel. is 1:1
2011/01/26 07:56:07 - Set Variables.0 - Found output rowset [Set Variables.0 - cek_ada_cabang.0]
2011/01/26 07:56:07 - Set Variables.0 - Finished dispatching
2011/01/26 07:56:07 - get_var_connection_db - Transformation has allocated a new step: [Set Variables].0
2011/01/26 07:56:07 - get_var_connection_db - This transformation can be replayed with replay date: 2011/01/26 07:56:07
2011/01/26 07:56:07 - get_var_connection_db - Initialising 12 steps...
2011/01/26 07:56:07 - cek_ada_cabang.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - con2_master_pivot - New database connection defined
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred, processing will be stopped:
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error occured while trying to connect to the database
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2011/01/26 07:56:07 - cek_ada_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Must specify port after ':' in connection string
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - cek_ada_cabang - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error initializing step [cek_ada_cabang]
2011/01/26 07:56:07 - found_cabang.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Dummy (do nothing).0 - Running on slave server #0/1.
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Copy rows to result 2.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - con2_master_pivot - New database connection defined
2011/01/26 07:56:07 - get_row_from_sql_result.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Get data from XML.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred, processing will be stopped:
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error occured while trying to connect to the database
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Must specify port after ':' in connection string
2011/01/26 07:56:07 - Get data from XML.0 - Looping Xpath is : /CONNECTIONS/CON
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - con2_master_pivot - Statement canceled!
2011/01/26 07:56:07 - ExecuteSQLscript_cabang - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error initializing step [ExecuteSQLscript_cabang]
2011/01/26 07:56:07 - Select values.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Copy rows to result.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Get rows from result.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Set Variables.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - Get Variables.0 - Running on slave server #0/1.
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Step [cek_ada_cabang.0] failed to initialize!
2011/01/26 07:56:07 - get_var_connection_db - Step [found_cabang.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Dummy (do nothing).0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Step [ExecuteSQLscript_cabang.0] failed to initialize!
2011/01/26 07:56:07 - get_var_connection_db - Step [Copy rows to result 2.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [get_row_from_sql_result.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Get data from XML.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Select values.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Copy rows to result.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Get rows from result.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Get Variables.0] initialized flawlessly.
2011/01/26 07:56:07 - get_var_connection_db - Step [Set Variables.0] initialized flawlessly.
2011/01/26 07:56:07 - cek_ada_cabang.0 - Finished reading query, closing connection.
2011/01/26 07:56:07 - ExecuteSQLscript_cabang.0 - Finished reading query, closing connection.
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Preparing transformation execution failed
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleException:
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : We failed to initialize at least one step. Execution can not begin!
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:677)
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3192)
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.lang.Thread.run(Thread.java:595)
2011/01/26 07:56:07 - get_var_connection_db - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
2011/01/26 07:56:44 - org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate@39859 - Delete step: Get rows from result
terima kasih,
sopian.
Reply all
Reply to author
Forward
0 new messages