Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: String index out of range error

  1. #1

    Default String index out of range error

    This transformation goes along fine until a certain point. Any ideas? I'm attaching the screenshot of the error and the transformation itself.
    2008/06/25 13:08:20 - Spoon - Launching transformation [Transformation 2]...
    2008/06/25 13:08:20 - Spoon - Started the transformation execution.
    2008/06/25 13:08:20 - Transformation 2 - Dispatching started for transformation [Transformation 2]
    2008/06/25 13:08:26 - Spoon - Processing of transformation stopped.
    2008/06/25 13:08:44 - Spoon - Launching transformation [test5]...
    2008/06/25 13:08:44 - Spoon - Started the transformation execution.
    2008/06/25 13:08:44 - test5 - Dispatching started for transformation [test5]
    2008/06/25 13:08:46 - Spoon - The transformation has finished!!
    2008/06/25 13:10:45 - Spoon - Launching transformation [test5]...
    2008/06/25 13:10:45 - Spoon - Started the transformation execution.
    2008/06/25 13:10:45 - test5 - Dispatching started for transformation [test5]
    2008/06/25 13:10:46 - Spoon - The transformation has finished!!
    2008/06/25 13:12:35 - Spoon - Launching transformation [test5]...
    2008/06/25 13:12:35 - Spoon - Started the transformation execution.
    2008/06/25 13:12:35 - test5 - Dispatching started for transformation [test5]
    2008/06/25 13:12:37 - Spoon - The transformation has finished!!
    2008/06/25 13:13:24 - Spoon - Launching transformation [test5]...
    2008/06/25 13:13:24 - Spoon - Started the transformation execution.
    2008/06/25 13:13:24 - test5 - Dispatching started for transformation [test5]
    2008/06/25 13:22:48 - Spoon - The transformation has finished!!
    2008/06/25 14:13:51 - Spoon - Launching transformation [test5]...
    2008/06/25 14:13:51 - Spoon - Started the transformation execution.
    2008/06/25 14:13:51 - test5 - Dispatching started for transformation [test5]
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : Unexpected error :
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : org.pentaho.di.core.exception.KettleValueException:
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : Javascript error:
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : Wrapped java.lang.StringIndexOutOfBoundsException: String index out of range: 5 (script#3)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) :
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:443)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:738)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:798)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : Caused by: org.mozilla.javascript.WrappedException: Wrapped java.lang.StringIndexOutOfBoundsException: String index out of range: 5 (script#3)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1693)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:160)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:204)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.gen.c6._c0(script:3)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.gen.c6.call(script)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:340)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2758)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.gen.c6.call(script)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.gen.c6.exec(script)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:356)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : ... 2 more
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 5
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at java.lang.String.substring(Unknown Source)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.pentaho.di.compatibility.Value.substr(Value.java:2725)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at java.lang.reflect.Method.invoke(Unknown Source)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:145)
    2008/06/25 14:21:40 - Modified Java Script Value.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 04:30:04) : ... 11 more
    2008/06/25 14:21:40 - Spoon - The transformation has finished!!
    Attached Images Attached Images  
    Attached Files Attached Files

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Well.... try the same with v3.1-M2

    Regards,
    Sven

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.