Skip to Main Content
Status Not Planned
Categories Workflow Designer
Created by Guest
Created on Apr 30, 2020

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.
  • ADMIN RESPONSE
    Sep 7, 2022
    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.
  • Attach files
  • Guest
    Reply
    |
    Sep 7, 2022
    I find it hard to believe this isn't a feature, there is no way to failover and recover.
  • Guest
    Reply
    |
    Sep 7, 2022
    Any updates on this, Nintex team?
  • Guest
    Reply
    |
    Sep 7, 2022
    Would be great to see this solved please