gmitter-ef opened a new issue, #5953: URL: https://github.com/apache/hop/issues/5953
### Apache Hop version? 2.15 ### Java version? OpenJDK 17 ### Operating system Windows ### What happened? When the field a JSON input transform reads is dependent on the success of a database query, the field vanishes in case the SQL query fails (e.g. due to non-existent table) See the attached zip and the screenshots. [HOP-5953.zip](https://github.com/user-attachments/files/23357677/HOP-5953.zip) ### How to reproduce: - create a simple query in a Table input transform that packs a column (e.g. "id") read from a database into a string in JSON format , stream field that contains the JSON is called "id_json" - read "id" out of the JSON-string via "JSON Input" transform, under "Select field:" use "id_json" in the drop-down - as long as the query works / table exists, the JSON input parses everything correctly <img width="686" height="750" alt="Image" src="https://github.com/user-attachments/assets/5b4cb1c8-16bb-45b3-b6f6-cd12823acd71"; /> - now change the SQL query to use a NON-existing table and save the Table input transform - edit the JSON input transform: accept both error messages - what you see afterwards in the "File" tab of the "JSON input" transform is that the "Select field" LOST the field "id_json" <img width="882" height="558" alt="Image" src="https://github.com/user-attachments/assets/d20de70d-92f0-479c-9b54-4a33fe9d6cba"; /> - if you now hit OK and save (accidentally) the pipeline is stored with empty field to read from. (Happened a lot and caused quite a lot of troubles.) ### Issue Priority Priority: 3 ### Issue Component Component: Hop Gui, Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
