sql execute a query - capture error option
In NWC SQL execute a query action there is currently no error handling mechanism.
If there is a network connectivity issue to the SQL connection the action and the workflow is failing.
It would be good to add in the ability to capture errors and store that the error has occurred in a boolean variable so we can build conditional logic in the workflow to gracefully handle the issue and not lose the data from the nintex start form.
(In my example I'm using an INSERT SQL query)
This could be similar to the Nintex workflow for sharepoint on premise SQL action.
Gavin Adams commented
Would be great to see this solved please
Rhia Wieclawek commented
Any updates on this, Nintex team?
I find it hard to believe this isn't a feature, there is no way to failover and recover.