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

Change of behavior 4.4 vs. 5.x: Result rows do not get cleaned in inherited subjobs (sub job called and loops via Execute for every input row) on the second transformation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.0.0 GA (5.0.0 GA Suite Release)
    • Fix Version/s: None
    • Component/s: Job Entry
    • 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.

      Description

      Reproduction:
      1) A loop is defined by setting the row set and looping a subjob with the "Execute for every input row" option (see attachment testjob.kjb)
      2) Within the subjob (attachment loop.kjb) you have a "Dummy" transformation and a transformation that writes the result rows to the log.
      3) Run this with 5.x: The result rows get printed to the logs
      4) Run this with 4.x: The result rows get not printed to the logs when there is a "Dummy" transformation.
      4) Within 4.x: When there is no "Dummy" transformation, the result set gets printed and is kept intact.

      This is a bug, because there is no feature/improvement logged for 5.0 that changed this behavior nor a documentation about this change.

      The actual behavior since 5.0 is better since the row set keeps available also to all transformations.
      There is a workaround to keep the 4.x behavior: check the option "Clear list of result rows before execution"
      We have better options to loop through rows by using the Job Executor and Transformation Executor steps.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              cbrathwaite Chantel Brathwaite (Inactive)
              Reporter:
              jbleuel Jens Bleuel
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: