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

MDI transform throws error even if not getting executed

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.0.0, 2.1.0
    • 2.1.0
    • Hop GUI, Hop Server
    • MacOS, Hop 2.0 release candidate.

    Description

      When a transformation has 2 (or more) MDI transforms, the MDI transform which does not got executed will throw an initiating error although no rows are present.

      Error message in this case is:

      2022/09/22 13:41:40 - db_read_query_present - Execution started for pipeline [db_read_query_present] 2022/09/22 13:41:40 - Table input.0 - ERROR: You need to specify a SQL statement to read from a database. 2022/09/22 13:41:40 - Table input.0 - ERROR: You need to specify a database connection. 2022/09/22 13:41:40 - Table input.0 - ERROR: Error initializing transform [Table input] 2022/09/22 13:41:40 - db_read_query_present - ERROR: Transform [Table input.0] failed to initialize! 2022/09/22 13:41:40 - Table input.0 - Finished reading query, closing connection. 2022/09/22 13:41:40 - ETL metadata injection 2.0 - ERROR: Unexpected error 2022/09/22 13:41:40 - ETL metadata injection 2.0 - ERROR: org.apache.hop.core.exception.HopException: 2022/09/22 13:41:40 - ETL metadata injection 2.0 - We failed to initialize at least one transform. Execution can not begin! 2022/09/22 13:41:40 - ETL metadata injection 2.0 - 2022/09/22 13:41:40 - ETL metadata injection 2.0 - 2022/09/22 13:41:40 - ETL metadata injection 2.0 - at org.apache.hop.pipeline.Pipeline.prepareExecution(Pipeline.java:1026) 2022/09/22 13:41:40 - ETL metadata injection 2.0 - at org.apache.hop.pipeline.engines.local.LocalPipelineEngine.prepareExecution(LocalPipelineEngine.java:206) 2022/09/22 13:41:40 - ETL metadata injection 2.0 - at org.apache.hop.pipeline.transforms.metainject.MetaInject.processRow(MetaInject.java:150) 2022/09/22 13:41:40 - ETL metadata injection 2.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:51) 2022/09/22 13:41:40 - ETL metadata injection 2.0 - at java.base/java.lang.Thread.run(Thread.java:829) 2022/09/22 13:41:40 - ETL metadata injection 2.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2022/09/22 13:41:40 - db_prepare - Pipeline duration : 1.43 seconds [ 1.429" ]

      In the attached image, the pipeline goes down the arrow path, there are not rows present on the path which says Query present. Still the MDI transform trows and error as described above.

      Attachments

        Issue Links

          Activity

            People

              shl.xue Shl Xue
              Joerg_Nomads Joerg
              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 - 20m
                  20m