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

Value of a parameter set in Job entry does not get passed as a variable in a sub transformation

    XMLWordPrintable

    Details

    • Story Points:
      0
    • 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
      • Create a variable is.edw in kettle.properties file and set it to the directory where you are intending to place the attached file, stanstestfile.txt (just create any file, any name, if you wish);
      • Start Spoon
      • Open job AMLKJB1.kjb
      • Edit job execution entry, navigate to the Parameters tab and confirm the parameter CT_INPUT_FILE is defined and set to the value $[is.edw\stanstestfile.txt
      • Execute job
      • Confirm the attached error is present
      Show
      Create a variable is.edw in kettle.properties file and set it to the directory where you are intending to place the attached file, stanstestfile.txt (just create any file, any name, if you wish); Start Spoon Open job AMLKJB1.kjb Edit job execution entry, navigate to the Parameters tab and confirm the parameter CT_INPUT_FILE is defined and set to the value $[is.edw\stanstestfile.txt Execute job Confirm the attached error is present

      Description

      This regression defect had been identified to be introduced in PDI 7.1.0.11 and was confirmed to be present in 8.0.0.6 as well as 8.1.0.4.

      The error comes from the sub transformation Text Input step that is trying to resolve a variable $CT_INPUT_FILE in Get Variable step:

      2018/10/09 10:47:56 - Text file input.0 - ERROR (version 7.1.0.11-122, build 1 from 2018-04-23 14.10.47 by buildguy) : Couldn't open file #0 : file:///C:/Pentaho-pdi-client-7.1/data-integration/${CT_INPUT_FILE} --> org.apache.commons.vfs2.FileNotFoundException: Could not read from "file:///C:/Pentaho-pdi-client-7.1/data-integration/${CT_INPUT_FILE}" because it is not a file.
      2018/10/09 10:47:56 - AMLIssue - ERROR (version 7.1.0.11-122, build 1 from 2018-04-23 14.10.47 by buildguy) : Errors detected!
      

        Attachments

        1. AMLIssue.ktr
          17 kB
        2. AMLKJB1.kjb
          15 kB
        3. AMLKJB2.kjb
          14 kB
        4. error-7.1.0.11.jpeg
          error-7.1.0.11.jpeg
          147 kB
        5. stanstestfile.txt
          0.1 kB
        6. works-7.1.0.3.JPG
          works-7.1.0.3.JPG
          141 kB

          Issue Links

            Activity

              People

              Assignee:
              project admin Triage
              Reporter:
              ikirianov Igor Kirianov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: