Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-10241

Text File Input step: Missing setting up the Position while working on fix file type throws StringIndexOutOfBoundsException on preview

    XMLWordPrintable

    Details

    • Story Points:
      3
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Follow up from DOC-1386:

      2. The Fields tab does not contain all the columns described
      The one particular that is missing is Position.
      Missing setting up the Position while working on fix file type for this step causes that the below error gets displayed on doing a preview:
      --------------------------
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Unexpected error
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleException:
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error converting line
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error converting line : java.lang.StringIndexOutOfBoundsException: String index out of range: -1
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : String index out of range: -1
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileinput.TextFileInput.convertLineToRow(TextFileInput.java:844)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileinput.TextFileInput.processRow(TextFileInput.java:1149)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Unknown Source)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException:
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error converting line : java.lang.StringIndexOutOfBoundsException: String index out of range: -1
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : String index out of range: -1
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileinput.TextFileInput.convertLineToStrings(TextFileInput.java:618)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileinput.TextFileInput.convertLineToRow(TextFileInput.java:671)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 3 more
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.String.substring(Unknown Source)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileinput.TextFileInput.convertLineToStrings(TextFileInput.java:600)
      2013/06/13 13:56:10 - Text file input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 4 more

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            jbleuel Jens Bleuel
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Time Tracking

                Estimated:
                Original Estimate - 10h
                10h
                Remaining:
                Remaining Estimate - 10h
                10h
                Logged:
                Time Spent - Not Specified
                Not Specified