Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Oracle commit size error

  1. #1
    Join Date
    Jan 2014
    Posts
    25

    Default Oracle commit size error

    Trying to load an Oracle table. There are over 70k records. The commit sizes tried are 1000, 5000, 10000, 20000.The table output step throws an error at every second commit, i.e. when the commit size is 1000, error is thrown at committing the second batch ( the commit at 2000 rows ). Error says " Unexpected error inserting row ". Is this a database setting issue. Is there a setting in PDI to solve the issue.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Without seeing the full error, there's little that we can tell you.
    "Unexpected error inserting row" is a pretty generic error, and there should be more information available if you turn the log level up.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3
    Join Date
    Jan 2014
    Posts
    25

    Default

    The error thrown is given below. There are 119 columns in all. The transformation has 4 table output steps. Error happens at 1 or 2 table output steps randomnly.

    table1.0 - Finished processing (I=3544, O=0, R=1, W=17720, U=0, E=0)
    2014/01/16 13:43:40 - table2.0 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : Because of an error, this step can't continue:
    2014/01/16 13:43:40 - table2.0 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2014/01/16 13:43:40 - table2.0 - Error inserting row into table [table2] with values: [2000], [100001], [FOR_IMPORT], [12002], [Organization], [N], [N], ...........<< more column values >> ........, [2014-01-16 13:43:38.000000000], [0], [CORP], [12002], [476], [PROCESSED]
    2014/01/16 13:43:40 - table2.0 -
    2014/01/16 13:43:40 - table2.0 - Unexpected error inserting row
    2014/01/16 13:43:40 - table2.0 - -32033
    2014/01/16 13:43:40 - table2.0 -
    2014/01/16 13:43:40 - table2.0 -
    2014/01/16 13:43:40 - table2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:445)
    2014/01/16 13:43:40 - table2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128)
    2014/01/16 13:43:40 - table2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2014/01/16 13:43:40 - table2.0 - at java.lang.Thread.run(Thread.java:724)
    2014/01/16 13:43:40 - table2.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2014/01/16 13:43:40 - table2.0 - Unexpected error inserting row
    2014/01/16 13:43:40 - table2.0 - -32033
    2014/01/16 13:43:40 - table2.0 -
    2014/01/16 13:43:40 - table2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:341)
    2014/01/16 13:43:40 - table2.0 - ... 3 more
    2014/01/16 13:43:40 - table2.0 - Caused by: java.lang.ArrayIndexOutOfBoundsException: -32033
    2014/01/16 13:43:40 - table2.0 - at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677)
    2014/01/16 13:43:40 - table2.0 - at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9255)
    2014/01/16 13:43:40 - table2.0 - at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)
    2014/01/16 13:43:40 - table2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:315)
    2014/01/16 13:43:40 - table2.0 - ... 3 more

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by nivinjacob View Post
    2014/01/16 13:43:40 - table2.0 - Caused by: java.lang.ArrayIndexOutOfBoundsException: -32033
    2014/01/16 13:43:40 - table2.0 - at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677)
    And this should help you figure out what is going on....
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  5. #5
    Join Date
    Jan 2014
    Posts
    25

    Default

    Changed the jdbc driver from ojdbc5.jar to ojdbc6.jar and the issue was resolved.

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.