La red del Business Intelligence
quiero realizar una transformacion de dbf a postgres y me tira un errror de insert, estuve mirando y no genera el insert com debeia ser
Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unexpected batch update error committing the database connection.
2010/12/12 21:54:20 - Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
2010/12/12 21:54:20 - Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error updating batch
2010/12/12 21:54:20 - Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Batch entry 16 INSERT INTO ticket (NUMERO, TIPO, FECHA, FECHA_SAL, OPERADOR, CLIENTE, NOM_CLI, PRODUCTO, DESC_PRO, TRANSPOR, NOM_TRAN, CONDUCTOR, PATENTE, PATENTAC, CAMPO1, CAMPO2, CAMPO3, CAMPO4, CAMPO5, CAMPO6, CAMPO7, CAMPO8, PESO_SAL, PESO_ENT, HORA_E, HORA_S, ANULADO, CANTI_UN, C_PESAD1, C_PESAD2) VALUES ( 000000001687, 02, 2010-12-01 00:00:00.000000 -03:00:00, 2010-12-01 00:00:00.000000 -03:00:00, 27.0, 2.0, RICARDO MALLOZZI, 2.0, RESIDUOS URBANOS, 3.0, RICARDO MALLOZZI S.A., CONT. ABIERTO, AME 182, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8840.0, 10220.0, 07:37, 07:52, NULL, 0.0, 1.0, 1.0) was aborted. Call getNextException to see the cause.
2010/12/12 21:54:20 - Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1459)
2010/12/12 21:54:20 - Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:625)
2010/12/12 21:54:20 - Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
2010/12/12 21:54:20 - Salida Tabla.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Unknown Source)
2010/12/12 21:54:20 - Salida Tabla.0 - Procesamiento finalizado (EN=0, SA=0, LE=341, ES=0, AC=0, ER=1)
2010/12/12 21:54:20 - Spoon - La transformación ha finalizado!!
gracias por su ayuda
Etiquetas:
Bienvenido a
Open Business Intelligence
© 2024 Creado por Emilio. Tecnología de