Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Error: IndexOutOfBoundsException

  1. #1

    Default Error: IndexOutOfBoundsException

    I'm receiving the following error during my Kettle transformation:
    TRIM.0 - java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

    I have a datafile that only contains 108 rows but has 855 characters in each.
    I noticed that when I view my datafile in Notepad it looks normal but when reading it through TEXT FILE INPUT it shows a blank row between each record.
    Would this cause the exception/error above ?
    If so how can I specify the proper end-of-line in my TEXT FILE INPUT ?

    Another note....every time I launch the transformation it gives me a different record count in my TEXT FILE.


  2. #2
    Join Date
    May 2006


    Transformation and a piece of anonymized input text?


  3. #3

    Default files attached

    Change fielname ADM.txt to ADM.dat or change name in Kettle transformation.
    Attached Files Attached Files

  4. #4
    Join Date
    May 2006


    And version of Kettle? 2.5? If I run it in 3.1(to be M1) I get:
    -TRIM.0 - java.lang.IllegalStateException: Calling Context.exit without previous Context.enter
    at org.mozilla.javascript.Context.exit(
    at org.mozilla.javascript.Context.exit(
    at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.dispose(
    at org.pentaho.di.trans.step.BaseStep.runStepThread(

    I guess it has something to do with how you use the variables in the javascript step. It's pretty unconventional... I'll check tomorrow, it's getting late here... for fun try the trimcut step at


  5. #5

    Default modified with same error

    Using Kettle 2.5

    I removed the JavaScript for trimming and specified the trim in the Text File Input step (didn't see that function there initially), hopefully this is more conventional

    I basically still get the same error (see attached doc).

    Should I upgrade to 3.0 ?
    Attached Files Attached Files

  6. #6

    Default Upgraded to 3.0.1

    Problem went away after upgrading to is good !

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.