Using DB Transaction inside a loop
Hello everyone,
I recently wanted to implement a DB transaction node in one of our Knime Server workflows, which contains a “generic loop start” and “variable condition loop end” node.
Unfortunately the loop can’t resolve and I get the error message “Loop start and loop end are not in the same workflow”. Without the transaction, the loop works like intended.
I also build a new test workflow with inserts random rows to a table in a database in the loop with the same result but a slightly different error message “Encountered loop-end without compatible end!”. This also happens with other loop end nodes.
Is there any possibility / workaround to run a db transaction inside a loop?
Many thanks in advance,
David