I am using the “Table Row To Variable Loop Start” node in order to make the same manipulation in several different hostnames.
I am using “Microsoft SQL Server Connector” node for connecting the datebases.
Each row of the “Table Creator” has differnt hostname and the loop go through the hostnames and it works perfectly.
My issue start while one of the hostnames is down and the “Microsoft SQL Server Connector” execute falied(Login timed out).
This case actually stop all the workflow.
I am running the workflow by batch application with shell script,but the same issue come from the knime platform too.
I tried deal it with the “Try” & “Catch” nodes, but the “Microsoft SQL Server Connector” node not suitable with the try catch nodes.
Can anyone help me with this issue?
Is there any way to skip the loop index if there is a falied node during the index running?
Is there any option to defined a default hostname for the Microsoft SQL Server Connector" node in case of connection falied?
Try & Catch for “Microsoft SQL Server Connector”?![Knime_loop_err|574x500]
Example workflow is attached.