string(29) "Sat May 3 11:39:50 -04 2025 "
WARN 03-05 11:39:57,061 - Unable to load Hadoop Configuration from "file:///home/admin_tecno/data-integration/plugins/pentaho-big-data-plugin/hadoop-configurations/mapr". For more information enable debug logging. INFO 03-05 11:39:57,226 - Kitchen - Logging is at level : Detailed logging INFO 03-05 11:39:57,227 - Kitchen - Start of run. INFO 03-05 11:39:57,517 - CargaArchivos - Start of job execution INFO 03-05 11:39:57,524 - CargaArchivos - exec(0, 0, START.0) INFO 03-05 11:39:57,534 - START - Starting job entry INFO 03-05 11:39:57,534 - CargaArchivos - Starting entry [Es GPL?] INFO 03-05 11:39:57,535 - CargaArchivos - exec(1, 0, Es GPL?.0) INFO 03-05 11:39:57,538 - Es GPL? - Starting job entry INFO 03-05 11:39:57,540 - Es GPL? - Value to evaluate is WPL INFO 03-05 11:39:57,541 - CargaArchivos - Starting entry [Es WPL?] INFO 03-05 11:39:57,541 - CargaArchivos - exec(2, 0, Es WPL?.0) INFO 03-05 11:39:57,541 - Es GPL? - Starting job entry INFO 03-05 11:39:57,542 - Es GPL? - Value to evaluate is WPL INFO 03-05 11:39:57,542 - CargaArchivos - Starting entry [Drop Index y Vacia Tablas WPL] INFO 03-05 11:39:57,542 - CargaArchivos - exec(3, 0, Drop Index y Vacia Tablas WPL.0) INFO 03-05 11:39:57,543 - Es GPL? - Starting job entry INFO 03-05 11:39:57,566 - localPostgre - New database connection defined INFO 03-05 11:39:57,798 - localPostgre - Connected to database. INFO 03-05 11:39:57,799 - Es GPL? - Running SQL :DROP INDEX IF EXISTS partnumberwpl_idx; TRUNCATE TABLE wholesale_price_list_tmp; update tipo_dato set validado = false, ingresado = true, observacion = 'A la espera de valicaci?n de datos' where nombre = 'WPL'; INFO 03-05 11:39:57,800 - localPostgre - launch DDL statement: DROP INDEX IF EXISTS partnumberwpl_idx INFO 03-05 11:39:57,818 - localPostgre - launch DDL statement: TRUNCATE TABLE wholesale_price_list_tmp INFO 03-05 11:39:57,868 - localPostgre - launch DDL statement: update tipo_dato set validado = false, ingresado = true, observacion = 'A la espera de valicaci?n de datos' where nombre = 'WPL' INFO 03-05 11:39:57,880 - localPostgre - 3 statements executed INFO 03-05 11:39:57,880 - localPostgre - Connection to database closed! INFO 03-05 11:39:57,883 - CargaArchivos - Starting entry [CargaWPL] INFO 03-05 11:39:57,883 - CargaArchivos - exec(4, 0, CargaWPL.0) INFO 03-05 11:39:57,884 - CargaWPL - Starting job entry INFO 03-05 11:39:57,886 - CargaWPL - Opening transformation: [file:///home/admin_tecno/transformaciones/LecturaWPL.ktr] INFO 03-05 11:39:57,886 - CargaWPL - Loading transformation from XML file [file:///home/admin_tecno/transformaciones/LecturaWPL.ktr] INFO 03-05 11:39:58,075 - CargaWPL - Starting transformation...(file=${Internal.Job.Filename.Directory}/LecturaWPL.ktr, name=CargaWPL, repinfo=null) INFO 03-05 11:39:58,093 - LecturaWPL - Transformation is pre-loaded. INFO 03-05 11:39:58,093 - LecturaWPL - Dispatching started for transformation [LecturaWPL] INFO 03-05 11:39:58,093 - LecturaWPL - Nr of arguments detected:0 INFO 03-05 11:39:58,094 - LecturaWPL - This is not a replay transformation INFO 03-05 11:39:58,094 - LecturaWPL - I found 7 different steps to launch. INFO 03-05 11:39:58,094 - LecturaWPL - Allocating rowsets... INFO 03-05 11:39:58,094 - LecturaWPL - Allocating rowsets for step 0 --> Text file input INFO 03-05 11:39:58,094 - LecturaWPL - prevcopies = 1, nextcopies=1 INFO 03-05 11:39:58,096 - LecturaWPL - Transformation allocated new rowset [Text file input.0 - Modified Java Script Value 2.0] INFO 03-05 11:39:58,096 - LecturaWPL - Allocated 1 rowsets for step 0 --> Text file input INFO 03-05 11:39:58,097 - LecturaWPL - Allocating rowsets for step 1 --> Modified Java Script Value 2 INFO 03-05 11:39:58,098 - LecturaWPL - prevcopies = 1, nextcopies=1 INFO 03-05 11:39:58,098 - LecturaWPL - Transformation allocated new rowset [Modified Java Script Value 2.0 - Filter rows 2.0] INFO 03-05 11:39:58,098 - LecturaWPL - Allocated 2 rowsets for step 1 --> Modified Java Script Value 2 INFO 03-05 11:39:58,099 - LecturaWPL - Allocating rowsets for step 2 --> Filter rows INFO 03-05 11:39:58,099 - LecturaWPL - prevcopies = 1, nextcopies=1 INFO 03-05 11:39:58,099 - LecturaWPL - Transformation allocated new rowset [Filter rows.0 - Table output.0] INFO 03-05 11:39:58,099 - LecturaWPL - prevcopies = 1, nextcopies=1 INFO 03-05 11:39:58,099 - LecturaWPL - Transformation allocated new rowset [Filter rows.0 - Dummy (do nothing).0] INFO 03-05 11:39:58,099 - LecturaWPL - Allocated 4 rowsets for step 2 --> Filter rows INFO 03-05 11:39:58,100 - LecturaWPL - Allocating rowsets for step 3 --> Table output INFO 03-05 11:39:58,100 - LecturaWPL - Allocated 4 rowsets for step 3 --> Table output INFO 03-05 11:39:58,100 - LecturaWPL - Allocating rowsets for step 4 --> Dummy (do nothing) INFO 03-05 11:39:58,100 - LecturaWPL - Allocated 4 rowsets for step 4 --> Dummy (do nothing) INFO 03-05 11:39:58,101 - LecturaWPL - Allocating rowsets for step 5 --> Filter rows 2 INFO 03-05 11:39:58,101 - LecturaWPL - prevcopies = 1, nextcopies=1 INFO 03-05 11:39:58,101 - LecturaWPL - Transformation allocated new rowset [Filter rows 2.0 - Filter rows.0] INFO 03-05 11:39:58,106 - LecturaWPL - prevcopies = 1, nextcopies=1 INFO 03-05 11:39:58,106 - LecturaWPL - Transformation allocated new rowset [Filter rows 2.0 - Abort.0] INFO 03-05 11:39:58,107 - LecturaWPL - Allocated 6 rowsets for step 5 --> Filter rows 2 INFO 03-05 11:39:58,107 - LecturaWPL - Allocating rowsets for step 6 --> Abort INFO 03-05 11:39:58,107 - LecturaWPL - Allocated 6 rowsets for step 6 --> Abort INFO 03-05 11:39:58,107 - LecturaWPL - Allocating Steps & StepData... INFO 03-05 11:39:58,107 - LecturaWPL - Transformation is about to allocate step [Text file input] of type [TextFileInput] INFO 03-05 11:39:58,123 - Text file input - Starting allocation of buffers & new threads... INFO 03-05 11:39:58,123 - Text file input - Step info: nrinput=0 nroutput=1 INFO 03-05 11:39:58,123 - Text file input - output rel. is 1:1 INFO 03-05 11:39:58,123 - Text file input - Found output rowset [Text file input.0 - Modified Java Script Value 2.0] INFO 03-05 11:39:58,124 - Text file input - Finished dispatching INFO 03-05 11:39:58,124 - LecturaWPL - Transformation has allocated a new step: [Text file input].0 INFO 03-05 11:39:58,124 - LecturaWPL - Transformation is about to allocate step [Modified Java Script Value 2] of type [ScriptValueMod] INFO 03-05 11:39:58,127 - Modified Java Script Value 2 - distribution activated INFO 03-05 11:39:58,127 - Modified Java Script Value 2 - Starting allocation of buffers & new threads... INFO 03-05 11:39:58,128 - Modified Java Script Value 2 - Step info: nrinput=1 nroutput=1 INFO 03-05 11:39:58,128 - Modified Java Script Value 2 - Got previous step from [Modified Java Script Value 2] #0 --> Text file input INFO 03-05 11:39:58,128 - Modified Java Script Value 2 - input rel is 1:1 INFO 03-05 11:39:58,128 - Modified Java Script Value 2 - Found input rowset [Text file input.0 - Modified Java Script Value 2.0] INFO 03-05 11:39:58,128 - Modified Java Script Value 2 - output rel. is 1:1 INFO 03-05 11:39:58,129 - Modified Java Script Value 2 - Found output rowset [Modified Java Script Value 2.0 - Filter rows 2.0] INFO 03-05 11:39:58,129 - Modified Java Script Value 2 - Finished dispatching INFO 03-05 11:39:58,129 - LecturaWPL - Transformation has allocated a new step: [Modified Java Script Value 2].0 INFO 03-05 11:39:58,129 - LecturaWPL - Transformation is about to allocate step [Filter rows] of type [FilterRows] INFO 03-05 11:39:58,131 - Filter rows - distribution activated INFO 03-05 11:39:58,132 - Filter rows - Starting allocation of buffers & new threads... INFO 03-05 11:39:58,132 - Filter rows - Step info: nrinput=1 nroutput=2 INFO 03-05 11:39:58,134 - Filter rows - Got previous step from [Filter rows] #0 --> Filter rows 2 INFO 03-05 11:39:58,135 - Filter rows - input rel is 1:1 INFO 03-05 11:39:58,136 - Filter rows - Found input rowset [Filter rows 2.0 - Filter rows.0] INFO 03-05 11:39:58,136 - Filter rows - output rel. is 1:1 INFO 03-05 11:39:58,136 - Filter rows - Found output rowset [Filter rows.0 - Table output.0] INFO 03-05 11:39:58,136 - Filter rows - output rel. is 1:1 INFO 03-05 11:39:58,136 - Filter rows - Found output rowset [Filter rows.0 - Dummy (do nothing).0] INFO 03-05 11:39:58,136 - Filter rows - Finished dispatching INFO 03-05 11:39:58,137 - LecturaWPL - Transformation has allocated a new step: [Filter rows].0 INFO 03-05 11:39:58,137 - LecturaWPL - Transformation is about to allocate step [Table output] of type [TableOutput] INFO 03-05 11:39:58,140 - Table output - distribution activated INFO 03-05 11:39:58,140 - Table output - Starting allocation of buffers & new threads... INFO 03-05 11:39:58,140 - Table output - Step info: nrinput=1 nroutput=0 INFO 03-05 11:39:58,141 - Table output - Got previous step from [Table output] #0 --> Filter rows INFO 03-05 11:39:58,141 - Table output - input rel is 1:1 INFO 03-05 11:39:58,141 - Table output - Found input rowset [Filter rows.0 - Table output.0] INFO 03-05 11:39:58,141 - Table output - Finished dispatching INFO 03-05 11:39:58,142 - LecturaWPL - Transformation has allocated a new step: [Table output].0 INFO 03-05 11:39:58,142 - LecturaWPL - Transformation is about to allocate step [Dummy (do nothing)] of type [Dummy] INFO 03-05 11:39:58,143 - Dummy (do nothing) - distribution activated INFO 03-05 11:39:58,143 - Dummy (do nothing) - Starting allocation of buffers & new threads... INFO 03-05 11:39:58,144 - Dummy (do nothing) - Step info: nrinput=1 nroutput=0 INFO 03-05 11:39:58,145 - Dummy (do nothing) - Got previous step from [Dummy (do nothing)] #0 --> Filter rows INFO 03-05 11:39:58,146 - Dummy (do nothing) - input rel is 1:1 INFO 03-05 11:39:58,146 - Dummy (do nothing) - Found input rowset [Filter rows.0 - Dummy (do nothing).0] INFO 03-05 11:39:58,146 - Dummy (do nothing) - Finished dispatching INFO 03-05 11:39:58,147 - LecturaWPL - Transformation has allocated a new step: [Dummy (do nothing)].0 INFO 03-05 11:39:58,147 - LecturaWPL - Transformation is about to allocate step [Filter rows 2] of type [FilterRows] INFO 03-05 11:39:58,151 - Filter rows 2 - distribution activated INFO 03-05 11:39:58,151 - Filter rows 2 - Starting allocation of buffers & new threads... INFO 03-05 11:39:58,151 - Filter rows 2 - Step info: nrinput=1 nroutput=2 INFO 03-05 11:39:58,152 - Filter rows 2 - Got previous step from [Filter rows 2] #0 --> Modified Java Script Value 2 INFO 03-05 11:39:58,152 - Filter rows 2 - input rel is 1:1 INFO 03-05 11:39:58,153 - Filter rows 2 - Found input rowset [Modified Java Script Value 2.0 - Filter rows 2.0] INFO 03-05 11:39:58,153 - Filter rows 2 - output rel. is 1:1 INFO 03-05 11:39:58,153 - Filter rows 2 - Found output rowset [Filter rows 2.0 - Filter rows.0] INFO 03-05 11:39:58,154 - Filter rows 2 - output rel. is 1:1 INFO 03-05 11:39:58,155 - Filter rows 2 - Found output rowset [Filter rows 2.0 - Abort.0] INFO 03-05 11:39:58,155 - Filter rows 2 - Finished dispatching INFO 03-05 11:39:58,155 - LecturaWPL - Transformation has allocated a new step: [Filter rows 2].0 INFO 03-05 11:39:58,155 - LecturaWPL - Transformation is about to allocate step [Abort] of type [Abort] INFO 03-05 11:39:58,157 - Abort - distribution activated INFO 03-05 11:39:58,159 - Abort - Starting allocation of buffers & new threads... INFO 03-05 11:39:58,159 - Abort - Step info: nrinput=1 nroutput=0 INFO 03-05 11:39:58,161 - Abort - Got previous step from [Abort] #0 --> Filter rows 2 INFO 03-05 11:39:58,161 - Abort - input rel is 1:1 INFO 03-05 11:39:58,162 - Abort - Found input rowset [Filter rows 2.0 - Abort.0] INFO 03-05 11:39:58,162 - Abort - Finished dispatching INFO 03-05 11:39:58,162 - LecturaWPL - Transformation has allocated a new step: [Abort].0 INFO 03-05 11:39:58,162 - LecturaWPL - This transformation can be replayed with replay date: 2025/05/03 11:39:58 INFO 03-05 11:39:58,163 - LecturaWPL - Initialising 7 steps... INFO 03-05 11:39:58,170 - Text file input - Running on slave server #0/1. INFO 03-05 11:39:58,170 - Modified Java Script Value 2 - Running on slave server #0/1. INFO 03-05 11:39:58,170 - Filter rows - Running on slave server #0/1. INFO 03-05 11:39:58,171 - Table output - Running on slave server #0/1. INFO 03-05 11:39:58,172 - Dummy (do nothing) - Running on slave server #0/1. INFO 03-05 11:39:58,175 - Filter rows 2 - Running on slave server #0/1. INFO 03-05 11:39:58,180 - localPostGres - New database connection defined INFO 03-05 11:39:58,182 - Abort - Running on slave server #0/1. INFO 03-05 11:39:58,185 - localPostGres - Connected to database. INFO 03-05 11:39:58,186 - Table output - Connected to database [localPostGres] (commit=1000) INFO 03-05 11:39:58,186 - localPostGres - Auto commit off INFO 03-05 11:39:58,206 - LecturaWPL - Step [Text file input.0] initialized flawlessly. INFO 03-05 11:39:58,207 - LecturaWPL - Step [Modified Java Script Value 2.0] initialized flawlessly. INFO 03-05 11:39:58,207 - LecturaWPL - Step [Filter rows.0] initialized flawlessly. INFO 03-05 11:39:58,207 - LecturaWPL - Step [Table output.0] initialized flawlessly. INFO 03-05 11:39:58,207 - LecturaWPL - Step [Dummy (do nothing).0] initialized flawlessly. INFO 03-05 11:39:58,207 - LecturaWPL - Step [Filter rows 2.0] initialized flawlessly. INFO 03-05 11:39:58,207 - LecturaWPL - Step [Abort.0] initialized flawlessly. INFO 03-05 11:39:58,211 - Text file input - Starting to run... INFO 03-05 11:39:58,215 - Text file input - Opening file: file:///var/www/informes/datos/wpl/wic2.web INFO 03-05 11:39:58,217 - Filter rows - Starting to run... INFO 03-05 11:39:58,217 - Modified Java Script Value 2 - Starting to run... INFO 03-05 11:39:58,218 - Table output - Starting to run... INFO 03-05 11:39:58,223 - Dummy (do nothing) - Starting to run... INFO 03-05 11:39:58,230 - Abort - Starting to run... INFO 03-05 11:39:58,229 - Modified Java Script Value 2 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) INFO 03-05 11:39:58,228 - Text file input - Finished processing (I=0, O=0, R=0, W=0, U=1, E=0) INFO 03-05 11:39:58,226 - LecturaWPL - Transformation has allocated 7 threads and 6 rowsets. INFO 03-05 11:39:58,224 - Filter rows 2 - Starting to run... INFO 03-05 11:39:58,234 - Filter rows 2 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) INFO 03-05 11:39:58,236 - Filter rows - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) INFO 03-05 11:39:58,237 - Abort - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) INFO 03-05 11:39:58,244 - Dummy (do nothing) - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) INFO 03-05 11:39:58,288 - localPostGres - Connection to database closed! INFO 03-05 11:39:58,288 - Table output - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) INFO 03-05 11:39:58,292 - CargaArchivos - Starting entry [Existen datos ? WPL] INFO 03-05 11:39:58,292 - CargaArchivos - exec(5, 0, Existen datos ? WPL.0) INFO 03-05 11:39:58,292 - Es GPL? - Starting job entry INFO 03-05 11:39:58,293 - Es GPL? - Rows limit set to [1] INFO 03-05 11:39:58,293 - localPostgre - New database connection defined INFO 03-05 11:39:58,298 - localPostgre - Connected to database. INFO 03-05 11:39:58,298 - Es GPL? - We will run the following SQL statement : SELECT 1 as valor UNION SELECT 2 as valor FROM ( SELECT partnumber_wpl, descripcion_wpl , preciousd_wpl from wholesale_price_list_tmp WHERE UPPER(partnumber_wpl) NOT LIKE 'CON-%' group by partnumber_wpl, descripcion_wpl , preciousd_wpl ) b INFO 03-05 11:39:58,321 - Es GPL? - We returned 1 row(s) INFO 03-05 11:39:58,321 - localPostgre - Connection to database closed! INFO 03-05 11:39:58,323 - CargaArchivos - Starting entry [No existen datos WPL a cargar] INFO 03-05 11:39:58,323 - CargaArchivos - exec(6, 0, No existen datos WPL a cargar.0) INFO 03-05 11:39:58,324 - Es GPL? - Starting job entry INFO 03-05 11:39:58,324 - localPostgre - New database connection defined INFO 03-05 11:39:58,329 - localPostgre - Connected to database. INFO 03-05 11:39:58,330 - Es GPL? - Running SQL :update tipo_dato set validado = false, ingresado = false, observacion = 'No existen datos a cargar, favor revise los datos' where lower(nombre) = 'wpl'; INFO 03-05 11:39:58,330 - localPostgre - launch DDL statement: update tipo_dato set validado = false, ingresado = false, observacion = 'No existen datos a cargar, favor revise los datos' where lower(nombre) = 'wpl' INFO 03-05 11:39:58,336 - localPostgre - 1 statement executed INFO 03-05 11:39:58,336 - localPostgre - Connection to database closed! INFO 03-05 11:39:58,339 - CargaArchivos - Finished job entry [No existen datos WPL a cargar] (result=[true]) INFO 03-05 11:39:58,339 - CargaArchivos - Finished job entry [Existen datos ? WPL] (result=[true]) INFO 03-05 11:39:58,339 - CargaArchivos - Finished job entry [CargaWPL] (result=[true]) INFO 03-05 11:39:58,340 - CargaArchivos - Finished job entry [Drop Index y Vacia Tablas WPL] (result=[true]) INFO 03-05 11:39:58,340 - CargaArchivos - Finished job entry [Es WPL?] (result=[true]) INFO 03-05 11:39:58,340 - CargaArchivos - Finished job entry [Es GPL?] (result=[true]) INFO 03-05 11:39:58,340 - CargaArchivos - Job execution finished INFO 03-05 11:39:58,341 - Kitchen - Finished! INFO 03-05 11:39:58,341 - Kitchen - Start=2025/05/03 11:39:57.227, Stop=2025/05/03 11:39:58.341 INFO 03-05 11:39:58,341 - Kitchen - Processing ended after 1 seconds.