2017/02/15 12:03:11 - Kitchen - Logging is at level : Detailed logging
2017/02/15 12:03:11 - Kitchen - Start of run.
2017/02/15 12:03:11 - CargaArchivos - Start of job execution
2017/02/15 12:03:11 - CargaArchivos - exec(0, 0, START.0)
2017/02/15 12:03:11 - START - Starting job entry
2017/02/15 12:03:11 - CargaArchivos - Starting entry [Es GPL?]
2017/02/15 12:03:11 - CargaArchivos - exec(1, 0, Es GPL?.0)
2017/02/15 12:03:11 - Es GPL? - Starting job entry
2017/02/15 12:03:11 - Es GPL? - Value to evaluate is Fasttrack
2017/02/15 12:03:11 - CargaArchivos - Starting entry [Es WPL?]
2017/02/15 12:03:11 - CargaArchivos - exec(2, 0, Es WPL?.0)
2017/02/15 12:03:11 - Es GPL? - Starting job entry
2017/02/15 12:03:11 - Es GPL? - Value to evaluate is Fasttrack
2017/02/15 12:03:11 - CargaArchivos - Starting entry [Es Producto Servicio?]
2017/02/15 12:03:11 - CargaArchivos - exec(3, 0, Es Producto Servicio?.0)
2017/02/15 12:03:11 - Es GPL? - Starting job entry
2017/02/15 12:03:11 - Es GPL? - Value to evaluate is Fasttrack
2017/02/15 12:03:11 - CargaArchivos - Starting entry [Es Fasttrack?]
2017/02/15 12:03:11 - CargaArchivos - exec(4, 0, Es Fasttrack?.0)
2017/02/15 12:03:11 - Es GPL? - Starting job entry
2017/02/15 12:03:11 - Es GPL? - Value to evaluate is Fasttrack
2017/02/15 12:03:11 - CargaArchivos - Starting entry [Carga Fasttrack TMP]
2017/02/15 12:03:11 - CargaArchivos - exec(5, 0, Carga Fasttrack TMP.0)
2017/02/15 12:03:11 - Carga Fasttrack TMP - Starting job entry
2017/02/15 12:03:11 - Carga Fasttrack TMP - Opening transformation: [file:///home/admin_tecno/transformaciones/cargaFasttrackv3.ktr]
2017/02/15 12:03:11 - Carga Fasttrack TMP - Loading transformation from XML file [file:///home/admin_tecno/transformaciones/cargaFasttrackv3.ktr]
2017/02/15 12:03:11 - Carga Fasttrack TMP - Starting transformation...(file=${Internal.Job.Filename.Directory}/cargaFasttrackv3.ktr, name=Carga Fasttrack TMP, repinfo=null)
2017/02/15 12:03:11 - cargaFasttrackv3 - Transformation is pre-loaded.
2017/02/15 12:03:11 - cargaFasttrackv3 - Dispatching started for transformation [cargaFasttrackv3]
2017/02/15 12:03:11 - cargaFasttrackv3 - Nr of arguments detected:4 
2017/02/15 12:03:11 - cargaFasttrackv3 - This is not a replay transformation
2017/02/15 12:03:11 - cargaFasttrackv3 - I found 2 different steps to launch.
2017/02/15 12:03:11 - cargaFasttrackv3 - Allocating rowsets...
2017/02/15 12:03:11 - cargaFasttrackv3 -  Allocating rowsets for step 0 --> Microsoft Excel Input
2017/02/15 12:03:11 - cargaFasttrackv3 -   prevcopies = 1, nextcopies=1
2017/02/15 12:03:11 - cargaFasttrackv3 - Transformation allocated new rowset [Microsoft Excel Input.0 - Table output.0]
2017/02/15 12:03:11 - cargaFasttrackv3 -  Allocated 1 rowsets for step 0 --> Microsoft Excel Input  
2017/02/15 12:03:11 - cargaFasttrackv3 -  Allocating rowsets for step 1 --> Table output
2017/02/15 12:03:11 - cargaFasttrackv3 -  Allocated 1 rowsets for step 1 --> Table output  
2017/02/15 12:03:11 - cargaFasttrackv3 - Allocating Steps & StepData...
2017/02/15 12:03:11 - cargaFasttrackv3 -  Transformation is about to allocate step [Microsoft Excel Input] of type [ExcelInput]
2017/02/15 12:03:11 - Microsoft Excel Input.0 - Starting allocation of buffers & new threads...
2017/02/15 12:03:11 - Microsoft Excel Input.0 - Step info: nrinput=0 nroutput=1
2017/02/15 12:03:11 - Microsoft Excel Input.0 - output rel. is  1:1
2017/02/15 12:03:11 - Microsoft Excel Input.0 - Found output rowset [Microsoft Excel Input.0 - Table output.0]
2017/02/15 12:03:11 - Microsoft Excel Input.0 - Finished dispatching
2017/02/15 12:03:11 - cargaFasttrackv3 -  Transformation has allocated a new step: [Microsoft Excel Input].0
2017/02/15 12:03:11 - cargaFasttrackv3 -  Transformation is about to allocate step [Table output] of type [TableOutput]
2017/02/15 12:03:11 - Table output.0 - distribution activated
2017/02/15 12:03:11 - Table output.0 - Starting allocation of buffers & new threads...
2017/02/15 12:03:11 - Table output.0 - Step info: nrinput=1 nroutput=0
2017/02/15 12:03:11 - Table output.0 - Got previous step from [Table output] #0 --> Microsoft Excel Input
2017/02/15 12:03:11 - Table output.0 - input rel is 1:1
2017/02/15 12:03:11 - Table output.0 - Found input rowset [Microsoft Excel Input.0 - Table output.0]
2017/02/15 12:03:11 - Table output.0 - Finished dispatching
2017/02/15 12:03:11 - cargaFasttrackv3 -  Transformation has allocated a new step: [Table output].0
2017/02/15 12:03:11 - cargaFasttrackv3 - This transformation can be replayed with replay date: 2017/02/15 12:03:11
2017/02/15 12:03:11 - cargaFasttrackv3 - Initialising 2 steps...
2017/02/15 12:03:11 - Microsoft Excel Input.0 - Running on slave server #0/1.
2017/02/15 12:03:11 - Table output.0 - Running on slave server #0/1.
2017/02/15 12:03:12 - localPostgre - New database connection defined
2017/02/15 12:03:12 - localPostgre - Connected to database.
2017/02/15 12:03:12 - Table output.0 - Connected to database [localPostgre] (commit=1000)
2017/02/15 12:03:12 - localPostgre - Auto commit off
2017/02/15 12:03:12 - cargaFasttrackv3 - Step [Microsoft Excel Input.0] initialized flawlessly.
2017/02/15 12:03:12 - cargaFasttrackv3 - Step [Table output.0] initialized flawlessly.
2017/02/15 12:03:12 - Microsoft Excel Input.0 - Starting to run...
2017/02/15 12:03:12 - Table output.0 - Starting to run...
2017/02/15 12:03:12 - Microsoft Excel Input.0 - No more files to be processed! (0 files done)
2017/02/15 12:03:12 - cargaFasttrackv3 - Transformation has allocated 2 threads and 1 rowsets.
2017/02/15 12:03:12 - Microsoft Excel Input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2017/02/15 12:03:12 - localPostgre - Connection to database closed!
2017/02/15 12:03:12 - Table output.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2017/02/15 12:03:12 - CargaArchivos - Starting entry [Existen datos ?]
2017/02/15 12:03:12 - CargaArchivos - exec(6, 0, Existen datos ?.0)
2017/02/15 12:03:12 - Es GPL? - Starting job entry
2017/02/15 12:03:12 - Es GPL? - Rows limit set to [1]
2017/02/15 12:03:12 - localPostgre - New database connection defined
2017/02/15 12:03:12 - localPostgre - Connected to database.
2017/02/15 12:03:12 - Es GPL? - We will run the following SQL statement : SELECT 1 as valor
2017/02/15 12:03:12 - Es GPL? - UNION
2017/02/15 12:03:12 - Es GPL? - select
2017/02/15 12:03:12 - Es GPL? - 2 as valor
2017/02/15 12:03:12 - Es GPL? - FROM fastrack_tmp
2017/02/15 12:03:12 - Es GPL? - We returned 1 row(s)
2017/02/15 12:03:12 - localPostgre - Connection to database closed!
2017/02/15 12:03:12 - CargaArchivos - Starting entry [No existen datos a cargar]
2017/02/15 12:03:12 - CargaArchivos - exec(7, 0, No existen datos a cargar.0)
2017/02/15 12:03:12 - Es GPL? - Starting job entry
2017/02/15 12:03:12 - localPostgre - New database connection defined
2017/02/15 12:03:12 - localPostgre - Connected to database.
2017/02/15 12:03:12 - Es GPL? - Running SQL :update tipo_dato set validado = false, ingresado = false,
2017/02/15 12:03:12 - Es GPL? - observacion = 'No existen datos a cargar, favor revise los datos' where lower(nombre) = 'fasttrack';
2017/02/15 12:03:12 - localPostgre - launch DDL statement: 
2017/02/15 12:03:12 - localPostgre - update tipo_dato set validado = false, ingresado = false,
2017/02/15 12:03:12 - localPostgre - observacion = 'No existen datos a cargar, favor revise los datos' where lower(nombre) = 'fasttrack'
2017/02/15 12:03:12 - localPostgre - 1 statement executed
2017/02/15 12:03:12 - localPostgre - Connection to database closed!
2017/02/15 12:03:12 - CargaArchivos - Finished job entry [No existen datos a cargar] (result=[true])
2017/02/15 12:03:12 - CargaArchivos - Finished job entry [Existen datos ?] (result=[true])
2017/02/15 12:03:12 - CargaArchivos - Finished job entry [Carga Fasttrack TMP] (result=[true])
2017/02/15 12:03:12 - CargaArchivos - Finished job entry [Es Fasttrack?] (result=[true])
2017/02/15 12:03:12 - CargaArchivos - Finished job entry [Es Producto Servicio?] (result=[true])
2017/02/15 12:03:12 - CargaArchivos - Finished job entry [Es WPL?] (result=[true])
2017/02/15 12:03:12 - CargaArchivos - Finished job entry [Es GPL?] (result=[true])
2017/02/15 12:03:12 - CargaArchivos - Job execution finished