2020/11/20 10:37:57 - Kitchen - Logging is at level : Detailed logging
2020/11/20 10:37:57 - Kitchen - Start of run.
2020/11/20 10:37:57 - CargaArchivos - Start of job execution
2020/11/20 10:37:57 - CargaArchivos - exec(0, 0, START.0)
2020/11/20 10:37:57 - START - Starting job entry
2020/11/20 10:37:57 - CargaArchivos - Starting entry [Es GPL?]
2020/11/20 10:37:57 - CargaArchivos - exec(1, 0, Es GPL?.0)
2020/11/20 10:37:57 - Es GPL? - Starting job entry
2020/11/20 10:37:57 - Es GPL? - Value to evaluate is Fasttrack
2020/11/20 10:37:57 - CargaArchivos - Starting entry [Es WPL?]
2020/11/20 10:37:57 - CargaArchivos - exec(2, 0, Es WPL?.0)
2020/11/20 10:37:57 - Es GPL? - Starting job entry
2020/11/20 10:37:57 - Es GPL? - Value to evaluate is Fasttrack
2020/11/20 10:37:57 - CargaArchivos - Starting entry [Es Producto Servicio?]
2020/11/20 10:37:57 - CargaArchivos - exec(3, 0, Es Producto Servicio?.0)
2020/11/20 10:37:57 - Es GPL? - Starting job entry
2020/11/20 10:37:57 - Es GPL? - Value to evaluate is Fasttrack
2020/11/20 10:37:57 - CargaArchivos - Starting entry [Es Fasttrack?]
2020/11/20 10:37:57 - CargaArchivos - exec(4, 0, Es Fasttrack?.0)
2020/11/20 10:37:57 - Es GPL? - Starting job entry
2020/11/20 10:37:57 - Es GPL? - Value to evaluate is Fasttrack
2020/11/20 10:37:57 - CargaArchivos - Starting entry [Carga Fasttrack TMP]
2020/11/20 10:37:57 - CargaArchivos - exec(5, 0, Carga Fasttrack TMP.0)
2020/11/20 10:37:57 - Carga Fasttrack TMP - Starting job entry
2020/11/20 10:37:57 - Carga Fasttrack TMP - Opening transformation: [file:///home/admin_tecno/transformaciones/cargaFasttrackv3.ktr]
2020/11/20 10:37:57 - Carga Fasttrack TMP - Loading transformation from XML file [file:///home/admin_tecno/transformaciones/cargaFasttrackv3.ktr]
2020/11/20 10:37:57 - Carga Fasttrack TMP - Starting transformation...(file=${Internal.Job.Filename.Directory}/cargaFasttrackv3.ktr, name=Carga Fasttrack TMP, repinfo=null)
2020/11/20 10:37:57 - cargaFasttrackv3 - Transformation is pre-loaded.
2020/11/20 10:37:57 - cargaFasttrackv3 - Dispatching started for transformation [cargaFasttrackv3]
2020/11/20 10:37:57 - cargaFasttrackv3 - Nr of arguments detected:0 
2020/11/20 10:37:57 - cargaFasttrackv3 - This is not a replay transformation
2020/11/20 10:37:57 - cargaFasttrackv3 - I found 2 different steps to launch.
2020/11/20 10:37:57 - cargaFasttrackv3 - Allocating rowsets...
2020/11/20 10:37:57 - cargaFasttrackv3 -  Allocating rowsets for step 0 --> Microsoft Excel Input
2020/11/20 10:37:57 - cargaFasttrackv3 -   prevcopies = 1, nextcopies=1
2020/11/20 10:37:57 - cargaFasttrackv3 - Transformation allocated new rowset [Microsoft Excel Input.0 - Table output.0]
2020/11/20 10:37:57 - cargaFasttrackv3 -  Allocated 1 rowsets for step 0 --> Microsoft Excel Input  
2020/11/20 10:37:57 - cargaFasttrackv3 -  Allocating rowsets for step 1 --> Table output
2020/11/20 10:37:57 - cargaFasttrackv3 -  Allocated 1 rowsets for step 1 --> Table output  
2020/11/20 10:37:57 - cargaFasttrackv3 - Allocating Steps & StepData...
2020/11/20 10:37:57 - cargaFasttrackv3 -  Transformation is about to allocate step [Microsoft Excel Input] of type [ExcelInput]
2020/11/20 10:37:57 - Microsoft Excel Input.0 - Starting allocation of buffers & new threads...
2020/11/20 10:37:57 - Microsoft Excel Input.0 - Step info: nrinput=0 nroutput=1
2020/11/20 10:37:57 - Microsoft Excel Input.0 - output rel. is  1:1
2020/11/20 10:37:57 - Microsoft Excel Input.0 - Found output rowset [Microsoft Excel Input.0 - Table output.0]
2020/11/20 10:37:57 - Microsoft Excel Input.0 - Finished dispatching
2020/11/20 10:37:57 - cargaFasttrackv3 -  Transformation has allocated a new step: [Microsoft Excel Input].0
2020/11/20 10:37:57 - cargaFasttrackv3 -  Transformation is about to allocate step [Table output] of type [TableOutput]
2020/11/20 10:37:57 - Table output.0 - distribution activated
2020/11/20 10:37:57 - Table output.0 - Starting allocation of buffers & new threads...
2020/11/20 10:37:57 - Table output.0 - Step info: nrinput=1 nroutput=0
2020/11/20 10:37:57 - Table output.0 - Got previous step from [Table output] #0 --> Microsoft Excel Input
2020/11/20 10:37:57 - Table output.0 - input rel is 1:1
2020/11/20 10:37:57 - Table output.0 - Found input rowset [Microsoft Excel Input.0 - Table output.0]
2020/11/20 10:37:57 - Table output.0 - Finished dispatching
2020/11/20 10:37:57 - cargaFasttrackv3 -  Transformation has allocated a new step: [Table output].0
2020/11/20 10:37:57 - cargaFasttrackv3 - This transformation can be replayed with replay date: 2020/11/20 10:37:57
2020/11/20 10:37:57 - cargaFasttrackv3 - Initialising 2 steps...
2020/11/20 10:37:57 - Microsoft Excel Input.0 - Running on slave server #0/1.
2020/11/20 10:37:57 - Table output.0 - Running on slave server #0/1.
2020/11/20 10:37:57 - localPostgre - New database connection defined
2020/11/20 10:37:58 - localPostgre - Connected to database.
2020/11/20 10:37:58 - Table output.0 - Connected to database [localPostgre] (commit=1000)
2020/11/20 10:37:58 - localPostgre - Auto commit off
2020/11/20 10:37:58 - cargaFasttrackv3 - Step [Microsoft Excel Input.0] initialized flawlessly.
2020/11/20 10:37:58 - cargaFasttrackv3 - Step [Table output.0] initialized flawlessly.
2020/11/20 10:37:58 - cargaFasttrackv3 - Transformation has allocated 2 threads and 1 rowsets.
2020/11/20 10:37:58 - Table output.0 - Starting to run...
2020/11/20 10:37:58 - Microsoft Excel Input.0 - Starting to run...
2020/11/20 10:37:58 - Microsoft Excel Input.0 - Opening openFile #0 : /var/www/informes/datos/fasttrack/cotizadorQ2FY21V2.xls
2020/11/20 10:37:58 - Table output.0 - Prepared statement : INSERT INTO "public".fastrack_tmp (partnumber, porcendcto, fechainicio, fechafin) VALUES ( ?,  ?,  ?,  ?)
2020/11/20 10:37:58 - Microsoft Excel Input.0 - No more files to be processed! (1 files done)
2020/11/20 10:37:58 - Microsoft Excel Input.0 - Finished processing (I=968, O=0, R=0, W=968, U=0, E=0)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unexpected batch update error committing the database connection.
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException: 
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error updating batch
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Batch entry 616 INSERT INTO "public".fastrack_tmp (partnumber, porcendcto, fechainicio, fechafin) VALUES ( 'CON-3SNT-AIRAP15I',  ' 78.635268817',  '2020/10/26 00:00:00.000',  '2021/01/23 00:00:00.000') was aborted.  Call getNextException to see the cause.
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1503)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:658)
2020/11/20 10:37:58 - Table output.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:79)
2020/11/20 10:37:58 - Table output.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/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: java.sql.BatchUpdateException: Batch entry 616 INSERT INTO "public".fastrack_tmp (partnumber, porcendcto, fechainicio, fechafin) VALUES ( 'CON-3SNT-AIRAP15I',  ' 78.635268817',  '2020/10/26 00:00:00.000',  '2021/01/23 00:00:00.000') was aborted.  Call getNextException to see the cause.
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2586)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:348)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1811)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1065)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:398)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2725)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1486)
2020/11/20 10:37:58 - Table output.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	... 3 more
2020/11/20 10:37:58 - cargaFasttrackv3 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
2020/11/20 10:37:58 - cargaFasttrackv3 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Errors detected!
2020/11/20 10:37:58 - localPostgre - Connection to database closed!
2020/11/20 10:37:58 - Table output.0 - Finished processing (I=0, O=0, R=968, W=0, U=0, E=1)
2020/11/20 10:37:58 - cargaFasttrackv3 - cargaFasttrackv3
2020/11/20 10:37:58 - cargaFasttrackv3 - cargaFasttrackv3
2020/11/20 10:37:58 - CargaArchivos - Starting entry [Aviso error de formato]
2020/11/20 10:37:58 - CargaArchivos - exec(6, 0, Aviso error de formato.0)
2020/11/20 10:37:58 - Es GPL? - Starting job entry
2020/11/20 10:37:58 - localPostgre - New database connection defined
2020/11/20 10:37:58 - localPostgre - Connected to database.
2020/11/20 10:37:58 - Es GPL? - Running SQL :update tipo_dato set validado = false, ingresado = false,
2020/11/20 10:37:58 - 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/11/20 10:37:58 - localPostgre - launch DDL statement: 
2020/11/20 10:37:58 - localPostgre - update tipo_dato set validado = false, ingresado = false,
2020/11/20 10:37:58 - localPostgre - observacion = 'Archivo presenta problemas en su contenido o en el formato, favor sirvase a corregir e intente nuevamente' where lower(nombre) = 'fasttrack'
2020/11/20 10:37:58 - localPostgre - 1 statement executed
2020/11/20 10:37:58 - localPostgre - Connection to database closed!
2020/11/20 10:37:58 - CargaArchivos - Finished job entry [Aviso error de formato] (result=[true])
2020/11/20 10:37:58 - CargaArchivos - Finished job entry [Carga Fasttrack TMP] (result=[true])
2020/11/20 10:37:58 - CargaArchivos - Finished job entry [Es Fasttrack?] (result=[true])
2020/11/20 10:37:58 - CargaArchivos - Finished job entry [Es Producto Servicio?] (result=[true])
2020/11/20 10:37:58 - CargaArchivos - Finished job entry [Es WPL?] (result=[true])
2020/11/20 10:37:58 - CargaArchivos - Finished job entry [Es GPL?] (result=[true])
2020/11/20 10:37:58 - CargaArchivos - Job execution finished