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

Get data from XML: "Size field" under "Additional output fields" tab is not found when executing the transformation locally with Spoon connected to repository.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Severity: High
    • Resolution: Unresolved
    • Affects Version/s: 8.3.0 GA, 9.1.0 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      0
    • 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.
    • Steps to Reproduce:
      Hide

      Steps to replicate the issue:

      • Start Pentaho Spoon 8.3 or higher.
      • Start Pentaho Server 8.3 or higher
      • Open the attached transformation in the Spoon and change the path to the XML1.xml file as per your environment.
      • Execute the transformation locally. You will see the result below

      • Now connect the Spoon to your repository and save the sample transformation into the repository.
      • Execute the transformation locally and you will get the error as
      2021/03/23 20:20:54 - Text file output.0 - Field [size_field] couldn't be found in the input stream!
      2021/03/23 20:20:54 - Text file output.0 - 
      2021/03/23 20:20:54 - Text file output.0 - 	at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.initFieldNumbers(TextFileOutput.java:90)
      
      Show
      Steps to replicate the issue: Start Pentaho Spoon 8.3 or higher. Start Pentaho Server 8.3 or higher Open the attached transformation in the Spoon and change the path to the XML1.xml file as per your environment. Execute the transformation locally. You will see the result below Now connect the Spoon to your repository and save the sample transformation into the repository. Execute the transformation locally and you will get the error as 2021/03/23 20:20:54 - Text file output.0 - Field [size_field] couldn't be found in the input stream! 2021/03/23 20:20:54 - Text file output.0 - 2021/03/23 20:20:54 - Text file output.0 - at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.initFieldNumbers(TextFileOutput.java:90)

      Description

      With "Get data from XML" having "Size field" under "Additional output fields" tab set and executed locally on Spoon with Spoon connected to the repository, we get the following error

      2021/03/23 20:20:54 - Get data from XML.0 - Finished processing (I=5, O=0, R=0, W=5, U=0, E=0)
      2021/03/23 20:20:54 - Text file output.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Unexpected error
      2021/03/23 20:20:54 - Text file output.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 
      2021/03/23 20:20:54 - Text file output.0 - Field [size_field] couldn't be found in the input stream!
      2021/03/23 20:20:54 - Text file output.0 - 
      2021/03/23 20:20:54 - Text file output.0 - 	at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.initFieldNumbers(TextFileOutput.java:90)
      2021/03/23 20:20:54 - Text file output.0 - 	at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.processRow(TextFileOutput.java:455)
      2021/03/23 20:20:54 - Text file output.0 - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2021/03/23 20:20:54 - Text file output.0 - 	at java.lang.Thread.run(Thread.java:748)
      2021/03/23 20:20:54 - Text file output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
      

      This happens only to the Size field.

        Attachments

        1. 99485Sample.ktr
          18 kB
        2. Capture-75.JPG
          Capture-75.JPG
          94 kB
        3. XML1.xml
          0.4 kB

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            gdev Gurudev
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: