Yesterday I was trying to load data ( around 90k rows) into the knime model but it is very slow and the process got stuck at 2%. Can I cancel the execution and re-load the data?
If I cancel, what will happen to the 2% data already loaded? (as I don’t want to duplicate the data in the platform).
Hello @cathy12 ,
you can safely cancel the execution of the database manipulation nodes (DB Writer, DB Insert, DB Update, …). They start a database transaction right before manipulating the data in the table and only if the node successfully executes it commits the transaction. If you want to perform several manipulations spread across various nodes you can also wrap them all in a DB Transaction Start and DB Transaction End node. The start node marks the beginning of the transaction and the end node will either commit or rollback all manipulations depending on if all nodes succeed or fail. See this workflow for an example: