Skip Ribbon Commands
Skip to main content
SharePoint

Rolling Back and Removing New Records when an Error Occurs

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 database activity in the process that you previously configured and now want to edit.  The Create Database Records
    window is displayed.

  3. Click the Database and Table tab. The Database and Table to Add New Records To section is revealed.

  4. Select the relevant database table. The selected table’s name is displayed in the field.

  5. Click the Data Mappings: Create Records tab. The corresponding screen is displayed.

  6. Select the If the create of any record fails, rollback and undo all record creations check box.

  7. Click OK. You configured the activity to roll back and remove new records when an error occurs.

Related Topics
Writing a New Record to a Database Table
Writing Multiple Records to a Database Table
Saving the Identity of a New Database Record to a Data Item
Automatically Determining which Columns to Populate with Data Item Values
Manually Detemining which Columns to Populate with Data Item Values, Expression Results, or Literal Values


Source
BPM Designer Topics > Overview of Activities and Activity Topics > Database Activities > Create Database Records
Last modified at 7/31/2020 11:55 AM