dave-csc opened a new issue, #8917:
URL: https://github.com/apache/hop/issues/8917

   ### Apache Hop version?
   
   2.19
   
   ### Java version?
   
   21.0.11 (Zulu 21.50)
   
   ### Operating system
   
   Linux
   
   ### What happened?
   
   Changing the fields in the **Insert/Update** transform doesn't trigger a 
modification event, hence the pipeline that contains it cannot be saved.
   
   When executing the "updated" pipeline in Hop GUI, it ignores the 
modifications. Also, when closing and reopening the pipeline, changes in the 
fields are reverted.
   
   A workaround consists in performing subsequently another action that 
triggers the modification event, even just moving the transform in the 
workspace.
   
   ---
   
   Possible reproduction path:
   1. set the Insert/Update transform to use the table primary key as lookup 
keys, and the other table fields as fields to update
   2. start the pipeline: the transform will fail when trying to insert a row, 
because a NULL cannot be inserted as primary key
   3. change the fields to update, and include the primary key. This action 
alone will not trigger the modification event
   4. start the pipeline again, the transform will fail as above
   5. move any transform in the workspace: this will trigger the modification 
event and will allow you to save the pipeline
   6. start the pipeline another time, now the transform should succeed
   
   ### 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]

Reply via email to