Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Error Table output index out of bonds

  1. #1

    Default Error Table output index out of bonds

    Hi All ,

    I got an error like this in my transformation, I have a table input and table output to move a data, what should I do to resolve that error?
    Help me please..

    ===================================================

    2011/01/19 15:22:21 - Table output.0 - Starting to run...
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unexpected error :
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.ArrayIndexOutOfBoundsException: -1
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : oracle.jdbc.driver.DateTimeCommonAccessor.computeJulianDay(DateTimeCommonAccessor.java:419)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : oracle.jdbc.driver.DateTimeCommonAccessor.getMillis(DateTimeCommonAccessor.java:458)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : oracle.jdbc.driver.DateAccessor.getTimestamp(DateAccessor.java:123)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:796)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.database.Database.getRow(Database.java:2764)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.database.Database.getRow(Database.java:2699)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.database.Database.getRow(Database.java:2673)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:245)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:130)
    2011/01/19 15:22:21 - Table input.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:40)
    2011/01/19 15:22:21 - Table input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Thread.java:619)

  2. #2
    Join Date
    Nov 2008
    Posts
    143

    Default

    Given the hints (*sigh*), I'd say you're trying to access some column in the table input as a date field...
    May be you're using a mask to parse the date...
    And it is giving some values that cannot be placed into a valid date value (let's say february 30th).
    And you're using oracle!

    Found some people saying this might be a problem with the ojdbc driver version 10.1.0.4.
    What version of Oracle client/driver/db are you using? What URL are you using in your connection? The link has some hints on possible errors.

    Try switching your log level to "row level" and see if it shows which values are being read at the time the problem occurs.

    It also wouldn't hurt to know your PDI version, as well as what the table input configs you're using.

    Cheers,

    Renato
    Last edited by renatopb; 01-19-2011 at 07:35 AM.

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.