2020/07/24 19:27:07 - Kitchen - Logging is at level : Detailed logging
2020/07/24 19:27:07 - Kitchen - Start of run.
2020/07/24 19:27:07 - CargaArchivos - Start of job execution
2020/07/24 19:27:07 - CargaArchivos - exec(0, 0, START.0)
2020/07/24 19:27:08 - START - Starting job entry
2020/07/24 19:27:08 - CargaArchivos - Starting entry [Es GPL?]
2020/07/24 19:27:08 - CargaArchivos - exec(1, 0, Es GPL?.0)
2020/07/24 19:27:08 - Es GPL? - Starting job entry
2020/07/24 19:27:08 - Es GPL? - Value to evaluate is Fasttrack
2020/07/24 19:27:08 - CargaArchivos - Starting entry [Es WPL?]
2020/07/24 19:27:08 - CargaArchivos - exec(2, 0, Es WPL?.0)
2020/07/24 19:27:08 - Es GPL? - Starting job entry
2020/07/24 19:27:08 - Es GPL? - Value to evaluate is Fasttrack
2020/07/24 19:27:08 - CargaArchivos - Starting entry [Es Producto Servicio?]
2020/07/24 19:27:08 - CargaArchivos - exec(3, 0, Es Producto Servicio?.0)
2020/07/24 19:27:08 - Es GPL? - Starting job entry
2020/07/24 19:27:08 - Es GPL? - Value to evaluate is Fasttrack
2020/07/24 19:27:08 - CargaArchivos - Starting entry [Es Fasttrack?]
2020/07/24 19:27:08 - CargaArchivos - exec(4, 0, Es Fasttrack?.0)
2020/07/24 19:27:08 - Es GPL? - Starting job entry
2020/07/24 19:27:08 - Es GPL? - Value to evaluate is Fasttrack
2020/07/24 19:27:08 - CargaArchivos - Starting entry [Carga Fasttrack TMP]
2020/07/24 19:27:08 - CargaArchivos - exec(5, 0, Carga Fasttrack TMP.0)
2020/07/24 19:27:08 - Carga Fasttrack TMP - Starting job entry
2020/07/24 19:27:08 - Carga Fasttrack TMP - Opening transformation: [file:///home/admin_tecno/transformaciones/cargaFasttrackv3.ktr]
2020/07/24 19:27:08 - Carga Fasttrack TMP - Loading transformation from XML file [file:///home/admin_tecno/transformaciones/cargaFasttrackv3.ktr]
2020/07/24 19:27:08 - Carga Fasttrack TMP - Starting transformation...(file=${Internal.Job.Filename.Directory}/cargaFasttrackv3.ktr, name=Carga Fasttrack TMP, repinfo=null)
2020/07/24 19:27:08 - cargaFasttrackv3 - Transformation is pre-loaded.
2020/07/24 19:27:08 - cargaFasttrackv3 - Dispatching started for transformation [cargaFasttrackv3]
2020/07/24 19:27:08 - cargaFasttrackv3 - Nr of arguments detected:4 
2020/07/24 19:27:08 - cargaFasttrackv3 - This is not a replay transformation
2020/07/24 19:27:08 - cargaFasttrackv3 - I found 2 different steps to launch.
2020/07/24 19:27:08 - cargaFasttrackv3 - Allocating rowsets...
2020/07/24 19:27:08 - cargaFasttrackv3 -  Allocating rowsets for step 0 --> Microsoft Excel Input
2020/07/24 19:27:08 - cargaFasttrackv3 -   prevcopies = 1, nextcopies=1
2020/07/24 19:27:08 - cargaFasttrackv3 - Transformation allocated new rowset [Microsoft Excel Input.0 - Table output.0]
2020/07/24 19:27:08 - cargaFasttrackv3 -  Allocated 1 rowsets for step 0 --> Microsoft Excel Input  
2020/07/24 19:27:08 - cargaFasttrackv3 -  Allocating rowsets for step 1 --> Table output
2020/07/24 19:27:08 - cargaFasttrackv3 -  Allocated 1 rowsets for step 1 --> Table output  
2020/07/24 19:27:08 - cargaFasttrackv3 - Allocating Steps & StepData...
2020/07/24 19:27:08 - cargaFasttrackv3 -  Transformation is about to allocate step [Microsoft Excel Input] of type [ExcelInput]
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Starting allocation of buffers & new threads...
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Step info: nrinput=0 nroutput=1
2020/07/24 19:27:08 - Microsoft Excel Input.0 - output rel. is  1:1
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Found output rowset [Microsoft Excel Input.0 - Table output.0]
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Finished dispatching
2020/07/24 19:27:08 - cargaFasttrackv3 -  Transformation has allocated a new step: [Microsoft Excel Input].0
2020/07/24 19:27:08 - cargaFasttrackv3 -  Transformation is about to allocate step [Table output] of type [TableOutput]
2020/07/24 19:27:08 - Table output.0 - distribution activated
2020/07/24 19:27:08 - Table output.0 - Starting allocation of buffers & new threads...
2020/07/24 19:27:08 - Table output.0 - Step info: nrinput=1 nroutput=0
2020/07/24 19:27:08 - Table output.0 - Got previous step from [Table output] #0 --> Microsoft Excel Input
2020/07/24 19:27:08 - Table output.0 - input rel is 1:1
2020/07/24 19:27:08 - Table output.0 - Found input rowset [Microsoft Excel Input.0 - Table output.0]
2020/07/24 19:27:08 - Table output.0 - Finished dispatching
2020/07/24 19:27:08 - cargaFasttrackv3 -  Transformation has allocated a new step: [Table output].0
2020/07/24 19:27:08 - cargaFasttrackv3 - This transformation can be replayed with replay date: 2020/07/24 19:27:08
2020/07/24 19:27:08 - cargaFasttrackv3 - Initialising 2 steps...
2020/07/24 19:27:08 - Table output.0 - Running on slave server #0/1.
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Running on slave server #0/1.
2020/07/24 19:27:08 - localPostgre - New database connection defined
2020/07/24 19:27:08 - localPostgre - Connected to database.
2020/07/24 19:27:08 - Table output.0 - Connected to database [localPostgre] (commit=1000)
2020/07/24 19:27:08 - localPostgre - Auto commit off
2020/07/24 19:27:08 - cargaFasttrackv3 - Step [Microsoft Excel Input.0] initialized flawlessly.
2020/07/24 19:27:08 - cargaFasttrackv3 - Step [Table output.0] initialized flawlessly.
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Starting to run...
2020/07/24 19:27:08 - cargaFasttrackv3 - Transformation has allocated 2 threads and 1 rowsets.
2020/07/24 19:27:08 - Table output.0 - Starting to run...
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Opening openFile #0 : /var/www/informes/datos/fasttrack/Fast
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error processing row from Excel file [/var/www/informes/datos/fasttrack/Fast] : org.pentaho.di.core.exception.KettleException: 
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : java.io.IOException: Stream closed
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Stream closed
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleException: 
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : java.io.IOException: Stream closed
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Stream closed
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:45)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:36)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:601)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:469)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.lang.Thread.run(Thread.java:701)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: java.io.IOException: Stream closed
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.io.BufferedInputStream.getBufIfOpen(BufferedInputStream.java:162)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.io.BufferedInputStream.reset(BufferedInputStream.java:431)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.apache.poi.poifs.filesystem.POIFSFileSystem.hasPOIFSHeader(POIFSFileSystem.java:225)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:69)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:43)
2020/07/24 19:27:08 - Microsoft Excel Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	... 5 more
2020/07/24 19:27:08 - Microsoft Excel Input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
2020/07/24 19:27:08 - cargaFasttrackv3 - cargaFasttrackv3
2020/07/24 19:27:08 - cargaFasttrackv3 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
2020/07/24 19:27:08 - cargaFasttrackv3 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
2020/07/24 19:27:08 - cargaFasttrackv3 - cargaFasttrackv3
2020/07/24 19:27:08 - localPostgre - Connection to database closed!
2020/07/24 19:27:08 - Table output.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2020/07/24 19:27:08 - CargaArchivos - Starting entry [Aviso error de formato]
2020/07/24 19:27:08 - CargaArchivos - exec(6, 0, Aviso error de formato.0)
2020/07/24 19:27:08 - Es GPL? - Starting job entry
2020/07/24 19:27:08 - localPostgre - New database connection defined
2020/07/24 19:27:08 - localPostgre - Connected to database.
2020/07/24 19:27:08 - Es GPL? - Running SQL :update tipo_dato set validado = false, ingresado = false,
2020/07/24 19:27:08 - Es GPL? - observacion = 'Archivo presenta problemas en su contenido o en el formato, favor sirvase a corregir e intente nuevamente' where lower(nombre) = 'fasttrack';
2020/07/24 19:27:08 - localPostgre - launch DDL statement: 
2020/07/24 19:27:08 - localPostgre - update tipo_dato set validado = false, ingresado = false,
2020/07/24 19:27:08 - localPostgre - observacion = 'Archivo presenta problemas en su contenido o en el formato, favor sirvase a corregir e intente nuevamente' where lower(nombre) = 'fasttrack'
2020/07/24 19:27:08 - localPostgre - 1 statement executed
2020/07/24 19:27:08 - localPostgre - Connection to database closed!
2020/07/24 19:27:08 - CargaArchivos - Finished job entry [Aviso error de formato] (result=[true])
2020/07/24 19:27:08 - CargaArchivos - Finished job entry [Carga Fasttrack TMP] (result=[true])
2020/07/24 19:27:08 - CargaArchivos - Finished job entry [Es Fasttrack?] (result=[true])
2020/07/24 19:27:08 - CargaArchivos - Finished job entry [Es Producto Servicio?] (result=[true])
2020/07/24 19:27:08 - CargaArchivos - Finished job entry [Es WPL?] (result=[true])
2020/07/24 19:27:08 - CargaArchivos - Finished job entry [Es GPL?] (result=[true])
2020/07/24 19:27:08 - CargaArchivos - Job execution finished