JohnMIII
03-22-2012, 12:34 PM
I set up a very simple test after having problems with setting variables in a transformation that used the metadata Injector Object. I thought that it had something to do with the metadata injector but it did not. I have a job that runs two transformations.
Job Short_Test_Run_Using_Variables
1. use_setOutputVariables
2.use_ShowOutputVariables
The log below shows the results of running the job in spoon. The log shows the variables being set correctly and displayed in the log but the second transformation that retreives the values does not show the correct results.
I have nothing set in kettle.properties. Can someone please point out what I am missing. I can set and access variables using kettle.properties but not using the above method.
2012/03/22 09:10:48 - Spoon - Starting job...
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Start of job execution
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - exec(0, 0, START.0)
2012/03/22 09:10:48 - START - Starting job entry
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Starting entry [use_setOutPutVariables]
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - exec(1, 0, use_setOutPutVariables.0)
2012/03/22 09:10:48 - use_setOutPutVariables - Starting job entry
2012/03/22 09:10:48 - use_setOutPutVariables - Opening transformation: [F:\EtlUtilities\use_setOutPutVariables.ktr]
2012/03/22 09:10:48 - use_setOutPutVariables - Loading transformation from XML file [F:\EtlUtilities\use_setOutPutVariables.ktr]
2012/03/22 09:10:48 - Transformation metadata - The shared object fie [null] is empty!
2012/03/22 09:10:48 - Transformation metadata - We have 0 connections...
2012/03/22 09:10:48 - Transformation metadata - Reading 3 steps...
2012/03/22 09:10:48 - Transformation metadata - Looking at step #0
2012/03/22 09:10:48 - Transformation metadata - Looking at step #1
2012/03/22 09:10:48 - Transformation metadata - Looking at step #2
2012/03/22 09:10:48 - Transformation metadata - We have 2 hops...
2012/03/22 09:10:48 - Transformation metadata - Looking at hop #0
2012/03/22 09:10:48 - Transformation metadata - Looking at hop #1
2012/03/22 09:10:48 - Transformation metadata - nr of steps read : 3
2012/03/22 09:10:48 - Transformation metadata - nr of hops read : 2
2012/03/22 09:10:48 - use_setOutPutVariables - Starting transformation...(file=F:\EtlUtilities\use_setOutPutVariables.ktr, name=use_setOutPutVariables, repinfo=null)
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is pre-loaded.
2012/03/22 09:10:48 - use_setOutPutVariables - nr of steps to run : 3 , nr of hops : 2
2012/03/22 09:10:48 - use_setOutPutVariables - Dispatching started for transformation [use_setOutPutVariables]
2012/03/22 09:10:48 - use_setOutPutVariables - Nr of arguments detected:10
2012/03/22 09:10:48 - use_setOutPutVariables - This is not a replay transformation
2012/03/22 09:10:48 - use_setOutPutVariables - I found 3 different steps to launch.
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets...
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets for step 0 --> GetFilenameOut
2012/03/22 09:10:48 - use_setOutPutVariables - prevcopies = 1, nextcopies=1
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation allocated new rowset [GetFilenameOut.0 - Set Variables.0]
2012/03/22 09:10:48 - use_setOutPutVariables - Allocated 1 rowsets for step 0 --> GetFilenameOut
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets for step 1 --> Set Variables
2012/03/22 09:10:48 - use_setOutPutVariables - prevcopies = 1, nextcopies=1
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation allocated new rowset [Set Variables.0 - Write to log.0]
2012/03/22 09:10:48 - use_setOutPutVariables - Allocated 2 rowsets for step 1 --> Set Variables
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets for step 2 --> Write to log
2012/03/22 09:10:48 - use_setOutPutVariables - Allocated 2 rowsets for step 2 --> Write to log
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating Steps & StepData...
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is about to allocate step [GetFilenameOut] of type [CsvInput]
2012/03/22 09:10:48 - use_setOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - GetFilenameOut.0 - distribution activated
2012/03/22 09:10:48 - GetFilenameOut.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - GetFilenameOut.0 - Step info: nrinput=0 nroutput=1
2012/03/22 09:10:48 - GetFilenameOut.0 - output rel. is 1:1
2012/03/22 09:10:48 - GetFilenameOut.0 - Found output rowset [GetFilenameOut.0 - Set Variables.0]
2012/03/22 09:10:48 - GetFilenameOut.0 - Finished dispatching
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated a new step: [GetFilenameOut].0
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is about to allocate step [Set Variables] of type [SetVariable]
2012/03/22 09:10:48 - use_setOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Set Variables.0 - distribution activated
2012/03/22 09:10:48 - Set Variables.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Set Variables.0 - Step info: nrinput=1 nroutput=1
2012/03/22 09:10:48 - Set Variables.0 - Got previous step from [Set Variables] #0 --> GetFilenameOut
2012/03/22 09:10:48 - Set Variables.0 - input rel is 1:1
2012/03/22 09:10:48 - Set Variables.0 - Found input rowset [GetFilenameOut.0 - Set Variables.0]
2012/03/22 09:10:48 - Set Variables.0 - output rel. is 1:1
2012/03/22 09:10:48 - Set Variables.0 - Found output rowset [Set Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Set Variables.0 - Finished dispatching
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated a new step: [Set Variables].0
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is about to allocate step [Write to log] of type [WriteToLog]
2012/03/22 09:10:48 - use_setOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Write to log.0 - distribution activated
2012/03/22 09:10:48 - Write to log.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Write to log.0 - Step info: nrinput=1 nroutput=0
2012/03/22 09:10:48 - Write to log.0 - Got previous step from [Write to log] #0 --> Set Variables
2012/03/22 09:10:48 - Write to log.0 - input rel is 1:1
2012/03/22 09:10:48 - Write to log.0 - Found input rowset [Set Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Write to log.0 - Finished dispatching
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated a new step: [Write to log].0
2012/03/22 09:10:48 - use_setOutPutVariables - This transformation can be replayed with replay date: 2012/03/22 09:10:48
2012/03/22 09:10:48 - use_setOutPutVariables - Initialising 3 steps...
2012/03/22 09:10:48 - Write to log.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - Set Variables.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - GetFilenameOut.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - use_setOutPutVariables - Step [GetFilenameOut.0] initialized flawlessly.
2012/03/22 09:10:48 - use_setOutPutVariables - Step [Set Variables.0] initialized flawlessly.
2012/03/22 09:10:48 - use_setOutPutVariables - Step [Write to log.0] initialized flawlessly.
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated 3 threads and 2 rowsets.
2012/03/22 09:10:48 - GetFilenameOut.0 - Starting to run...
2012/03/22 09:10:48 - Set Variables.0 - Starting to run...
2012/03/22 09:10:48 - Write to log.0 - Starting to run...
2012/03/22 09:10:48 - GetFilenameOut.0 - Header row skipped in file 'F:\UtilityEtlFiles\OutputTestFileName.txt'
2012/03/22 09:10:48 - GetFilenameOut.0 - Signaling 'output done' to 1 output rowsets.
2012/03/22 09:10:48 - GetFilenameOut.0 - Finished processing (I=2, O=0, R=0, W=1, U=0, E=0)
2012/03/22 09:10:48 - Set Variables.0 - Setting environment variables...
2012/03/22 09:10:48 - Set Variables.0 - Set variable ${OutFileName} to value [f:/UtilityEtlFiles/TestFileOutput1.txt]
2012/03/22 09:10:48 - Set Variables.0 - Set variable ${Delimeter} to value [?]
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ------------> Linenr 1------------------------------
2012/03/22 09:10:48 - Write to log.0 - look at set variables
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - outfilename = f:/UtilityEtlFiles/TestFileOutput1.txt
2012/03/22 09:10:48 - Write to log.0 - OutDelm = ?
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ====================
2012/03/22 09:10:48 - Set Variables.0 - Finished after 1 rows.
2012/03/22 09:10:48 - Set Variables.0 - Signaling 'output done' to 1 output rowsets.
2012/03/22 09:10:48 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Write to log.0 - Signaling 'output done' to 0 output rowsets.
2012/03/22 09:10:48 - Write to log.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Starting entry [use_ShowOutPutVariables]
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - exec(2, 0, use_ShowOutPutVariables.0)
2012/03/22 09:10:48 - use_ShowOutPutVariables - Starting job entry
2012/03/22 09:10:48 - use_ShowOutPutVariables - Opening transformation: [file:///F:/EtlUtilities/use_ShowOutPutVariables.ktr]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Loading transformation from XML file [file:///F:/EtlUtilities/use_ShowOutPutVariables.ktr]
2012/03/22 09:10:48 - Transformation metadata - The shared object fie [null] is empty!
2012/03/22 09:10:48 - Transformation metadata - We have 0 connections...
2012/03/22 09:10:48 - Transformation metadata - Reading 2 steps...
2012/03/22 09:10:48 - Transformation metadata - Looking at step #0
2012/03/22 09:10:48 - Transformation metadata - Looking at step #1
2012/03/22 09:10:48 - Transformation metadata - We have 1 hops...
2012/03/22 09:10:48 - Transformation metadata - Looking at hop #0
2012/03/22 09:10:48 - Transformation metadata - nr of steps read : 2
2012/03/22 09:10:48 - Transformation metadata - nr of hops read : 1
2012/03/22 09:10:48 - use_ShowOutPutVariables - Starting transformation...(file=${Internal.Job.Filename.Directory}/use_ShowOutPutVariables.ktr, name=use_ShowOutPutVariables, repinfo=null)
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation is pre-loaded.
2012/03/22 09:10:48 - use_ShowOutPutVariables - nr of steps to run : 2 , nr of hops : 1
2012/03/22 09:10:48 - use_ShowOutPutVariables - Dispatching started for transformation [use_ShowOutPutVariables]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Nr of arguments detected:10
2012/03/22 09:10:48 - use_ShowOutPutVariables - This is not a replay transformation
2012/03/22 09:10:48 - use_ShowOutPutVariables - I found 2 different steps to launch.
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating rowsets...
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating rowsets for step 0 --> Get Variables
2012/03/22 09:10:48 - use_ShowOutPutVariables - prevcopies = 1, nextcopies=1
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation allocated new rowset [Get Variables.0 - Write to log.0]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocated 1 rowsets for step 0 --> Get Variables
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating rowsets for step 1 --> Write to log
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocated 1 rowsets for step 1 --> Write to log
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating Steps & StepData...
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation is about to allocate step [Get Variables] of type [GetVariable]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Get Variables.0 - distribution activated
2012/03/22 09:10:48 - Get Variables.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Get Variables.0 - Step info: nrinput=0 nroutput=1
2012/03/22 09:10:48 - Get Variables.0 - output rel. is 1:1
2012/03/22 09:10:48 - Get Variables.0 - Found output rowset [Get Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Get Variables.0 - Finished dispatching
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation has allocated a new step: [Get Variables].0
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation is about to allocate step [Write to log] of type [WriteToLog]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Write to log.0 - distribution activated
2012/03/22 09:10:48 - Write to log.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Write to log.0 - Step info: nrinput=1 nroutput=0
2012/03/22 09:10:48 - Write to log.0 - Got previous step from [Write to log] #0 --> Get Variables
2012/03/22 09:10:48 - Write to log.0 - input rel is 1:1
2012/03/22 09:10:48 - Write to log.0 - Found input rowset [Get Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Write to log.0 - Finished dispatching
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation has allocated a new step: [Write to log].0
2012/03/22 09:10:48 - use_ShowOutPutVariables - This transformation can be replayed with replay date: 2012/03/22 09:10:48
2012/03/22 09:10:48 - use_ShowOutPutVariables - Initialising 2 steps...
2012/03/22 09:10:48 - Get Variables.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - Write to log.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step [Get Variables.0] initialized flawlessly.
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step [Write to log.0] initialized flawlessly.
2012/03/22 09:10:48 - Get Variables.0 - Starting to run...
2012/03/22 09:10:48 - Get Variables.0 - field [Testdel] has value [${Delimeter}]
2012/03/22 09:10:48 - Get Variables.0 - field [TESTFile] has value [${OutFileName}]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation has allocated 2 threads and 1 rowsets.
2012/03/22 09:10:48 - Get Variables.0 - Signaling 'output done' to 1 output rowsets.
2012/03/22 09:10:48 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Write to log.0 - Starting to run...
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ------------> Linenr 1------------------------------
2012/03/22 09:10:48 - Write to log.0 - Testdel = ${Delimeter}
2012/03/22 09:10:48 - Write to log.0 - TESTFile = ${OutFileName}
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ====================
2012/03/22 09:10:48 - Write to log.0 - Signaling 'output done' to 0 output rowsets.
2012/03/22 09:10:48 - Write to log.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Finished job entry [use_ShowOutPutVariables] (result=[true])
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Finished job entry [use_setOutPutVariables] (result=[true])
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Job execution finished
2012/03/22 09:10:48 - Spoon - Job has ended.
Job Short_Test_Run_Using_Variables
1. use_setOutputVariables
2.use_ShowOutputVariables
The log below shows the results of running the job in spoon. The log shows the variables being set correctly and displayed in the log but the second transformation that retreives the values does not show the correct results.
I have nothing set in kettle.properties. Can someone please point out what I am missing. I can set and access variables using kettle.properties but not using the above method.
2012/03/22 09:10:48 - Spoon - Starting job...
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Start of job execution
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - exec(0, 0, START.0)
2012/03/22 09:10:48 - START - Starting job entry
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Starting entry [use_setOutPutVariables]
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - exec(1, 0, use_setOutPutVariables.0)
2012/03/22 09:10:48 - use_setOutPutVariables - Starting job entry
2012/03/22 09:10:48 - use_setOutPutVariables - Opening transformation: [F:\EtlUtilities\use_setOutPutVariables.ktr]
2012/03/22 09:10:48 - use_setOutPutVariables - Loading transformation from XML file [F:\EtlUtilities\use_setOutPutVariables.ktr]
2012/03/22 09:10:48 - Transformation metadata - The shared object fie [null] is empty!
2012/03/22 09:10:48 - Transformation metadata - We have 0 connections...
2012/03/22 09:10:48 - Transformation metadata - Reading 3 steps...
2012/03/22 09:10:48 - Transformation metadata - Looking at step #0
2012/03/22 09:10:48 - Transformation metadata - Looking at step #1
2012/03/22 09:10:48 - Transformation metadata - Looking at step #2
2012/03/22 09:10:48 - Transformation metadata - We have 2 hops...
2012/03/22 09:10:48 - Transformation metadata - Looking at hop #0
2012/03/22 09:10:48 - Transformation metadata - Looking at hop #1
2012/03/22 09:10:48 - Transformation metadata - nr of steps read : 3
2012/03/22 09:10:48 - Transformation metadata - nr of hops read : 2
2012/03/22 09:10:48 - use_setOutPutVariables - Starting transformation...(file=F:\EtlUtilities\use_setOutPutVariables.ktr, name=use_setOutPutVariables, repinfo=null)
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is pre-loaded.
2012/03/22 09:10:48 - use_setOutPutVariables - nr of steps to run : 3 , nr of hops : 2
2012/03/22 09:10:48 - use_setOutPutVariables - Dispatching started for transformation [use_setOutPutVariables]
2012/03/22 09:10:48 - use_setOutPutVariables - Nr of arguments detected:10
2012/03/22 09:10:48 - use_setOutPutVariables - This is not a replay transformation
2012/03/22 09:10:48 - use_setOutPutVariables - I found 3 different steps to launch.
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets...
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets for step 0 --> GetFilenameOut
2012/03/22 09:10:48 - use_setOutPutVariables - prevcopies = 1, nextcopies=1
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation allocated new rowset [GetFilenameOut.0 - Set Variables.0]
2012/03/22 09:10:48 - use_setOutPutVariables - Allocated 1 rowsets for step 0 --> GetFilenameOut
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets for step 1 --> Set Variables
2012/03/22 09:10:48 - use_setOutPutVariables - prevcopies = 1, nextcopies=1
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation allocated new rowset [Set Variables.0 - Write to log.0]
2012/03/22 09:10:48 - use_setOutPutVariables - Allocated 2 rowsets for step 1 --> Set Variables
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating rowsets for step 2 --> Write to log
2012/03/22 09:10:48 - use_setOutPutVariables - Allocated 2 rowsets for step 2 --> Write to log
2012/03/22 09:10:48 - use_setOutPutVariables - Allocating Steps & StepData...
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is about to allocate step [GetFilenameOut] of type [CsvInput]
2012/03/22 09:10:48 - use_setOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - GetFilenameOut.0 - distribution activated
2012/03/22 09:10:48 - GetFilenameOut.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - GetFilenameOut.0 - Step info: nrinput=0 nroutput=1
2012/03/22 09:10:48 - GetFilenameOut.0 - output rel. is 1:1
2012/03/22 09:10:48 - GetFilenameOut.0 - Found output rowset [GetFilenameOut.0 - Set Variables.0]
2012/03/22 09:10:48 - GetFilenameOut.0 - Finished dispatching
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated a new step: [GetFilenameOut].0
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is about to allocate step [Set Variables] of type [SetVariable]
2012/03/22 09:10:48 - use_setOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Set Variables.0 - distribution activated
2012/03/22 09:10:48 - Set Variables.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Set Variables.0 - Step info: nrinput=1 nroutput=1
2012/03/22 09:10:48 - Set Variables.0 - Got previous step from [Set Variables] #0 --> GetFilenameOut
2012/03/22 09:10:48 - Set Variables.0 - input rel is 1:1
2012/03/22 09:10:48 - Set Variables.0 - Found input rowset [GetFilenameOut.0 - Set Variables.0]
2012/03/22 09:10:48 - Set Variables.0 - output rel. is 1:1
2012/03/22 09:10:48 - Set Variables.0 - Found output rowset [Set Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Set Variables.0 - Finished dispatching
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated a new step: [Set Variables].0
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation is about to allocate step [Write to log] of type [WriteToLog]
2012/03/22 09:10:48 - use_setOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Write to log.0 - distribution activated
2012/03/22 09:10:48 - Write to log.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Write to log.0 - Step info: nrinput=1 nroutput=0
2012/03/22 09:10:48 - Write to log.0 - Got previous step from [Write to log] #0 --> Set Variables
2012/03/22 09:10:48 - Write to log.0 - input rel is 1:1
2012/03/22 09:10:48 - Write to log.0 - Found input rowset [Set Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Write to log.0 - Finished dispatching
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated a new step: [Write to log].0
2012/03/22 09:10:48 - use_setOutPutVariables - This transformation can be replayed with replay date: 2012/03/22 09:10:48
2012/03/22 09:10:48 - use_setOutPutVariables - Initialising 3 steps...
2012/03/22 09:10:48 - Write to log.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - Set Variables.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - GetFilenameOut.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - use_setOutPutVariables - Step [GetFilenameOut.0] initialized flawlessly.
2012/03/22 09:10:48 - use_setOutPutVariables - Step [Set Variables.0] initialized flawlessly.
2012/03/22 09:10:48 - use_setOutPutVariables - Step [Write to log.0] initialized flawlessly.
2012/03/22 09:10:48 - use_setOutPutVariables - Transformation has allocated 3 threads and 2 rowsets.
2012/03/22 09:10:48 - GetFilenameOut.0 - Starting to run...
2012/03/22 09:10:48 - Set Variables.0 - Starting to run...
2012/03/22 09:10:48 - Write to log.0 - Starting to run...
2012/03/22 09:10:48 - GetFilenameOut.0 - Header row skipped in file 'F:\UtilityEtlFiles\OutputTestFileName.txt'
2012/03/22 09:10:48 - GetFilenameOut.0 - Signaling 'output done' to 1 output rowsets.
2012/03/22 09:10:48 - GetFilenameOut.0 - Finished processing (I=2, O=0, R=0, W=1, U=0, E=0)
2012/03/22 09:10:48 - Set Variables.0 - Setting environment variables...
2012/03/22 09:10:48 - Set Variables.0 - Set variable ${OutFileName} to value [f:/UtilityEtlFiles/TestFileOutput1.txt]
2012/03/22 09:10:48 - Set Variables.0 - Set variable ${Delimeter} to value [?]
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ------------> Linenr 1------------------------------
2012/03/22 09:10:48 - Write to log.0 - look at set variables
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - outfilename = f:/UtilityEtlFiles/TestFileOutput1.txt
2012/03/22 09:10:48 - Write to log.0 - OutDelm = ?
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ====================
2012/03/22 09:10:48 - Set Variables.0 - Finished after 1 rows.
2012/03/22 09:10:48 - Set Variables.0 - Signaling 'output done' to 1 output rowsets.
2012/03/22 09:10:48 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Write to log.0 - Signaling 'output done' to 0 output rowsets.
2012/03/22 09:10:48 - Write to log.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Starting entry [use_ShowOutPutVariables]
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - exec(2, 0, use_ShowOutPutVariables.0)
2012/03/22 09:10:48 - use_ShowOutPutVariables - Starting job entry
2012/03/22 09:10:48 - use_ShowOutPutVariables - Opening transformation: [file:///F:/EtlUtilities/use_ShowOutPutVariables.ktr]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Loading transformation from XML file [file:///F:/EtlUtilities/use_ShowOutPutVariables.ktr]
2012/03/22 09:10:48 - Transformation metadata - The shared object fie [null] is empty!
2012/03/22 09:10:48 - Transformation metadata - We have 0 connections...
2012/03/22 09:10:48 - Transformation metadata - Reading 2 steps...
2012/03/22 09:10:48 - Transformation metadata - Looking at step #0
2012/03/22 09:10:48 - Transformation metadata - Looking at step #1
2012/03/22 09:10:48 - Transformation metadata - We have 1 hops...
2012/03/22 09:10:48 - Transformation metadata - Looking at hop #0
2012/03/22 09:10:48 - Transformation metadata - nr of steps read : 2
2012/03/22 09:10:48 - Transformation metadata - nr of hops read : 1
2012/03/22 09:10:48 - use_ShowOutPutVariables - Starting transformation...(file=${Internal.Job.Filename.Directory}/use_ShowOutPutVariables.ktr, name=use_ShowOutPutVariables, repinfo=null)
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation is pre-loaded.
2012/03/22 09:10:48 - use_ShowOutPutVariables - nr of steps to run : 2 , nr of hops : 1
2012/03/22 09:10:48 - use_ShowOutPutVariables - Dispatching started for transformation [use_ShowOutPutVariables]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Nr of arguments detected:10
2012/03/22 09:10:48 - use_ShowOutPutVariables - This is not a replay transformation
2012/03/22 09:10:48 - use_ShowOutPutVariables - I found 2 different steps to launch.
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating rowsets...
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating rowsets for step 0 --> Get Variables
2012/03/22 09:10:48 - use_ShowOutPutVariables - prevcopies = 1, nextcopies=1
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation allocated new rowset [Get Variables.0 - Write to log.0]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocated 1 rowsets for step 0 --> Get Variables
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating rowsets for step 1 --> Write to log
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocated 1 rowsets for step 1 --> Write to log
2012/03/22 09:10:48 - use_ShowOutPutVariables - Allocating Steps & StepData...
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation is about to allocate step [Get Variables] of type [GetVariable]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Get Variables.0 - distribution activated
2012/03/22 09:10:48 - Get Variables.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Get Variables.0 - Step info: nrinput=0 nroutput=1
2012/03/22 09:10:48 - Get Variables.0 - output rel. is 1:1
2012/03/22 09:10:48 - Get Variables.0 - Found output rowset [Get Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Get Variables.0 - Finished dispatching
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation has allocated a new step: [Get Variables].0
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation is about to allocate step [Write to log] of type [WriteToLog]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step has nrcopies=1
2012/03/22 09:10:48 - Write to log.0 - distribution activated
2012/03/22 09:10:48 - Write to log.0 - Starting allocation of buffers & new threads...
2012/03/22 09:10:48 - Write to log.0 - Step info: nrinput=1 nroutput=0
2012/03/22 09:10:48 - Write to log.0 - Got previous step from [Write to log] #0 --> Get Variables
2012/03/22 09:10:48 - Write to log.0 - input rel is 1:1
2012/03/22 09:10:48 - Write to log.0 - Found input rowset [Get Variables.0 - Write to log.0]
2012/03/22 09:10:48 - Write to log.0 - Finished dispatching
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation has allocated a new step: [Write to log].0
2012/03/22 09:10:48 - use_ShowOutPutVariables - This transformation can be replayed with replay date: 2012/03/22 09:10:48
2012/03/22 09:10:48 - use_ShowOutPutVariables - Initialising 2 steps...
2012/03/22 09:10:48 - Get Variables.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - Write to log.0 - Running on slave server #0/1.
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step [Get Variables.0] initialized flawlessly.
2012/03/22 09:10:48 - use_ShowOutPutVariables - Step [Write to log.0] initialized flawlessly.
2012/03/22 09:10:48 - Get Variables.0 - Starting to run...
2012/03/22 09:10:48 - Get Variables.0 - field [Testdel] has value [${Delimeter}]
2012/03/22 09:10:48 - Get Variables.0 - field [TESTFile] has value [${OutFileName}]
2012/03/22 09:10:48 - use_ShowOutPutVariables - Transformation has allocated 2 threads and 1 rowsets.
2012/03/22 09:10:48 - Get Variables.0 - Signaling 'output done' to 1 output rowsets.
2012/03/22 09:10:48 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Write to log.0 - Starting to run...
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ------------> Linenr 1------------------------------
2012/03/22 09:10:48 - Write to log.0 - Testdel = ${Delimeter}
2012/03/22 09:10:48 - Write to log.0 - TESTFile = ${OutFileName}
2012/03/22 09:10:48 - Write to log.0 -
2012/03/22 09:10:48 - Write to log.0 - ====================
2012/03/22 09:10:48 - Write to log.0 - Signaling 'output done' to 0 output rowsets.
2012/03/22 09:10:48 - Write to log.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Finished job entry [use_ShowOutPutVariables] (result=[true])
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Finished job entry [use_setOutPutVariables] (result=[true])
2012/03/22 09:10:48 - Short_Test_Run_Using_Variables - Job execution finished
2012/03/22 09:10:48 - Spoon - Job has ended.