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.
Even though this is set to not planned we certainly have it in our longer term roadmap and fully aware of the requirement. I know this won't fully solve the need here however we are currently planning on being able to re-submit a failed workflow and that way you wouldn't loose any of the submited data.
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.