Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-3482

Pipeline hangs if fields not found in input from previous transforms

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.1.0
    • None

    Description

      We have simple pipeline as shown in the picture below

      The Database Join contains a simple query (tables independent as you can see) that works (in my case I configured it to work with a postgres database). On the other side, the Filter in error contains a filter on a field that do not exists in the input rowset.

      If we start the pipeline, it immediately hangs and we don't have any possibility to look at in the log's view of Hop GUI. If we look at the console window we get the log and it is like this

      If we comment the Database Join, we substitute it with a write to log (for example) and we run it the pipeline goes in error but it closes correctly without hanging as before

      Attached the sample to try it out. Remember to configure the connection before running the sample. The query is independent from any table contained in the database.

       

      Attachments

        1. image-2021-11-04-15-45-23-789.png
          26 kB
          Sergio Ramazzina
        2. image-2021-11-04-15-49-35-440.png
          81 kB
          Sergio Ramazzina
        3. image-2021-11-04-15-53-03-019.png
          34 kB
          Sergio Ramazzina
        4. pipeline_hangs.zip
          7 kB
          Sergio Ramazzina

        Issue Links

          Activity

            People

              sramazzina Sergio Ramazzina
              sramazzina Sergio Ramazzina
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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