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

Variables not passed to sub-transformation

    XMLWordPrintable

    Details

    • Story Points:
      5
    • 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.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      1 Extract the 90331_sample.7z file attached to ESR-6819 to create 90331_sample folder
      2 Load job_test_variable.kjb into Spoon 8.0.0.0 from folder created in step 1
      3 Execute job_test_variable.kjb and it will work correctly with following results. Variable v_name is correctly assigned a value, e.g.
      2019/07/04 12:30:56 - Write to log.0 - v_name = aa
      2019/07/04 12:30:56 - Write to log.0 - Name = bb
      4 Execute the same job in Spoon 8.3.0.0. Variable v_name is unassigned, e.g.
      2019/07/04 12:44:25 - Write to log.0 - v_name =
      2019/07/04 12:44:25 - Write to log.0 - Name = bb

      Show
      1 Extract the 90331_sample.7z file attached to ESR-6819 to create 90331_sample folder 2 Load job_test_variable.kjb into Spoon 8.0.0.0 from folder created in step 1 3 Execute job_test_variable.kjb and it will work correctly with following results. Variable v_name is correctly assigned a value, e.g. 2019/07/04 12:30:56 - Write to log.0 - v_name = aa 2019/07/04 12:30:56 - Write to log.0 - Name = bb 4 Execute the same job in Spoon 8.3.0.0. Variable v_name is unassigned, e.g. 2019/07/04 12:44:25 - Write to log.0 - v_name = 2019/07/04 12:44:25 - Write to log.0 - Name = bb

      Description

      Pentaho Product: Data Integration
      Version: 8.3.0.0
      Operating System: Windows 10/Ubuntu 16.04
      Memory Available/Used: 32Gb/4Gb
      Clustered/No: Not clustered
      Virtualized?: Not virtualized
      Database for repository: N/A
      Database for data: N/A
      Browser type and version (If Applicable): N/A
      Did you attach logs? Yes - attached to ESR-6819
      Did you attach sample demonstrating the problem? Yes - attached to ESR-6819

      Please see the job attached to ESR-6819 for a reproduction path of this issue.

      Basically, in the master job a variable called v_name is set in the "set variables" step and is scoped to "valid in the root job".

      The master job calls another transformation called test_variable via the transformation step
      The test_variable transformation calls another transformation called setze_variable, via the transformation executor step.
      The setze_variable transformation should retrieve the value of the v_name variable via the "get variables" step.
      Testing in 8.2.03, 8.2.0.5 and 8.3.0.0 shows that the value of v_name is not getting passed.

      If the same transformation is tested on 8.0.0.0, then the v_name variable is passed as expected.

      Changing the scope to "valid in the JVM" does not change the problem - the variables still aren't passed.

      Raising this issue as a defect after discussion logged in ESR-6819

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lcarvalho Laura Carvalho
              Reporter:
              nmidson Nick Midson
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: