Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: org.pentaho.di.core.exception.KettleDatabaseBatchException

  1. #1

    Default org.pentaho.di.core.exception.KettleDatabaseBatchException

    Hi comunity,

    I´m running a job several times and at certain moment it stop becouse the following error occurs:

    Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected batch update error committing the database connection.
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error updating batch
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Batch entry 0 INSERT INTO viper_bi_dm.ar_hist (ent_pid, account_pid, cust_pid, ant_pid, due_pid, amount_left, date_pid, doc_pid, currency_pid, doc_age) VALUES ( 4678, 1231, 183, 1, 1, 0.9000000000, 20081226, 282458, 18, 0) was aborted. Call getNextException to see the cause.
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1403)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:611)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2918)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO viper_bi_dm.ar_hist (ent_pid, account_pid, cust_pid, ant_pid, due_pid, amount_left, date_pid, doc_pid, currency_pid, doc_age) VALUES ( 4678, 1231, 183, 1, 1, 0.9000000000, 20081226, 282458, 18, 0) was aborted. Call getNextException to see the cause.
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:403)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1387)
    2011/04/07 16:29:29 - Salida Tabla Ar_Hist.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more
    2011/04/07 16:29:29 - Update New Document - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errores detectados!
    2011/04/07 16:29:29 - Update New Document - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errores detectados!

    I don´t know what´s happend.
    Please anybody knows what´the problem?

    All the best,

    yosuan

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The easiest way to see the cause in that version is to turn off batch processing. It's probably a value error (too large, too much precision, whatever).

  3. #3

    Default

    Thank you Matt, Do you think that in a new version that error don´t happen?

    yosuan

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    I don't think the error itself is related to Kettle. However, it's possible you'll be seeing the exact error in a more recent version.

  5. #5

    Default

    Thanks a lot, I will try with a most recent version to see the exact error.

    yosuan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.