Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Table Output issue

  1. #1
    Join Date
    Feb 2007
    Posts
    25

    Default Table Output issue

    My company is simply beta testing the Data Integrator to see if it is a product we can use to accomplish our ETL faster. If I can prove the concept then I'm thinking there is a legitimate possibility of purchasing support, but I'm running into an issue trying to insert rows of data into our Oracle database and I've searched high and far for a solution to no avail. Here is the error I'm getting:

    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : Unexpected batch update error committing the database connection.
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : Error updating batch
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : General error
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) :
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1402)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:565)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2706)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:634)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : Caused by: sun.jdbc.odbc.JdbcOdbcBatchUpdateException: General error
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at sun.jdbc.odbc.JdbcOdbcPreparedStatement.emulateExecuteBatch(Unknown Source)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeBatchUpdate(Unknown Source)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at sun.jdbc.odbc.JdbcOdbcStatement.executeBatch(Unknown Source)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1386)
    2009/04/14 10:01:49 - Table output.0 - ERROR (version 3.1.3, build 1 from 2009/04/13 11:28:15) : ... 3 more
    2009/04/14 10:01:49 - ddssadss - Connection to database closed!
    2009/04/14 10:01:49 - Table output.0 - Finished processing (I=0, O=0, R=1000, W=0, U=0, E=1)
    2009/04/14 10:01:49 - Spoon - The transformation has finished!!
    2009/04/14 10:01:49 - db21 - Transformation detected one or more steps with errors.
    2009/04/14 10:01:49 - db21 - Transformation is killing the other steps!

    It looks, on surface, to be an error with connection, but when I test the connection it is fine. When I test the step it is fine. Is there something I need to do on the Oracle side of things?

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    Before reaching the "Table Output" Step, you should check that:
    - every mandatory column (Oracle) is present in the incoming flow of data.
    - the name of the columns is exact the same as names in the incoming data.
    - the Step only receives columns that exists in the table.
    - the data types match between Kettle and Oracle (ie: You can't have a string for a date column)

    The usual way for doing this is to place a "Select Values" Step just before the "Table Output".

    good luck!

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

    Default

    Please, do get rid of ODBC, it slows things down and introduces another layer of bugs.

    To see the exact error, try to turn of batch processing.

  4. #4
    Join Date
    Feb 2007
    Posts
    25

    Default

    I'll try to get our jdbc connection settings and give that a shot.

  5. #5
    Join Date
    Feb 2007
    Posts
    25

    Default

    JDBC resolved my issue...Thanks Matt.

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.