Hitachi Vantara Pentaho Community Forums
Results 1 to 19 of 19

Thread: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

  1. #1
    Join Date
    Mar 2006
    Posts
    683

    Default ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Attachment: transform.gif While trying to update my fact tables I got this here weird error.
    ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22
    while using a table look up on kettle 2.2.2 I'm going to try the kettle 2.3 jar to see if that might help things. I'll report back once I find out the results.


    If in the mean time someone could possible suggest what problem I might have caused. That would be great.



    Thanks,



    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

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

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Nic,

    See if you're sending 2 or more streams to the same step and then check if the 2 streams contain the same fields in the same order.

    HTH,
    Matt

  3. #3
    Join Date
    Mar 2006
    Posts
    683

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    well they was only two that were out of order. fixed that and we'll see, next time I'll be sure to double or triple check the order.

    which brings another question instead of just having two streams would it be better/easier to just brake it up into 2 transactions?

    also I tried the kettle 2.3, which appeared to run faster but still the same.

    Matt probably hit the nail on head since it turned out I had two out of order.

    Thanks for the help matt as well as for the awesomely quick response.

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  4. #4
    Join Date
    Mar 2006
    Posts
    683

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    UPDATE:
    after making sure they were the same name and same order after it failed agian. Though it did get through more of it though.

    I just went ahead and broke it up into two different transactions.

    I hope that will wield better results.

    Nic

    BTW: I think once I figure out all the lil quarks in kettle and not try to do too much in one transaction I'll have even more apperication for it.
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  5. #5
    Join Date
    Mar 2006
    Posts
    683

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    uhmm...
    after braking them up into two transactions.

    I'm still getting the same error, but it looks a bit differently now.
    java.lang.IndexOutOfBoundsException: Index: 22, Size: 22.
    it's puking on a step where it looks up a FK but it's not the same spot.

    Any other suggestions?

    currently isn't one stream for one db so I'm running two different transactions now not two streams into one step.

    Thanks,

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

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

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Well, rows with varying numbers of fields are not allowed either ;-) I suggest doing a preview right before the failing step.
    Or send me a piece of XML, I'll look at it tomorrow. For the rest of the night, I'm gone though.

    Cheers,

    Matt

  7. #7
    Join Date
    Mar 2006
    Posts
    683

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    uhmm I do a preview of 100 rows and things work out fine if I goto far beyond that then it heaps and disappears. I'll see what I might be able to figure out with the info I can find.

    If I still can't figure it out by this evening I'll toss up the lastest version for you.

    Thanks agian for the help

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  8. #8
    Join Date
    Mar 2006
    Posts
    683

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    I ended up revamping my whole transaction and things seem to be really cooking with gas.

    Thanks agian for the help matt.

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

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

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Glad to hear this ;-)

  10. #10
    Join Date
    Mar 2006
    Posts
    683

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    as much as I hate to revisit this thread. I'm getting that indexoutofbouns exception now with one of my transactions after about 159368 lines. the funny thing is that it worked for just a "week" time frame now that I'm trying to do it over a year time frame it's tossing that. None of my other transactions had a problem, the ones use the populate the dimensions as well as the other stores info. I'm currently trying the lastest build to see if that might cause a problem.

    Will report back.

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  11. #11
    Join Date
    Mar 2006
    Posts
    683

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    after getting the latest kettle.jar. I still got the exception. but this time it made it through 237694 lines. So I'm going to go back and take a nother look at my transaction in spoon to hope to see the issue, I might just brake it up into two 6 month instead on just 1 for the year.

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  12. #12
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Hi,

    did you find a solution to this problem? I've got the same Problem and just can't fix it. Currently I'm using Kettle 2.2.2 but I also tried Kettle 2.3.0 but this Version didn't even run.

    I tried to fix this error, cause this parts have been modified in 2.3.0 - so I changed some methods of the source in Class Value and Condition like in 2.3.0. This has been mentioned in another post. But without luck....

    Error is in Step Filter Row, wich I use to Filter NULL or <= 0 Values:
    2006/05/10 15:33:54 - Filter BannerNumber NULL Value.0 - ERROR : Unexpected error in &#39;before evaluate condition&#39; : java.lang.RuntimeException: Unexpected error evaluation condition [(
    BannerNumber IS NULL
    OR BannerNumber <= [ 0]
    )
    ] in part [Composite : get first] for row: [requesttime_timestamp= 020060110]
    java.lang.RuntimeException: Unexpected error evaluation condition [ BannerNumber IS NULL
    ] in part [Atomic : get fieldnrs left field] for row: [requesttime_timestamp= 020060110]
    java.lang.IndexOutOfBoundsException: Index: 8, Size: 1

    If there is a workaround of something I can do please let me know

    greetings - Jan

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

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    >Currently I&#39;m using Kettle 2.2.2 but I also tried Kettle 2.3.0 but this Version didn&#39;t even run.

    What are you talking about???

    Anyway, the error is most of the time caused by mixing rows with different length (or fields in another order). Needless to say this is not allowed.

    Matt

  14. #14
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Attachment: transform.gif Hi,

    first of all Kettle is awesome

    The Problem with 2.3.0 is as follows:
    I created my transformation with 2.2.2 .
    My Computer is configured for German time zone and keyboard and so on. 2.2.2 started in English (think there had not been a German translation available for this version). I build my translation completely in English. Now starting 2.3.0 it recognizes the German time zone.
    At startup spoon connects to the repository but already mentions in the console, that it cant find log files and a few other things. The German GUI opens and Spoon tries to load my last Transformation, which had been in English. But I it can’t find the plugins cause there are all named English. 2.3.0 only accepts German spelled Plugins (that’s what the error message sounds like). So far… I was not able to load my Transformation. ….btw Log Window tells continuously a NullPointer.
    I closed 2.3.0 and changed my regional settings to English. Started Spoon 2.3.0 again, and wow – it starts in English and can read my Translation. Unfortunately the logging is still not working and so I can’t check errors in the transformation.
    So far …I had to give up with 2.3.0

    The IndexOutOfBoundsException:
    I attached a part of the transformation.
    Did I something which is not allowed?
    Error occurs at the NULL Value Filter or at Read PlacementData or at Rename PlacementData.
    I’m not able to reproduce the error. Sometimes the transformation runs up to 20000 (which is far to less) and sometimes it stops at 3000 (same query as basis).
    I’m new to Kettle, if this, what I’ve done is a bad practice please help me out

    Jan

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

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    First of all, the problem with the log was fixed earlier this week. So try the latest version.
    Second, if you change language, it should not have any effect on the loading of plugins. I&#39;ll look into that tomorrow.
    Thirdly, the engine for the execution of a transformation did not change, although plenty of bugs were fixed in a lot of steps.

    Finally, by trying to do everything in one big transformation, you&#39;re making it very hard for yourself to debug anything. :-)
    Just make sure you&#39;re not mixing rows of different length or with fields in a different order, OK?

    If you have anything to share with us besides a gif, feel free to file a bug report once in a while.

    All the best and thanks a lot for the feedback!

    Matt

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

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    OK, I found the problem with the localisation and step loading.
    It&#39;s caused by Tom Quin who translated a bit too much. The keys for a step called Text File Input is TextFileInput. That key should never change, only the description and long description. I&#39;m changing this, it should be finished in an hour or so.

    Thanks again for finding this for us!

    Matt

  17. #17
    Join Date
    Jul 2006
    Posts
    1

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Hi,

    Not sure whether we are referring to the same problem. I am still encountering the IndexOutOfBoundsException in both Kettle-2.3.0 and Kettle-2.3.1 releases. This happens with Spoon. There are about 9000 records in the soure table for Spoon to populate into a target table. I uses Oracle Sequence to auto-generate the pkid of the target table. Spoon managed to insert an undeterministic number of rows from the source to the target before throwing the error message as followed,

    2006/07/06 19:51:05 - Party Master Table Input.0 - linenr 5000
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : Unexpected error in &#39;&#39; : java.lang.IndexOutOfBoundsException: Index: 16, Size: 8
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : java.lang.IndexOutOfBoundsException: Index: 16, Size: 8
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at java.util.ArrayList.RangeCheck(Unknown Source)
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at java.util.ArrayList.get(Unknown Source)
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.core.Row.getValue(Row.java:91)
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.core.Row.toString(Row.java:311)
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at java.lang.String.valueOf(Unknown Source)
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at java.lang.StringBuffer.append(Unknown Source)
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.trans.step.addsequence.AddSequence.processRow(AddSequence.java:122)
    2006/07/06 19:51:05 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.trans.step.addsequence.AddSequence.run(AddSequence.java:203)

    One interesting observation is that the above errors occurred for Logging Setting set to any level other than Row Level. If I set the loggin setting to RowLevel, however, Spoon will always able to insert all the 9000 records to the target. Why is it that setting the Logging Setting to Row Level could have such special effect? Any advise will be greatly appreciated.

    Regards
    Heng

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

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Do me a favor, run the transformation in "safe mode" and see what happens.

  19. #19
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: ERROR : java.lang.IndexOutOfBoundsException: Index: 31, Size: 22

    Hi, Matt

    Following is what Spoon throws after it processes 583 rows of source records under safe mode. Hope useful to you. This is run under ver 2.3.1.

    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Nr of arguments detected:10
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Safe mode is enabled for this transformation
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - This is not a replay transformation
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - I found 4 different steps to launch.
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocating rowsets...
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocating rowsets for step 0 --> Party Master Table Input
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - prevcopies = 1, nextcopies=1
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation allocated new rowset [Party Master Table Input.0 - PARTY_PKID_SEQ.0]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocated 1 rowsets for step 0 --> Party Master Table Input
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocating rowsets for step 1 --> PARTY_PKID_SEQ
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - prevcopies = 1, nextcopies=1
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation allocated new rowset [PARTY_PKID_SEQ.0 - Party Master Output Table Mapping.0]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocated 2 rowsets for step 1 --> PARTY_PKID_SEQ
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocating rowsets for step 2 --> Party Master Output Table Mapping
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - prevcopies = 1, nextcopies=1
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation allocated new rowset [Party Master Output Table Mapping.0 - Party Master Output Table.0]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocated 3 rowsets for step 2 --> Party Master Output Table Mapping
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocating rowsets for step 3 --> Party Master Output Table
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocated 3 rowsets for step 3 --> Party Master Output Table
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Allocating Steps & StepData...
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation is about to allocate step [Party Master Table Input] of type [TableInput]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step has nrcopies=1
    2006/07/07 08:28:32 - Party Master Table Input.0 - distribution activated
    2006/07/07 08:28:32 - Party Master Table Input.0 - Starting allocation of buffers & new threads...
    2006/07/07 08:28:32 - Party Master Table Input.0 - Step info: nrinput=0 nroutput=1
    2006/07/07 08:28:32 - Party Master Table Input.0 - output rel. is 1:1
    2006/07/07 08:28:32 - Party Master Table Input.0 - Found output rowset [Party Master Table Input.0 - PARTY_PKID_SEQ.0]
    2006/07/07 08:28:32 - Party Master Table Input.0 - Finished dispatching
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [Party Master Table Input.0 (Thread-129)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation has allocated a new step: [Party Master Table Input].0
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation is about to allocate step [PARTY_PKID_SEQ] of type [Sequence]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step has nrcopies=1
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - distribution activated
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Starting allocation of buffers & new threads...
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Step info: nrinput=1 nroutput=1
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Got previous step from [PARTY_PKID_SEQ] #0 --> Party Master Table Input
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - input rel is 1:1
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Found input rowset [Party Master Table Input.0 - PARTY_PKID_SEQ.0]
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - output rel. is 1:1
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Found output rowset [PARTY_PKID_SEQ.0 - Party Master Output Table Mapping.0]
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Finished dispatching
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [PARTY_PKID_SEQ.0 (Thread-130)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation has allocated a new step: [PARTY_PKID_SEQ].0
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation is about to allocate step [Party Master Output Table Mapping] of type [SelectValues]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step has nrcopies=1
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - distribution activated
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - Starting allocation of buffers & new threads...
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - Step info: nrinput=1 nroutput=1
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - Got previous step from [Party Master Output Table Mapping] #0 --> PARTY_PKID_SEQ
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - input rel is 1:1
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - Found input rowset [PARTY_PKID_SEQ.0 - Party Master Output Table Mapping.0]
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - output rel. is 1:1
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - Found output rowset [Party Master Output Table Mapping.0 - Party Master Output Table.0]
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - Finished dispatching
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [Party Master Output Table Mapping.0 (Thread-131)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation has allocated a new step: [Party Master Output Table Mapping].0
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation is about to allocate step [Party Master Output Table] of type [TableOutput]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step has nrcopies=1
    2006/07/07 08:28:32 - Party Master Output Table.0 - distribution activated
    2006/07/07 08:28:32 - Party Master Output Table.0 - Starting allocation of buffers & new threads...
    2006/07/07 08:28:32 - Party Master Output Table.0 - Step info: nrinput=1 nroutput=0
    2006/07/07 08:28:32 - Party Master Output Table.0 - Got previous step from [Party Master Output Table] #0 --> Party Master Output Table Mapping
    2006/07/07 08:28:32 - Party Master Output Table.0 - input rel is 1:1
    2006/07/07 08:28:32 - Party Master Output Table.0 - Found input rowset [Party Master Output Table Mapping.0 - Party Master Output Table.0]
    2006/07/07 08:28:32 - Party Master Output Table.0 - Finished dispatching
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [Party Master Output Table.0 (Thread-132)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation has allocated a new step: [Party Master Output Table].0
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - This transformation can be replayed with replay date: 2006/07/07 08:28:32
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Initialising 4 steps...
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [init of Party Master Table Input.0 (Thread-133)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - abc - New database connection defined
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [init of PARTY_PKID_SEQ.0 (Thread-134)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - cde - New database connection defined
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [init of Party Master Output Table.0 (Thread-136)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - cde - New database connection defined
    2006/07/07 08:28:32 - LocalVariables - ---> Create new KettleVariables for thread [init of Party Master Output Table Mapping.0 (Thread-135)] for parent thread [Thread-128], same namespace? [true]
    2006/07/07 08:28:32 - LocalVariables - ---> Removing KettleVariables for top level thread [init of Party Master Output Table Mapping.0 (Thread-135)]
    2006/07/07 08:28:32 - LocalVariables - java.lang.Exception: Removed here!
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.core.LocalVariables.removeKettleVariables(LocalVariables.java:127)
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.trans.step.StepInitThread.run(StepInitThread.java:60)
    2006/07/07 08:28:32 - LocalVariables - at java.lang.Thread.run(Unknown Source)
    2006/07/07 08:28:32 - abc - Connected to database.
    2006/07/07 08:28:32 - abc - Auto commit off
    2006/07/07 08:28:32 - Party Master Table Input.0 - Connected to database...
    2006/07/07 08:28:32 - LocalVariables - ---> Removing KettleVariables for top level thread [init of Party Master Table Input.0 (Thread-133)]
    2006/07/07 08:28:32 - LocalVariables - java.lang.Exception: Removed here!
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.core.LocalVariables.removeKettleVariables(LocalVariables.java:127)
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.trans.step.StepInitThread.run(StepInitThread.java:60)
    2006/07/07 08:28:32 - LocalVariables - at java.lang.Thread.run(Unknown Source)
    2006/07/07 08:28:32 - cde - Connected to database.
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Connected to database...
    2006/07/07 08:28:32 - LocalVariables - ---> Removing KettleVariables for top level thread [init of PARTY_PKID_SEQ.0 (Thread-134)]
    2006/07/07 08:28:32 - LocalVariables - java.lang.Exception: Removed here!
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.core.LocalVariables.removeKettleVariables(LocalVariables.java:127)
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.trans.step.StepInitThread.run(StepInitThread.java:60)
    2006/07/07 08:28:32 - LocalVariables - at java.lang.Thread.run(Unknown Source)
    2006/07/07 08:28:32 - cde - Connected to database.
    2006/07/07 08:28:32 - Party Master Output Table.0 - Connected to database [ora901] (commit=100)
    2006/07/07 08:28:32 - cde - Auto commit off
    2006/07/07 08:28:32 - LocalVariables - ---> Removing KettleVariables for top level thread [init of Party Master Output Table.0 (Thread-136)]
    2006/07/07 08:28:32 - LocalVariables - java.lang.Exception: Removed here!
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.core.LocalVariables.removeKettleVariables(LocalVariables.java:127)
    2006/07/07 08:28:32 - LocalVariables - at be.ibridge.kettle.trans.step.StepInitThread.run(StepInitThread.java:60)
    2006/07/07 08:28:32 - LocalVariables - at java.lang.Thread.run(Unknown Source)
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step [Party Master Table Input.0] initialized flawlessly.
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step [PARTY_PKID_SEQ.0] initialized flawlessly.
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step [Party Master Output Table Mapping.0] initialized flawlessly.
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Step [Party Master Output Table.0] initialized flawlessly.
    2006/07/07 08:28:32 - Party Master Table Input.0 - Starting to run...
    2006/07/07 08:28:32 - be.ibridge.kettle.trans.Trans - Transformation has allocated 4 threads and 3 rowsets.
    2006/07/07 08:28:32 - PARTY_PKID_SEQ.0 - Starting to run...
    2006/07/07 08:28:32 - Party Master Output Table.0 - Starting to run...
    2006/07/07 08:28:32 - Party Master Output Table Mapping.0 - Starting to run...
    2006/07/07 08:28:32 - Party Master Output Table.0 - Prepared statement : INSERT INTO PARTY(PKID, PARTYID, PARTYSFIX, FULLNAME, LOCALNAME, CITY, COUNTRY, STATE) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : Unexpected error in &#39;&#39; : java.lang.IndexOutOfBoundsException: Index: 13, Size: 8
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : java.lang.IndexOutOfBoundsException: Index: 13, Size: 8
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at java.util.ArrayList.RangeCheck(Unknown Source)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at java.util.ArrayList.get(Unknown Source)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.core.Row.getValue(Row.java:91)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.core.Row.toString(Row.java:311)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at java.lang.String.valueOf(Unknown Source)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at java.lang.StringBuffer.append(Unknown Source)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.trans.step.addsequence.AddSequence.processRow(AddSequence.java:122)
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - ERROR : at be.ibridge.kettle.trans.step.addsequence.AddSequence.run(AddSequence.java:203)
    2006/07/07 08:28:33 - cde - Connection to database closed!
    2006/07/07 08:28:33 - PARTY_PKID_SEQ.0 - Finished processing (I=0, O=0, R=583, W=583, U=0, E=1
    2006/07/07 08:28:33 - be.ibridge.kettle.trans.Trans - ERROR : Errors detected!
    2006/07/07 08:28:33 - be.ibridge.kettle.trans.Trans - Looking at step: Party Master Table Input
    2006/07/07 08:28:33 - Party Master Table Input.0 - Stopped while putting a row on the buffer
    2006/07/07 08:28:33 - Party Master Table Input.0 - Finished reading query, closing connection.
    2006/07/07 08:28:33 - abc - Connection to database closed!
    2006/07/07 08:28:33 - Party Master Table Input.0 - Finished processing (I=1585, O=0, R=0, W=1583, U=0, E=0
    2006/07/07 08:28:33 - be.ibridge.kettle.trans.Trans - Looking at step: PARTY_PKID_SEQ
    2006/07/07 08:28:33 - be.ibridge.kettle.trans.Trans - Looking at step: Party Master Output Table Mapping
    2006/07/07 08:28:33 - Party Master Output Table Mapping.0 - Stopped looking for more rows.
    2006/07/07 08:28:33 - Party Master Output Table Mapping.0 - Signaling &#39;output done&#39; to 1 output rowsets.
    2006/07/07 08:28:33 - Party Master Output Table Mapping.0 - Finished processing (I=0, O=0, R=583, W=583, U=0, E=0
    2006/07/07 08:28:33 - Party Master Output Table.0 - Signaling &#39;output done&#39; to 0 output rowsets.
    2006/07/07 08:28:33 - cde - Connection to database closed!
    2006/07/07 08:28:33 - Party Master Output Table.0 - Finished processing (I=0, O=583, R=583, W=0, U=0, E=0
    2006/07/07 08:28:33 - be.ibridge.kettle.trans.Trans - Looking at step: Party Master Output Table
    2006/07/07 08:28:33 - Spoon - The transformation has finished!!

    Note: Even though the message is "The transformation has finished.", but the actual fact is that it is prematurely terminated.

    Regards
    Heng

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.