Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
2.0.0, 2.1.0
-
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
Attachments
Issue Links
- links to