2016/11/07 10:24:07 - Kitchen - Logging is at level : Detailed logging
2016/11/07 10:24:07 - Kitchen - Start of run.
2016/11/07 10:24:07 - CargaArchivos - Start of job execution
2016/11/07 10:24:07 - CargaArchivos - exec(0, 0, START.0)
2016/11/07 10:24:07 - START - Starting job entry
2016/11/07 10:24:07 - CargaArchivos - Starting entry [Es GPL?]
2016/11/07 10:24:07 - CargaArchivos - exec(1, 0, Es GPL?.0)
2016/11/07 10:24:07 - Es GPL? - Starting job entry
2016/11/07 10:24:07 - Es GPL? - Value to evaluate is GPL
2016/11/07 10:24:07 - CargaArchivos - Starting entry [Drop Index y Vacia Tablas]
2016/11/07 10:24:07 - CargaArchivos - exec(2, 0, Drop Index y Vacia Tablas.0)
2016/11/07 10:24:07 - Es GPL? - Starting job entry
2016/11/07 10:24:07 - localPostgre - New database connection defined
2016/11/07 10:24:07 - localPostgre - Connected to database.
2016/11/07 10:24:07 - Es GPL? - Running SQL :DROP INDEX IF EXISTS partnumbergpl_idx;
2016/11/07 10:24:07 - Es GPL? - TRUNCATE TABLE global_price_list_tmp;
2016/11/07 10:24:07 - Es GPL? - update tipo_dato set validado = false, ingresado = true,
2016/11/07 10:24:07 - Es GPL? - observacion = 'A la espera de valicación de datos' where nombre = 'GPL';
2016/11/07 10:24:07 - localPostgre - launch DDL statement: 
2016/11/07 10:24:07 - localPostgre - DROP INDEX IF EXISTS partnumbergpl_idx
2016/11/07 10:24:07 - localPostgre - launch DDL statement: 
2016/11/07 10:24:07 - localPostgre - TRUNCATE TABLE global_price_list_tmp
2016/11/07 10:24:07 - localPostgre - launch DDL statement: 
2016/11/07 10:24:07 - localPostgre - update tipo_dato set validado = false, ingresado = true,
2016/11/07 10:24:07 - localPostgre - observacion = 'A la espera de valicación de datos' where nombre = 'GPL'
2016/11/07 10:24:07 - localPostgre - 3 statements executed
2016/11/07 10:24:07 - localPostgre - Connection to database closed!
2016/11/07 10:24:07 - CargaArchivos - Starting entry [CargaGPL]
2016/11/07 10:24:07 - CargaArchivos - exec(3, 0, CargaGPL.0)
2016/11/07 10:24:07 - CargaGPL - Starting job entry
2016/11/07 10:24:07 - CargaGPL - Opening transformation: [file:///home/admin_tecno/transformaciones/LecturaGPL.ktr]
2016/11/07 10:24:07 - CargaGPL - Loading transformation from XML file [file:///home/admin_tecno/transformaciones/LecturaGPL.ktr]
2016/11/07 10:24:07 - CargaGPL - Starting transformation...(file=${Internal.Job.Filename.Directory}/LecturaGPL.ktr, name=CargaGPL, repinfo=null)
2016/11/07 10:24:07 - LecturaGPL - Transformation is pre-loaded.
2016/11/07 10:24:07 - LecturaGPL - Dispatching started for transformation [LecturaGPL]
2016/11/07 10:24:07 - LecturaGPL - Nr of arguments detected:0 
2016/11/07 10:24:07 - LecturaGPL - This is not a replay transformation
2016/11/07 10:24:07 - LecturaGPL - I found 8 different steps to launch.
2016/11/07 10:24:07 - LecturaGPL - Allocating rowsets...
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 0 --> Text file input
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Text file input.0 - Modified Java Script Value.0]
2016/11/07 10:24:07 - LecturaGPL -  Allocated 1 rowsets for step 0 --> Text file input  
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 1 --> Modified Java Script Value
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Modified Java Script Value.0 - Filter rows 2.0]
2016/11/07 10:24:07 - LecturaGPL -  Allocated 2 rowsets for step 1 --> Modified Java Script Value  
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 2 --> Filter rows
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Filter rows.0 - Table output.0]
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Filter rows.0 - Dummy (do nothing).0]
2016/11/07 10:24:07 - LecturaGPL -  Allocated 4 rowsets for step 2 --> Filter rows  
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 3 --> Table output
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Table output.0 - Dummy (do nothing) 2.0]
2016/11/07 10:24:07 - LecturaGPL -  Allocated 5 rowsets for step 3 --> Table output  
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 4 --> Dummy (do nothing)
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Dummy (do nothing).0 - Dummy (do nothing) 2.0]
2016/11/07 10:24:07 - LecturaGPL -  Allocated 6 rowsets for step 4 --> Dummy (do nothing)  
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 5 --> Dummy (do nothing) 2
2016/11/07 10:24:07 - LecturaGPL -  Allocated 6 rowsets for step 5 --> Dummy (do nothing) 2  
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 6 --> Filter rows 2
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Filter rows 2.0 - Filter rows.0]
2016/11/07 10:24:07 - LecturaGPL -   prevcopies = 1, nextcopies=1
2016/11/07 10:24:07 - LecturaGPL - Transformation allocated new rowset [Filter rows 2.0 - Abort.0]
2016/11/07 10:24:07 - LecturaGPL -  Allocated 8 rowsets for step 6 --> Filter rows 2  
2016/11/07 10:24:07 - LecturaGPL -  Allocating rowsets for step 7 --> Abort
2016/11/07 10:24:07 - LecturaGPL -  Allocated 8 rowsets for step 7 --> Abort  
2016/11/07 10:24:07 - LecturaGPL - Allocating Steps & StepData...
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Text file input] of type [TextFileInput]
2016/11/07 10:24:07 - Text file input.0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Text file input.0 - Step info: nrinput=0 nroutput=1
2016/11/07 10:24:07 - Text file input.0 - output rel. is  1:1
2016/11/07 10:24:07 - Text file input.0 - Found output rowset [Text file input.0 - Modified Java Script Value.0]
2016/11/07 10:24:07 - Text file input.0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Text file input].0
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Modified Java Script Value] of type [ScriptValueMod]
2016/11/07 10:24:07 - Modified Java Script Value.0 - distribution activated
2016/11/07 10:24:07 - Modified Java Script Value.0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Modified Java Script Value.0 - Step info: nrinput=1 nroutput=1
2016/11/07 10:24:07 - Modified Java Script Value.0 - Got previous step from [Modified Java Script Value] #0 --> Text file input
2016/11/07 10:24:07 - Modified Java Script Value.0 - input rel is 1:1
2016/11/07 10:24:07 - Modified Java Script Value.0 - Found input rowset [Text file input.0 - Modified Java Script Value.0]
2016/11/07 10:24:07 - Modified Java Script Value.0 - output rel. is  1:1
2016/11/07 10:24:07 - Modified Java Script Value.0 - Found output rowset [Modified Java Script Value.0 - Filter rows 2.0]
2016/11/07 10:24:07 - Modified Java Script Value.0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Modified Java Script Value].0
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Filter rows] of type [FilterRows]
2016/11/07 10:24:07 - Filter rows.0 - distribution activated
2016/11/07 10:24:07 - Filter rows.0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Filter rows.0 - Step info: nrinput=1 nroutput=2
2016/11/07 10:24:07 - Filter rows.0 - Got previous step from [Filter rows] #0 --> Filter rows 2
2016/11/07 10:24:07 - Filter rows.0 - input rel is 1:1
2016/11/07 10:24:07 - Filter rows.0 - Found input rowset [Filter rows 2.0 - Filter rows.0]
2016/11/07 10:24:07 - Filter rows.0 - output rel. is  1:1
2016/11/07 10:24:07 - Filter rows.0 - Found output rowset [Filter rows.0 - Table output.0]
2016/11/07 10:24:07 - Filter rows.0 - output rel. is  1:1
2016/11/07 10:24:07 - Filter rows.0 - Found output rowset [Filter rows.0 - Dummy (do nothing).0]
2016/11/07 10:24:07 - Filter rows.0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Filter rows].0
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Table output] of type [TableOutput]
2016/11/07 10:24:07 - Table output.0 - distribution activated
2016/11/07 10:24:07 - Table output.0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Table output.0 - Step info: nrinput=1 nroutput=1
2016/11/07 10:24:07 - Table output.0 - Got previous step from [Table output] #0 --> Filter rows
2016/11/07 10:24:07 - Table output.0 - input rel is 1:1
2016/11/07 10:24:07 - Table output.0 - Found input rowset [Filter rows.0 - Table output.0]
2016/11/07 10:24:07 - Table output.0 - output rel. is  1:1
2016/11/07 10:24:07 - Table output.0 - Found output rowset [Table output.0 - Dummy (do nothing) 2.0]
2016/11/07 10:24:07 - Table output.0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Table output].0
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Dummy (do nothing)] of type [Dummy]
2016/11/07 10:24:07 - Dummy (do nothing).0 - distribution activated
2016/11/07 10:24:07 - Dummy (do nothing).0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Dummy (do nothing).0 - Step info: nrinput=1 nroutput=1
2016/11/07 10:24:07 - Dummy (do nothing).0 - Got previous step from [Dummy (do nothing)] #0 --> Filter rows
2016/11/07 10:24:07 - Dummy (do nothing).0 - input rel is 1:1
2016/11/07 10:24:07 - Dummy (do nothing).0 - Found input rowset [Filter rows.0 - Dummy (do nothing).0]
2016/11/07 10:24:07 - Dummy (do nothing).0 - output rel. is  1:1
2016/11/07 10:24:07 - Dummy (do nothing).0 - Found output rowset [Dummy (do nothing).0 - Dummy (do nothing) 2.0]
2016/11/07 10:24:07 - Dummy (do nothing).0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Dummy (do nothing)].0
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Dummy (do nothing) 2] of type [Dummy]
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - distribution activated
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Step info: nrinput=2 nroutput=0
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Got previous step from [Dummy (do nothing) 2] #0 --> Table output
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - input rel is 1:1
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Found input rowset [Table output.0 - Dummy (do nothing) 2.0]
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Got previous step from [Dummy (do nothing) 2] #1 --> Dummy (do nothing)
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - input rel is 1:1
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Found input rowset [Dummy (do nothing).0 - Dummy (do nothing) 2.0]
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Dummy (do nothing) 2].0
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Filter rows 2] of type [FilterRows]
2016/11/07 10:24:07 - Filter rows 2.0 - distribution activated
2016/11/07 10:24:07 - Filter rows 2.0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Filter rows 2.0 - Step info: nrinput=1 nroutput=2
2016/11/07 10:24:07 - Filter rows 2.0 - Got previous step from [Filter rows 2] #0 --> Modified Java Script Value
2016/11/07 10:24:07 - Filter rows 2.0 - input rel is 1:1
2016/11/07 10:24:07 - Filter rows 2.0 - Found input rowset [Modified Java Script Value.0 - Filter rows 2.0]
2016/11/07 10:24:07 - Filter rows 2.0 - output rel. is  1:1
2016/11/07 10:24:07 - Filter rows 2.0 - Found output rowset [Filter rows 2.0 - Filter rows.0]
2016/11/07 10:24:07 - Filter rows 2.0 - output rel. is  1:1
2016/11/07 10:24:07 - Filter rows 2.0 - Found output rowset [Filter rows 2.0 - Abort.0]
2016/11/07 10:24:07 - Filter rows 2.0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Filter rows 2].0
2016/11/07 10:24:07 - LecturaGPL -  Transformation is about to allocate step [Abort] of type [Abort]
2016/11/07 10:24:07 - Abort.0 - distribution activated
2016/11/07 10:24:07 - Abort.0 - Starting allocation of buffers & new threads...
2016/11/07 10:24:07 - Abort.0 - Step info: nrinput=1 nroutput=0
2016/11/07 10:24:07 - Abort.0 - Got previous step from [Abort] #0 --> Filter rows 2
2016/11/07 10:24:07 - Abort.0 - input rel is 1:1
2016/11/07 10:24:07 - Abort.0 - Found input rowset [Filter rows 2.0 - Abort.0]
2016/11/07 10:24:07 - Abort.0 - Finished dispatching
2016/11/07 10:24:07 - LecturaGPL -  Transformation has allocated a new step: [Abort].0
2016/11/07 10:24:07 - LecturaGPL - This transformation can be replayed with replay date: 2016/11/07 10:24:07
2016/11/07 10:24:07 - LecturaGPL - Initialising 8 steps...
2016/11/07 10:24:07 - Text file input.0 - Running on slave server #0/1.
2016/11/07 10:24:07 - Modified Java Script Value.0 - Running on slave server #0/1.
2016/11/07 10:24:07 - Table output.0 - Running on slave server #0/1.
2016/11/07 10:24:07 - Dummy (do nothing).0 - Running on slave server #0/1.
2016/11/07 10:24:07 - Filter rows.0 - Running on slave server #0/1.
2016/11/07 10:24:07 - Filter rows 2.0 - Running on slave server #0/1.
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Running on slave server #0/1.
2016/11/07 10:24:07 - localPostGres - New database connection defined
2016/11/07 10:24:07 - Abort.0 - Running on slave server #0/1.
2016/11/07 10:24:07 - localPostGres - Connected to database.
2016/11/07 10:24:07 - Table output.0 - Connected to database [localPostGres] (commit=1000)
2016/11/07 10:24:07 - localPostGres - Auto commit off
2016/11/07 10:24:07 - LecturaGPL - Step [Text file input.0] initialized flawlessly.
2016/11/07 10:24:07 - LecturaGPL - Step [Modified Java Script Value.0] initialized flawlessly.
2016/11/07 10:24:07 - LecturaGPL - Step [Filter rows.0] initialized flawlessly.
2016/11/07 10:24:07 - LecturaGPL - Step [Table output.0] initialized flawlessly.
2016/11/07 10:24:07 - LecturaGPL - Step [Dummy (do nothing).0] initialized flawlessly.
2016/11/07 10:24:07 - LecturaGPL - Step [Dummy (do nothing) 2.0] initialized flawlessly.
2016/11/07 10:24:07 - LecturaGPL - Step [Filter rows 2.0] initialized flawlessly.
2016/11/07 10:24:07 - LecturaGPL - Step [Abort.0] initialized flawlessly.
2016/11/07 10:24:07 - Text file input.0 - Starting to run...
2016/11/07 10:24:07 - LecturaGPL - Transformation has allocated 8 threads and 8 rowsets.
2016/11/07 10:24:07 - Modified Java Script Value.0 - Starting to run...
2016/11/07 10:24:07 - Dummy (do nothing).0 - Starting to run...
2016/11/07 10:24:07 - Dummy (do nothing) 2.0 - Starting to run...
2016/11/07 10:24:07 - Filter rows 2.0 - Starting to run...
2016/11/07 10:24:07 - Filter rows.0 - Starting to run...
2016/11/07 10:24:07 - Table output.0 - Starting to run...
2016/11/07 10:24:07 - Abort.0 - Starting to run...
2016/11/07 10:24:07 - Text file input.0 - Opening file: file:///var/www/informes/datos/gpl/global.web
2016/11/07 10:24:07 - Modified Java Script Value.0 - Value #0 -  [Field1] is used in the script.
2016/11/07 10:24:07 - Modified Java Script Value.0 - Value #4 -  [Field5] is used in the script.
2016/11/07 10:24:07 - Modified Java Script Value.0 - Value #6 -  [Field7] is used in the script.
2016/11/07 10:24:07 - Modified Java Script Value.0 - This script is using 3 values from the input stream(s)
2016/11/07 10:24:08 - Modified Java Script Value.0 - Optimization level set to 9.
2016/11/07 10:24:08 - Modified Java Script Value.0 - No starting Script found!
2016/11/07 10:24:08 - Modified Java Script Value.0 - No tran_Status found. Transformation status checking not available.
2016/11/07 10:24:08 - Table output.0 - Prepared statement : INSERT INTO "public".global_price_list_tmp (partnumber_gpl, descripcion_gpl, preciousd_gpl) VALUES ( ?,  ?,  ?)
2016/11/07 10:24:12 - Text file input.0 - linenr 50000
2016/11/07 10:24:12 - Modified Java Script Value.0 - linenr 50000
2016/11/07 10:24:13 - Filter rows 2.0 - linenr 50000
2016/11/07 10:24:14 - Filter rows.0 - linenr 50000
2016/11/07 10:24:16 - Table output.0 - linenr 50000
2016/11/07 10:24:16 - Dummy (do nothing) 2.0 - Linenr 50000
2016/11/07 10:24:17 - Text file input.0 - linenr 100000
2016/11/07 10:24:19 - Modified Java Script Value.0 - linenr 100000
2016/11/07 10:24:20 - Filter rows 2.0 - linenr 100000
2016/11/07 10:24:21 - Filter rows.0 - linenr 100000
2016/11/07 10:24:23 - Table output.0 - linenr 100000
2016/11/07 10:24:23 - Dummy (do nothing) 2.0 - Linenr 100000
2016/11/07 10:24:24 - Text file input.0 - linenr 150000
2016/11/07 10:24:26 - Modified Java Script Value.0 - linenr 150000
2016/11/07 10:24:27 - Filter rows 2.0 - linenr 150000
2016/11/07 10:24:28 - Filter rows.0 - linenr 150000
2016/11/07 10:24:30 - Table output.0 - linenr 150000
2016/11/07 10:24:30 - Dummy (do nothing) 2.0 - Linenr 150000
2016/11/07 10:24:31 - Text file input.0 - linenr 200000
2016/11/07 10:24:33 - Modified Java Script Value.0 - linenr 200000
2016/11/07 10:24:34 - Filter rows 2.0 - linenr 200000
2016/11/07 10:24:35 - Filter rows.0 - linenr 200000
2016/11/07 10:24:37 - Table output.0 - linenr 200000
2016/11/07 10:24:37 - Dummy (do nothing) 2.0 - Linenr 200000
2016/11/07 10:24:38 - Text file input.0 - linenr 250000
2016/11/07 10:24:40 - Modified Java Script Value.0 - linenr 250000
2016/11/07 10:24:41 - Filter rows 2.0 - linenr 250000
2016/11/07 10:24:43 - Filter rows.0 - linenr 250000
2016/11/07 10:24:44 - Table output.0 - linenr 250000
2016/11/07 10:24:44 - Dummy (do nothing) 2.0 - Linenr 250000
2016/11/07 10:24:45 - Text file input.0 - linenr 300000
2016/11/07 10:24:47 - Modified Java Script Value.0 - linenr 300000
2016/11/07 10:24:48 - Filter rows 2.0 - linenr 300000
2016/11/07 10:24:50 - Filter rows.0 - linenr 300000
2016/11/07 10:24:51 - Table output.0 - linenr 300000
2016/11/07 10:24:51 - Dummy (do nothing) 2.0 - Linenr 300000
2016/11/07 10:24:52 - Text file input.0 - linenr 350000
2016/11/07 10:24:54 - Modified Java Script Value.0 - linenr 350000
2016/11/07 10:24:55 - Filter rows 2.0 - linenr 350000
2016/11/07 10:24:57 - Filter rows.0 - linenr 350000
2016/11/07 10:24:58 - Table output.0 - linenr 350000
2016/11/07 10:24:58 - Dummy (do nothing) 2.0 - Linenr 350000
2016/11/07 10:25:00 - Text file input.0 - linenr 400000
2016/11/07 10:25:01 - Modified Java Script Value.0 - linenr 400000
2016/11/07 10:25:02 - Filter rows 2.0 - linenr 400000
2016/11/07 10:25:04 - Filter rows.0 - linenr 400000
2016/11/07 10:25:05 - Table output.0 - linenr 400000
2016/11/07 10:25:06 - Dummy (do nothing) 2.0 - Linenr 400000
2016/11/07 10:25:07 - Text file input.0 - linenr 450000
2016/11/07 10:25:08 - Modified Java Script Value.0 - linenr 450000
2016/11/07 10:25:10 - Filter rows 2.0 - linenr 450000
2016/11/07 10:25:11 - Filter rows.0 - linenr 450000
2016/11/07 10:25:13 - Table output.0 - linenr 450000
2016/11/07 10:25:13 - Dummy (do nothing) 2.0 - Linenr 450000
2016/11/07 10:25:14 - Text file input.0 - linenr 500000
2016/11/07 10:25:16 - Modified Java Script Value.0 - linenr 500000
2016/11/07 10:25:18 - Filter rows 2.0 - linenr 500000
2016/11/07 10:25:19 - Filter rows.0 - linenr 500000
2016/11/07 10:25:20 - Table output.0 - linenr 500000
2016/11/07 10:25:20 - Dummy (do nothing) 2.0 - Linenr 500000
2016/11/07 10:25:22 - Text file input.0 - linenr 550000
2016/11/07 10:25:23 - Modified Java Script Value.0 - linenr 550000
2016/11/07 10:25:24 - Filter rows 2.0 - linenr 550000
2016/11/07 10:25:26 - Filter rows.0 - linenr 550000
2016/11/07 10:25:27 - Table output.0 - linenr 550000
2016/11/07 10:25:27 - Dummy (do nothing) 2.0 - Linenr 550000
2016/11/07 10:25:29 - Text file input.0 - linenr 600000
2016/11/07 10:25:30 - Modified Java Script Value.0 - linenr 600000
2016/11/07 10:25:31 - Filter rows 2.0 - linenr 600000
2016/11/07 10:25:33 - Filter rows.0 - linenr 600000
2016/11/07 10:25:34 - Table output.0 - linenr 600000
2016/11/07 10:25:34 - Dummy (do nothing) 2.0 - Linenr 600000
2016/11/07 10:25:35 - Text file input.0 - linenr 650000
2016/11/07 10:25:37 - Modified Java Script Value.0 - linenr 650000
2016/11/07 10:25:38 - Filter rows 2.0 - linenr 650000
2016/11/07 10:25:40 - Filter rows.0 - linenr 650000
2016/11/07 10:25:41 - Table output.0 - linenr 650000
2016/11/07 10:25:41 - Dummy (do nothing) 2.0 - Linenr 650000
2016/11/07 10:25:42 - Text file input.0 - linenr 700000
2016/11/07 10:25:44 - Modified Java Script Value.0 - linenr 700000
2016/11/07 10:25:45 - Filter rows 2.0 - linenr 700000
2016/11/07 10:25:47 - Filter rows.0 - linenr 700000
2016/11/07 10:25:48 - Table output.0 - linenr 700000
2016/11/07 10:25:48 - Dummy (do nothing) 2.0 - Linenr 700000
2016/11/07 10:25:49 - Text file input.0 - linenr 750000
2016/11/07 10:25:51 - Modified Java Script Value.0 - linenr 750000
2016/11/07 10:25:53 - Filter rows 2.0 - linenr 750000
2016/11/07 10:25:54 - Filter rows.0 - linenr 750000
2016/11/07 10:25:56 - Table output.0 - linenr 750000
2016/11/07 10:25:56 - Dummy (do nothing) 2.0 - Linenr 750000
2016/11/07 10:25:57 - Text file input.0 - linenr 800000
2016/11/07 10:25:58 - Modified Java Script Value.0 - linenr 800000
2016/11/07 10:25:59 - Filter rows 2.0 - linenr 800000
2016/11/07 10:26:01 - Filter rows.0 - linenr 800000
2016/11/07 10:26:02 - Table output.0 - linenr 800000
2016/11/07 10:26:03 - Dummy (do nothing) 2.0 - Linenr 800000
2016/11/07 10:26:04 - Text file input.0 - linenr 850000
2016/11/07 10:26:05 - Modified Java Script Value.0 - linenr 850000
2016/11/07 10:26:07 - Filter rows 2.0 - linenr 850000
2016/11/07 10:26:08 - Filter rows.0 - linenr 850000
2016/11/07 10:26:10 - Table output.0 - linenr 850000
2016/11/07 10:26:10 - Dummy (do nothing) 2.0 - Linenr 850000
2016/11/07 10:26:11 - Text file input.0 - linenr 900000
2016/11/07 10:26:12 - Modified Java Script Value.0 - linenr 900000
2016/11/07 10:26:14 - Filter rows 2.0 - linenr 900000
2016/11/07 10:26:15 - Filter rows.0 - linenr 900000
2016/11/07 10:26:17 - Table output.0 - linenr 900000
2016/11/07 10:26:17 - Dummy (do nothing) 2.0 - Linenr 900000
2016/11/07 10:26:18 - Text file input.0 - linenr 950000
2016/11/07 10:26:20 - Modified Java Script Value.0 - linenr 950000
2016/11/07 10:26:21 - Filter rows 2.0 - linenr 950000
2016/11/07 10:26:22 - Filter rows.0 - linenr 950000
2016/11/07 10:26:24 - Table output.0 - linenr 950000
2016/11/07 10:26:24 - Dummy (do nothing) 2.0 - Linenr 950000
2016/11/07 10:26:25 - Text file input.0 - linenr 1000000
2016/11/07 10:26:27 - Modified Java Script Value.0 - linenr 1000000
2016/11/07 10:26:28 - Filter rows 2.0 - linenr 1000000
2016/11/07 10:26:30 - Filter rows.0 - linenr 1000000
2016/11/07 10:26:31 - Table output.0 - linenr 1000000
2016/11/07 10:26:31 - Dummy (do nothing) 2.0 - Linenr 1000000
2016/11/07 10:26:33 - Text file input.0 - linenr 1050000
2016/11/07 10:26:34 - Modified Java Script Value.0 - linenr 1050000
2016/11/07 10:26:35 - Filter rows 2.0 - linenr 1050000
2016/11/07 10:26:37 - Filter rows.0 - linenr 1050000
2016/11/07 10:26:38 - Table output.0 - linenr 1050000
2016/11/07 10:26:38 - Dummy (do nothing) 2.0 - Linenr 1050000
2016/11/07 10:26:40 - Text file input.0 - linenr 1100000
2016/11/07 10:26:41 - Modified Java Script Value.0 - linenr 1100000
2016/11/07 10:26:43 - Filter rows 2.0 - linenr 1100000
2016/11/07 10:26:44 - Filter rows.0 - linenr 1100000
2016/11/07 10:26:45 - Table output.0 - linenr 1100000
2016/11/07 10:26:46 - Dummy (do nothing) 2.0 - Linenr 1100000
2016/11/07 10:26:47 - Text file input.0 - linenr 1150000
2016/11/07 10:26:48 - Modified Java Script Value.0 - linenr 1150000
2016/11/07 10:26:50 - Filter rows 2.0 - linenr 1150000
2016/11/07 10:26:51 - Filter rows.0 - linenr 1150000
2016/11/07 10:26:52 - Table output.0 - linenr 1150000
2016/11/07 10:26:53 - Dummy (do nothing) 2.0 - Linenr 1150000
2016/11/07 10:26:54 - Text file input.0 - linenr 1200000
2016/11/07 10:26:55 - Modified Java Script Value.0 - linenr 1200000
2016/11/07 10:26:57 - Filter rows 2.0 - linenr 1200000
2016/11/07 10:26:58 - Filter rows.0 - linenr 1200000
2016/11/07 10:27:00 - Table output.0 - linenr 1200000
2016/11/07 10:27:00 - Dummy (do nothing) 2.0 - Linenr 1200000
2016/11/07 10:27:02 - Text file input.0 - linenr 1250000
2016/11/07 10:27:03 - Modified Java Script Value.0 - linenr 1250000
2016/11/07 10:27:04 - Filter rows 2.0 - linenr 1250000
2016/11/07 10:27:05 - Filter rows.0 - linenr 1250000
2016/11/07 10:27:07 - Table output.0 - linenr 1250000
2016/11/07 10:27:07 - Dummy (do nothing) 2.0 - Linenr 1250000
2016/11/07 10:27:08 - Text file input.0 - linenr 1300000
2016/11/07 10:27:10 - Modified Java Script Value.0 - linenr 1300000
2016/11/07 10:27:11 - Filter rows 2.0 - linenr 1300000
2016/11/07 10:27:12 - Filter rows.0 - linenr 1300000
2016/11/07 10:27:14 - Table output.0 - linenr 1300000
2016/11/07 10:27:14 - Dummy (do nothing) 2.0 - Linenr 1300000
2016/11/07 10:27:15 - Text file input.0 - linenr 1350000
2016/11/07 10:27:17 - Modified Java Script Value.0 - linenr 1350000
2016/11/07 10:27:18 - Filter rows 2.0 - linenr 1350000
2016/11/07 10:27:19 - Filter rows.0 - linenr 1350000
2016/11/07 10:27:21 - Table output.0 - linenr 1350000
2016/11/07 10:27:21 - Dummy (do nothing) 2.0 - Linenr 1350000
2016/11/07 10:27:22 - Text file input.0 - linenr 1400000
2016/11/07 10:27:24 - Modified Java Script Value.0 - linenr 1400000
2016/11/07 10:27:25 - Filter rows 2.0 - linenr 1400000
2016/11/07 10:27:26 - Filter rows.0 - linenr 1400000
2016/11/07 10:27:28 - Table output.0 - linenr 1400000
2016/11/07 10:27:28 - Dummy (do nothing) 2.0 - Linenr 1400000
2016/11/07 10:27:29 - Text file input.0 - linenr 1450000
2016/11/07 10:27:31 - Modified Java Script Value.0 - linenr 1450000
2016/11/07 10:27:32 - Filter rows 2.0 - linenr 1450000
2016/11/07 10:27:34 - Filter rows.0 - linenr 1450000
2016/11/07 10:27:35 - Table output.0 - linenr 1450000
2016/11/07 10:27:35 - Dummy (do nothing) 2.0 - Linenr 1450000
2016/11/07 10:27:37 - Text file input.0 - linenr 1500000
2016/11/07 10:27:38 - Modified Java Script Value.0 - linenr 1500000
2016/11/07 10:27:39 - Filter rows 2.0 - linenr 1500000
2016/11/07 10:27:41 - Filter rows.0 - linenr 1500000
2016/11/07 10:27:43 - Table output.0 - linenr 1500000
2016/11/07 10:27:43 - Dummy (do nothing) 2.0 - Linenr 1500000
2016/11/07 10:27:44 - Text file input.0 - linenr 1550000
2016/11/07 10:27:45 - Modified Java Script Value.0 - linenr 1550000
2016/11/07 10:27:47 - Filter rows 2.0 - linenr 1550000
2016/11/07 10:27:48 - Filter rows.0 - linenr 1550000
2016/11/07 10:27:50 - Table output.0 - linenr 1550000
2016/11/07 10:27:50 - Dummy (do nothing) 2.0 - Linenr 1550000
2016/11/07 10:27:51 - Text file input.0 - linenr 1600000
2016/11/07 10:27:53 - Modified Java Script Value.0 - linenr 1600000
2016/11/07 10:27:54 - Filter rows 2.0 - linenr 1600000
2016/11/07 10:27:55 - Filter rows.0 - linenr 1600000
2016/11/07 10:27:56 - Text file input.0 - Finished processing (I=1634287, O=0, R=0, W=1634287, U=1, E=0)
2016/11/07 10:27:57 - Table output.0 - linenr 1600000
2016/11/07 10:27:57 - Dummy (do nothing) 2.0 - Linenr 1600000
2016/11/07 10:27:57 - Modified Java Script Value.0 - No end Script found!
2016/11/07 10:27:57 - Modified Java Script Value.0 - Finished processing (I=0, O=0, R=1634287, W=1634287, U=0, E=0)
2016/11/07 10:27:59 - Filter rows 2.0 - Finished processing (I=0, O=0, R=1634287, W=1634287, U=0, E=0)
2016/11/07 10:27:59 - Abort.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2016/11/07 10:28:00 - Filter rows.0 - Finished processing (I=0, O=0, R=1634287, W=1634287, U=0, E=0)
2016/11/07 10:28:00 - Dummy (do nothing).0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2016/11/07 10:28:01 - localPostGres - Connection to database closed!
2016/11/07 10:28:01 - Table output.0 - Finished processing (I=0, O=1634287, R=1634287, W=1634287, U=0, E=0)
2016/11/07 10:28:01 - Dummy (do nothing) 2.0 - Finished processing (I=0, O=0, R=1634287, W=1634287, U=0, E=0)
2016/11/07 10:28:01 - CargaArchivos - Starting entry [Existen datos ? GPL]
2016/11/07 10:28:01 - CargaArchivos - exec(4, 0, Existen datos ? GPL.0)
2016/11/07 10:28:01 - Es GPL? - Starting job entry
2016/11/07 10:28:01 - Es GPL? - Rows limit set to [1]
2016/11/07 10:28:01 - localPostgre - New database connection defined
2016/11/07 10:28:01 - localPostgre - Connected to database.
2016/11/07 10:28:01 - Es GPL? - We will run the following SQL statement : SELECT 1 as valor
2016/11/07 10:28:01 - Es GPL? - UNION
2016/11/07 10:28:01 - Es GPL? - SELECT 2 as valor
2016/11/07 10:28:01 - Es GPL? - FROM
2016/11/07 10:28:01 - Es GPL? - (
2016/11/07 10:28:01 - Es GPL? - SELECT
2016/11/07 10:28:01 - Es GPL? - a.partnumber_gpl,
2016/11/07 10:28:01 - Es GPL? - (SELECT descripcion_gpl 
2016/11/07 10:28:01 - Es GPL? - from global_price_list_tmp 
2016/11/07 10:28:01 - Es GPL? - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:01 - Es GPL? - limit 1) as descripcion_gpl,
2016/11/07 10:28:01 - Es GPL? - (SELECT preciousd_gpl
2016/11/07 10:28:01 - Es GPL? - from global_price_list_tmp 
2016/11/07 10:28:01 - Es GPL? - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:01 - Es GPL? - limit 1) as preciousd_gpl
2016/11/07 10:28:01 - Es GPL? - FROM (
2016/11/07 10:28:01 - Es GPL? - SELECT partnumber_gpl
2016/11/07 10:28:01 - Es GPL? - from global_price_list_tmp
2016/11/07 10:28:01 - Es GPL? - WHERE UPPER(partnumber_gpl) NOT LIKE 'CON-%'
2016/11/07 10:28:01 - Es GPL? - group by partnumber_gpl
2016/11/07 10:28:01 - Es GPL? - ) a
2016/11/07 10:28:01 - Es GPL? - ) b
2016/11/07 10:28:02 - Es GPL? - We returned 2 row(s)
2016/11/07 10:28:02 - localPostgre - Connection to database closed!
2016/11/07 10:28:02 - CargaArchivos - Starting entry [Inserta en GPL y Borra GPL TMP]
2016/11/07 10:28:02 - CargaArchivos - exec(5, 0, Inserta en GPL y Borra GPL TMP.0)
2016/11/07 10:28:02 - Es GPL? - Starting job entry
2016/11/07 10:28:02 - localPostgre - New database connection defined
2016/11/07 10:28:02 - localPostgre - Connected to database.
2016/11/07 10:28:02 - Es GPL? - Running SQL :CREATE INDEX partnumbergpl_idx ON global_price_list_tmp (partnumber_gpl);
2016/11/07 10:28:02 - Es GPL? - TRUNCATE TABLE global_price_list;
2016/11/07 10:28:02 - Es GPL? - INSERT INTO global_price_list (partnumber_gpl, descripcion_gpl , preciousd_gpl)
2016/11/07 10:28:02 - Es GPL? - SELECT
2016/11/07 10:28:02 - Es GPL? - a.partnumber_gpl,
2016/11/07 10:28:02 - Es GPL? - (SELECT descripcion_gpl 
2016/11/07 10:28:02 - Es GPL? - from global_price_list_tmp 
2016/11/07 10:28:02 - Es GPL? - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - order by preciousd_gpl DESC
2016/11/07 10:28:02 - Es GPL? - limit 1) as descripcion_gpl,
2016/11/07 10:28:02 - Es GPL? - (SELECT preciousd_gpl
2016/11/07 10:28:02 - Es GPL? - from global_price_list_tmp 
2016/11/07 10:28:02 - Es GPL? - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - order by preciousd_gpl DESC
2016/11/07 10:28:02 - Es GPL? - limit 1) as preciousd_gpl
2016/11/07 10:28:02 - Es GPL? - FROM (
2016/11/07 10:28:02 - Es GPL? - SELECT g.partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - from global_price_list_tmp g INNER JOIN FAMILIA_PRODUCTO_ESPECIAL F ON g.PARTNUMBER_GPL = F.PARTNUMBER_FAMPROESP
2016/11/07 10:28:02 - Es GPL? - WHERE UPPER(g.partnumber_gpl) NOT LIKE 'CON-%'
2016/11/07 10:28:02 - Es GPL? - group by g.partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - ) a;
2016/11/07 10:28:02 - Es GPL? - 
2016/11/07 10:28:02 - Es GPL? - INSERT INTO global_price_list (partnumber_gpl, descripcion_gpl , preciousd_gpl)
2016/11/07 10:28:02 - Es GPL? - SELECT
2016/11/07 10:28:02 - Es GPL? - a.partnumber_gpl,
2016/11/07 10:28:02 - Es GPL? - (SELECT descripcion_gpl 
2016/11/07 10:28:02 - Es GPL? - from global_price_list_tmp 
2016/11/07 10:28:02 - Es GPL? - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - order by preciousd_gpl DESC
2016/11/07 10:28:02 - Es GPL? - limit 1) as descripcion_gpl,
2016/11/07 10:28:02 - Es GPL? - (SELECT preciousd_gpl
2016/11/07 10:28:02 - Es GPL? - from global_price_list_tmp 
2016/11/07 10:28:02 - Es GPL? - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - order by preciousd_gpl DESC
2016/11/07 10:28:02 - Es GPL? - limit 1) as preciousd_gpl
2016/11/07 10:28:02 - Es GPL? - FROM (
2016/11/07 10:28:02 - Es GPL? - SELECT partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - from global_price_list_tmp g INNER JOIN FAMILIA_PRODUCTO F ON g.PARTNUMBER_GPL like F.PARTNUMBER_FAMPRO || '%'
2016/11/07 10:28:02 - Es GPL? - WHERE UPPER(partnumber_gpl) NOT LIKE 'CON-%' AND NOT EXISTS (SELECT 1 FROM global_price_list gp where gp.partnumber_gpl = g.partnumber_gpl)
2016/11/07 10:28:02 - Es GPL? - group by partnumber_gpl
2016/11/07 10:28:02 - Es GPL? - ) a;
2016/11/07 10:28:02 - Es GPL? - TRUNCATE TABLE global_price_list_tmp;
2016/11/07 10:28:02 - Es GPL? - update tipo_dato set validado = true, ingresado = false,
2016/11/07 10:28:02 - Es GPL? - observacion = 'Datos ingresados y validados de manera exitosa', fecha = now() where nombre = 'GPL';
2016/11/07 10:28:02 - localPostgre - launch DDL statement: 
2016/11/07 10:28:02 - localPostgre - CREATE INDEX partnumbergpl_idx ON global_price_list_tmp (partnumber_gpl)
2016/11/07 10:28:04 - localPostgre - launch DDL statement: 
2016/11/07 10:28:04 - localPostgre - TRUNCATE TABLE global_price_list
2016/11/07 10:28:04 - localPostgre - launch DDL statement: 
2016/11/07 10:28:04 - localPostgre - INSERT INTO global_price_list (partnumber_gpl, descripcion_gpl , preciousd_gpl)
2016/11/07 10:28:04 - localPostgre - SELECT
2016/11/07 10:28:04 - localPostgre - a.partnumber_gpl,
2016/11/07 10:28:04 - localPostgre - (SELECT descripcion_gpl 
2016/11/07 10:28:04 - localPostgre - from global_price_list_tmp 
2016/11/07 10:28:04 - localPostgre - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:04 - localPostgre - order by preciousd_gpl DESC
2016/11/07 10:28:04 - localPostgre - limit 1) as descripcion_gpl,
2016/11/07 10:28:04 - localPostgre - (SELECT preciousd_gpl
2016/11/07 10:28:04 - localPostgre - from global_price_list_tmp 
2016/11/07 10:28:04 - localPostgre - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:04 - localPostgre - order by preciousd_gpl DESC
2016/11/07 10:28:04 - localPostgre - limit 1) as preciousd_gpl
2016/11/07 10:28:04 - localPostgre - FROM (
2016/11/07 10:28:04 - localPostgre - SELECT g.partnumber_gpl
2016/11/07 10:28:04 - localPostgre - from global_price_list_tmp g INNER JOIN FAMILIA_PRODUCTO_ESPECIAL F ON g.PARTNUMBER_GPL = F.PARTNUMBER_FAMPROESP
2016/11/07 10:28:04 - localPostgre - WHERE UPPER(g.partnumber_gpl) NOT LIKE 'CON-%'
2016/11/07 10:28:04 - localPostgre - group by g.partnumber_gpl
2016/11/07 10:28:04 - localPostgre - ) a
2016/11/07 10:28:04 - localPostgre - launch DDL statement: 
2016/11/07 10:28:04 - localPostgre - INSERT INTO global_price_list (partnumber_gpl, descripcion_gpl , preciousd_gpl)
2016/11/07 10:28:04 - localPostgre - SELECT
2016/11/07 10:28:04 - localPostgre - a.partnumber_gpl,
2016/11/07 10:28:04 - localPostgre - (SELECT descripcion_gpl 
2016/11/07 10:28:04 - localPostgre - from global_price_list_tmp 
2016/11/07 10:28:04 - localPostgre - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:04 - localPostgre - order by preciousd_gpl DESC
2016/11/07 10:28:04 - localPostgre - limit 1) as descripcion_gpl,
2016/11/07 10:28:04 - localPostgre - (SELECT preciousd_gpl
2016/11/07 10:28:04 - localPostgre - from global_price_list_tmp 
2016/11/07 10:28:04 - localPostgre - where partnumber_gpl = a.partnumber_gpl
2016/11/07 10:28:04 - localPostgre - order by preciousd_gpl DESC
2016/11/07 10:28:04 - localPostgre - limit 1) as preciousd_gpl
2016/11/07 10:28:04 - localPostgre - FROM (
2016/11/07 10:28:04 - localPostgre - SELECT partnumber_gpl
2016/11/07 10:28:04 - localPostgre - from global_price_list_tmp g INNER JOIN FAMILIA_PRODUCTO F ON g.PARTNUMBER_GPL like F.PARTNUMBER_FAMPRO || '%'
2016/11/07 10:28:04 - localPostgre - WHERE UPPER(partnumber_gpl) NOT LIKE 'CON-%' AND NOT EXISTS (SELECT 1 FROM global_price_list gp where gp.partnumber_gpl = g.partnumber_gpl)
2016/11/07 10:28:04 - localPostgre - group by partnumber_gpl
2016/11/07 10:28:04 - localPostgre - ) a
2016/11/07 10:28:08 - localPostgre - launch DDL statement: 
2016/11/07 10:28:08 - localPostgre - TRUNCATE TABLE global_price_list_tmp
2016/11/07 10:28:08 - localPostgre - launch DDL statement: 
2016/11/07 10:28:08 - localPostgre - update tipo_dato set validado = true, ingresado = false,
2016/11/07 10:28:08 - localPostgre - observacion = 'Datos ingresados y validados de manera exitosa', fecha = now() where nombre = 'GPL'
2016/11/07 10:28:08 - localPostgre - 6 statements executed
2016/11/07 10:28:08 - localPostgre - Connection to database closed!
2016/11/07 10:28:08 - CargaArchivos - Finished job entry [Inserta en GPL y Borra GPL TMP] (result=[true])
2016/11/07 10:28:08 - CargaArchivos - Finished job entry [Existen datos ? GPL] (result=[true])
2016/11/07 10:28:08 - CargaArchivos - Finished job entry [CargaGPL] (result=[true])
2016/11/07 10:28:08 - CargaArchivos - Finished job entry [Drop Index y Vacia Tablas] (result=[true])
2016/11/07 10:28:08 - CargaArchivos - Finished job entry [Es GPL?] (result=[true])
2016/11/07 10:28:08 - CargaArchivos - Job execution finished