Skip Ribbon Commands
Skip to main content
SharePoint

Rolling Back and Removing New Records when an Error Occurs (Execute SQL)

To roll back and remove new records when an error occurs while writing a record to a database table, complete the following steps:

  1. Check out and open the process you want to edit.
      
  2. Open the Execute SQL activity in the process that you previously configured and now want to edit.  The Execute SQL window is displayed.
     
  3. Click the Database Resource and Query tab. The corresponding screen is displayed.  
     
  4. Select the If the create of any record fails, rollback and undo all record creations check box.
     
  5. Click OK. You configured the activity to undo any changes the activity may made prior to the error occuring.
     
Related Topics
Executing SQL Statements and Stored Procedures
Saving the Results to a File

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Database Activities > Execute SQL
Last modified at 7/31/2020 11:54 AM