I have the above workflow for using a connection to a DB and executing a Query, which works fine, but I am using the Pick Branch on the Right to Delay and Disconnect (and stop querying and throw Error; if no output is found in the delay period of 12 mins).
This works well, but it is a constant issue I am having, when running in a Virtual Machine, the query will sometimes get stuck? and continually run, even after the 12 min delay, so it is as if because the query is still running technically, it can’t Disconnect on the right.
This is a real issue I have been having for a while now, and can’t find a solution that will give up Executing a Query, after a set period of time.
Any thoughts would be greatly appreciated!