2020/11/20 10:31:24 - Kitchen - Logging is at level : Detailed logging
2020/11/20 10:31:24 - Kitchen - Start of run.
2020/11/20 10:31:24 - CargaArchivos - Start of job execution
2020/11/20 10:31:24 - CargaArchivos - exec(0, 0, START.0)
2020/11/20 10:31:24 - START - Starting job entry
2020/11/20 10:31:24 - CargaArchivos - Starting entry [Es GPL?]
2020/11/20 10:31:24 - CargaArchivos - exec(1, 0, Es GPL?.0)
2020/11/20 10:31:24 - Es GPL? - Starting job entry
2020/11/20 10:31:24 - Es GPL? - Value to evaluate is GPL
2020/11/20 10:31:24 - CargaArchivos - Starting entry [Drop Index y Vacia Tablas]
2020/11/20 10:31:24 - CargaArchivos - exec(2, 0, Drop Index y Vacia Tablas.0)
2020/11/20 10:31:24 - Es GPL? - Starting job entry
2020/11/20 10:31:24 - localPostgre - New database connection defined
2020/11/20 10:31:24 - localPostgre - Connected to database.
2020/11/20 10:31:24 - Es GPL? - Running SQL :DROP INDEX IF EXISTS partnumbergpl_idx;
2020/11/20 10:31:24 - Es GPL? - TRUNCATE TABLE global_price_list_tmp;
2020/11/20 10:31:24 - Es GPL? - update tipo_dato set validado = false, ingresado = true,
2020/11/20 10:31:24 - Es GPL? - observacion = 'A la espera de valicación de datos' where nombre = 'GPL';
2020/11/20 10:31:24 - localPostgre - launch DDL statement: 
2020/11/20 10:31:24 - localPostgre - DROP INDEX IF EXISTS partnumbergpl_idx
2020/11/20 10:31:24 - localPostgre - launch DDL statement: 
2020/11/20 10:31:24 - localPostgre - TRUNCATE TABLE global_price_list_tmp
2020/11/20 10:31:24 - localPostgre - launch DDL statement: 
2020/11/20 10:31:24 - localPostgre - update tipo_dato set validado = false, ingresado = true,
2020/11/20 10:31:24 - localPostgre - observacion = 'A la espera de valicación de datos' where nombre = 'GPL'
2020/11/20 10:31:24 - localPostgre - 3 statements executed
2020/11/20 10:31:24 - localPostgre - Connection to database closed!
2020/11/20 10:31:24 - CargaArchivos - Starting entry [CargaGPL]
2020/11/20 10:31:24 - CargaArchivos - exec(3, 0, CargaGPL.0)
2020/11/20 10:31:24 - CargaGPL - Starting job entry
2020/11/20 10:31:24 - CargaGPL - Opening transformation: [file:///home/admin_tecno/transformaciones/LecturaGPL.ktr]
2020/11/20 10:31:24 - CargaGPL - Loading transformation from XML file [file:///home/admin_tecno/transformaciones/LecturaGPL.ktr]
2020/11/20 10:31:25 - CargaGPL - Starting transformation...(file=${Internal.Job.Filename.Directory}/LecturaGPL.ktr, name=CargaGPL, repinfo=null)
2020/11/20 10:31:25 - LecturaGPL - Transformation is pre-loaded.
2020/11/20 10:31:25 - LecturaGPL - Dispatching started for transformation [LecturaGPL]
2020/11/20 10:31:25 - LecturaGPL - Nr of arguments detected:0 
2020/11/20 10:31:25 - LecturaGPL - This is not a replay transformation
2020/11/20 10:31:25 - LecturaGPL - I found 8 different steps to launch.
2020/11/20 10:31:25 - LecturaGPL - Allocating rowsets...
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 0 --> Text file input
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Text file input.0 - Modified Java Script Value.0]
2020/11/20 10:31:25 - LecturaGPL -  Allocated 1 rowsets for step 0 --> Text file input  
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 1 --> Modified Java Script Value
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Modified Java Script Value.0 - Filter rows 2.0]
2020/11/20 10:31:25 - LecturaGPL -  Allocated 2 rowsets for step 1 --> Modified Java Script Value  
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 2 --> Filter rows
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Filter rows.0 - Table output.0]
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Filter rows.0 - Dummy (do nothing).0]
2020/11/20 10:31:25 - LecturaGPL -  Allocated 4 rowsets for step 2 --> Filter rows  
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 3 --> Table output
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Table output.0 - Dummy (do nothing) 2.0]
2020/11/20 10:31:25 - LecturaGPL -  Allocated 5 rowsets for step 3 --> Table output  
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 4 --> Dummy (do nothing)
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Dummy (do nothing).0 - Dummy (do nothing) 2.0]
2020/11/20 10:31:25 - LecturaGPL -  Allocated 6 rowsets for step 4 --> Dummy (do nothing)  
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 5 --> Dummy (do nothing) 2
2020/11/20 10:31:25 - LecturaGPL -  Allocated 6 rowsets for step 5 --> Dummy (do nothing) 2  
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 6 --> Filter rows 2
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Filter rows 2.0 - Filter rows.0]
2020/11/20 10:31:25 - LecturaGPL -   prevcopies = 1, nextcopies=1
2020/11/20 10:31:25 - LecturaGPL - Transformation allocated new rowset [Filter rows 2.0 - Abort.0]
2020/11/20 10:31:25 - LecturaGPL -  Allocated 8 rowsets for step 6 --> Filter rows 2  
2020/11/20 10:31:25 - LecturaGPL -  Allocating rowsets for step 7 --> Abort
2020/11/20 10:31:25 - LecturaGPL -  Allocated 8 rowsets for step 7 --> Abort  
2020/11/20 10:31:25 - LecturaGPL - Allocating Steps & StepData...
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Text file input] of type [TextFileInput]
2020/11/20 10:31:25 - Text file input.0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Text file input.0 - Step info: nrinput=0 nroutput=1
2020/11/20 10:31:25 - Text file input.0 - output rel. is  1:1
2020/11/20 10:31:25 - Text file input.0 - Found output rowset [Text file input.0 - Modified Java Script Value.0]
2020/11/20 10:31:25 - Text file input.0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Text file input].0
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Modified Java Script Value] of type [ScriptValueMod]
2020/11/20 10:31:25 - Modified Java Script Value.0 - distribution activated
2020/11/20 10:31:25 - Modified Java Script Value.0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Modified Java Script Value.0 - Step info: nrinput=1 nroutput=1
2020/11/20 10:31:25 - Modified Java Script Value.0 - Got previous step from [Modified Java Script Value] #0 --> Text file input
2020/11/20 10:31:25 - Modified Java Script Value.0 - input rel is 1:1
2020/11/20 10:31:25 - Modified Java Script Value.0 - Found input rowset [Text file input.0 - Modified Java Script Value.0]
2020/11/20 10:31:25 - Modified Java Script Value.0 - output rel. is  1:1
2020/11/20 10:31:25 - Modified Java Script Value.0 - Found output rowset [Modified Java Script Value.0 - Filter rows 2.0]
2020/11/20 10:31:25 - Modified Java Script Value.0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Modified Java Script Value].0
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Filter rows] of type [FilterRows]
2020/11/20 10:31:25 - Filter rows.0 - distribution activated
2020/11/20 10:31:25 - Filter rows.0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Filter rows.0 - Step info: nrinput=1 nroutput=2
2020/11/20 10:31:25 - Filter rows.0 - Got previous step from [Filter rows] #0 --> Filter rows 2
2020/11/20 10:31:25 - Filter rows.0 - input rel is 1:1
2020/11/20 10:31:25 - Filter rows.0 - Found input rowset [Filter rows 2.0 - Filter rows.0]
2020/11/20 10:31:25 - Filter rows.0 - output rel. is  1:1
2020/11/20 10:31:25 - Filter rows.0 - Found output rowset [Filter rows.0 - Table output.0]
2020/11/20 10:31:25 - Filter rows.0 - output rel. is  1:1
2020/11/20 10:31:25 - Filter rows.0 - Found output rowset [Filter rows.0 - Dummy (do nothing).0]
2020/11/20 10:31:25 - Filter rows.0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Filter rows].0
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Table output] of type [TableOutput]
2020/11/20 10:31:25 - Table output.0 - distribution activated
2020/11/20 10:31:25 - Table output.0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Table output.0 - Step info: nrinput=1 nroutput=1
2020/11/20 10:31:25 - Table output.0 - Got previous step from [Table output] #0 --> Filter rows
2020/11/20 10:31:25 - Table output.0 - input rel is 1:1
2020/11/20 10:31:25 - Table output.0 - Found input rowset [Filter rows.0 - Table output.0]
2020/11/20 10:31:25 - Table output.0 - output rel. is  1:1
2020/11/20 10:31:25 - Table output.0 - Found output rowset [Table output.0 - Dummy (do nothing) 2.0]
2020/11/20 10:31:25 - Table output.0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Table output].0
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Dummy (do nothing)] of type [Dummy]
2020/11/20 10:31:25 - Dummy (do nothing).0 - distribution activated
2020/11/20 10:31:25 - Dummy (do nothing).0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Dummy (do nothing).0 - Step info: nrinput=1 nroutput=1
2020/11/20 10:31:25 - Dummy (do nothing).0 - Got previous step from [Dummy (do nothing)] #0 --> Filter rows
2020/11/20 10:31:25 - Dummy (do nothing).0 - input rel is 1:1
2020/11/20 10:31:25 - Dummy (do nothing).0 - Found input rowset [Filter rows.0 - Dummy (do nothing).0]
2020/11/20 10:31:25 - Dummy (do nothing).0 - output rel. is  1:1
2020/11/20 10:31:25 - Dummy (do nothing).0 - Found output rowset [Dummy (do nothing).0 - Dummy (do nothing) 2.0]
2020/11/20 10:31:25 - Dummy (do nothing).0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Dummy (do nothing)].0
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Dummy (do nothing) 2] of type [Dummy]
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - distribution activated
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Step info: nrinput=2 nroutput=0
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Got previous step from [Dummy (do nothing) 2] #0 --> Table output
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - input rel is 1:1
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Found input rowset [Table output.0 - Dummy (do nothing) 2.0]
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Got previous step from [Dummy (do nothing) 2] #1 --> Dummy (do nothing)
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - input rel is 1:1
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Found input rowset [Dummy (do nothing).0 - Dummy (do nothing) 2.0]
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Dummy (do nothing) 2].0
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Filter rows 2] of type [FilterRows]
2020/11/20 10:31:25 - Filter rows 2.0 - distribution activated
2020/11/20 10:31:25 - Filter rows 2.0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Filter rows 2.0 - Step info: nrinput=1 nroutput=2
2020/11/20 10:31:25 - Filter rows 2.0 - Got previous step from [Filter rows 2] #0 --> Modified Java Script Value
2020/11/20 10:31:25 - Filter rows 2.0 - input rel is 1:1
2020/11/20 10:31:25 - Filter rows 2.0 - Found input rowset [Modified Java Script Value.0 - Filter rows 2.0]
2020/11/20 10:31:25 - Filter rows 2.0 - output rel. is  1:1
2020/11/20 10:31:25 - Filter rows 2.0 - Found output rowset [Filter rows 2.0 - Filter rows.0]
2020/11/20 10:31:25 - Filter rows 2.0 - output rel. is  1:1
2020/11/20 10:31:25 - Filter rows 2.0 - Found output rowset [Filter rows 2.0 - Abort.0]
2020/11/20 10:31:25 - Filter rows 2.0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Filter rows 2].0
2020/11/20 10:31:25 - LecturaGPL -  Transformation is about to allocate step [Abort] of type [Abort]
2020/11/20 10:31:25 - Abort.0 - distribution activated
2020/11/20 10:31:25 - Abort.0 - Starting allocation of buffers & new threads...
2020/11/20 10:31:25 - Abort.0 - Step info: nrinput=1 nroutput=0
2020/11/20 10:31:25 - Abort.0 - Got previous step from [Abort] #0 --> Filter rows 2
2020/11/20 10:31:25 - Abort.0 - input rel is 1:1
2020/11/20 10:31:25 - Abort.0 - Found input rowset [Filter rows 2.0 - Abort.0]
2020/11/20 10:31:25 - Abort.0 - Finished dispatching
2020/11/20 10:31:25 - LecturaGPL -  Transformation has allocated a new step: [Abort].0
2020/11/20 10:31:25 - LecturaGPL - This transformation can be replayed with replay date: 2020/11/20 10:31:25
2020/11/20 10:31:25 - LecturaGPL - Initialising 8 steps...
2020/11/20 10:31:25 - Text file input.0 - Running on slave server #0/1.
2020/11/20 10:31:25 - Modified Java Script Value.0 - Running on slave server #0/1.
2020/11/20 10:31:25 - Table output.0 - Running on slave server #0/1.
2020/11/20 10:31:25 - Dummy (do nothing).0 - Running on slave server #0/1.
2020/11/20 10:31:25 - Filter rows.0 - Running on slave server #0/1.
2020/11/20 10:31:25 - Filter rows 2.0 - Running on slave server #0/1.
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Running on slave server #0/1.
2020/11/20 10:31:25 - localPostGres - New database connection defined
2020/11/20 10:31:25 - Abort.0 - Running on slave server #0/1.
2020/11/20 10:31:25 - localPostGres - Connected to database.
2020/11/20 10:31:25 - Table output.0 - Connected to database [localPostGres] (commit=1000)
2020/11/20 10:31:25 - localPostGres - Auto commit off
2020/11/20 10:31:25 - LecturaGPL - Step [Text file input.0] initialized flawlessly.
2020/11/20 10:31:25 - LecturaGPL - Step [Modified Java Script Value.0] initialized flawlessly.
2020/11/20 10:31:25 - LecturaGPL - Step [Filter rows.0] initialized flawlessly.
2020/11/20 10:31:25 - LecturaGPL - Step [Table output.0] initialized flawlessly.
2020/11/20 10:31:25 - LecturaGPL - Step [Dummy (do nothing).0] initialized flawlessly.
2020/11/20 10:31:25 - LecturaGPL - Step [Dummy (do nothing) 2.0] initialized flawlessly.
2020/11/20 10:31:25 - LecturaGPL - Step [Filter rows 2.0] initialized flawlessly.
2020/11/20 10:31:25 - LecturaGPL - Step [Abort.0] initialized flawlessly.
2020/11/20 10:31:25 - Text file input.0 - Starting to run...
2020/11/20 10:31:25 - Modified Java Script Value.0 - Starting to run...
2020/11/20 10:31:25 - Filter rows.0 - Starting to run...
2020/11/20 10:31:25 - Table output.0 - Starting to run...
2020/11/20 10:31:25 - Dummy (do nothing).0 - Starting to run...
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Starting to run...
2020/11/20 10:31:25 - Filter rows 2.0 - Starting to run...
2020/11/20 10:31:25 - Text file input.0 - Opening file: file:///var/www/informes/datos/gpl/cotizadorQ2FY21V2.xls
2020/11/20 10:31:25 - LecturaGPL - Transformation has allocated 8 threads and 8 rowsets.
2020/11/20 10:31:25 - Abort.0 - Starting to run...
2020/11/20 10:31:25 - Modified Java Script Value.0 - Value #0 -  [Field1] is used in the script.
2020/11/20 10:31:25 - Modified Java Script Value.0 - Value #4 -  [Field5] is used in the script.
2020/11/20 10:31:25 - Modified Java Script Value.0 - Value #6 -  [Field7] is used in the script.
2020/11/20 10:31:25 - Modified Java Script Value.0 - This script is using 3 values from the input stream(s)
2020/11/20 10:31:25 - Text file input.0 - Finished processing (I=1696, O=0, R=0, W=1696, U=1, E=0)
2020/11/20 10:31:25 - Modified Java Script Value.0 - Optimization level set to 9.
2020/11/20 10:31:25 - Modified Java Script Value.0 - No starting Script found!
2020/11/20 10:31:25 - Modified Java Script Value.0 - No tran_Status found. Transformation status checking not available.
2020/11/20 10:31:25 - Abort.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Row nr 1 causing abort : [������>��	-
��������*
+
,
����������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������	T8������\pLydia  Troncoso Garrido                                                                                      B�a
�
=

��
�
=Kh8
X@�"
�
�1��

Calibri1��

Calibri1��

Calibri1��

Calibri1��

Calibri1*h
6�

Calibri Light1,

6�
Calibri1

6�
Calibri1�
6�
Calibri1��

Calibri1��

Calibri1�<�

Calibri1�>�

Calibri1�
?�
Calibri1�
4�
Calibri1�4�

Calibri1�
	�
Calibri1�], [null], [null], [null], [null], [null], [null], [null], [null], [null], [null], [null], [null], [null], [], [0], [0], [1], [_]
2020/11/20 10:31:25 - Abort.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Aborting after having seen 1 rows.
2020/11/20 10:31:25 - Abort.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=1)
2020/11/20 10:31:25 - Filter rows.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2020/11/20 10:31:25 - LecturaGPL - LecturaGPL
2020/11/20 10:31:25 - LecturaGPL - LecturaGPL
2020/11/20 10:31:25 - Filter rows 2.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
2020/11/20 10:31:25 - Modified Java Script Value.0 - Finished processing (I=0, O=0, R=12, W=11, U=0, E=0)
2020/11/20 10:31:25 - Dummy (do nothing) 2.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2020/11/20 10:31:25 - LecturaGPL - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
2020/11/20 10:31:25 - LecturaGPL - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
2020/11/20 10:31:25 - Dummy (do nothing).0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2020/11/20 10:31:25 - localPostGres - Connection to database closed!
2020/11/20 10:31:25 - Table output.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2020/11/20 10:31:25 - CargaArchivos - Starting entry [Formato incorrecto archivo GPL]
2020/11/20 10:31:25 - CargaArchivos - exec(4, 0, Formato incorrecto archivo GPL.0)
2020/11/20 10:31:25 - Es GPL? - Starting job entry
2020/11/20 10:31:25 - localPostgre - New database connection defined
2020/11/20 10:31:25 - localPostgre - Connected to database.
2020/11/20 10:31:25 - Es GPL? - Running SQL :update tipo_dato set validado = false, ingresado = false,
2020/11/20 10:31:25 - Es GPL? - observacion = 'No se ha podido cargar el archivo debido a que el formato es incorrecto' where lower(nombre) = 'gpl';
2020/11/20 10:31:25 - localPostgre - launch DDL statement: 
2020/11/20 10:31:25 - localPostgre - update tipo_dato set validado = false, ingresado = false,
2020/11/20 10:31:25 - localPostgre - observacion = 'No se ha podido cargar el archivo debido a que el formato es incorrecto' where lower(nombre) = 'gpl'
2020/11/20 10:31:25 - localPostgre - 1 statement executed
2020/11/20 10:31:25 - localPostgre - Connection to database closed!
2020/11/20 10:31:25 - CargaArchivos - Finished job entry [Formato incorrecto archivo GPL] (result=[true])
2020/11/20 10:31:25 - CargaArchivos - Finished job entry [CargaGPL] (result=[true])
2020/11/20 10:31:25 - CargaArchivos - Finished job entry [Drop Index y Vacia Tablas] (result=[true])
2020/11/20 10:31:25 - CargaArchivos - Finished job entry [Es GPL?] (result=[true])
2020/11/20 10:31:25 - CargaArchivos - Job execution finished