We have a NWC workflow with a SQL execute a query action that does an insert query to an on-prem SQL database based on details captured in the start form.
When we had a network issue which caused the action and the workflow to fail with no ability to gracefully handle the error. In this case we lost the data submitted by the user in the start form.
This is the error we see in the instance information.
In the interim we are looking at a backup action to also capture the data into a sharepoint list.
What would be good is similar to the nintex sharepoint on-prem sql action is the ability to optionally capture errors and then capture that an error had occured into a boolean variable. That way I can build some better logic into the workflow to ensure that information is not lost and the workflow can conclude more gracefully.
In my scenario above I would want to only add an item into the sharepoint list when the SQL action timesout.
I've created a new uservoice for this idea if you would like to vote for it.
Best answer by Gavin-Adams
View original
