Commit error handler
The Commit error handler stops the run and commits changes in your database apps. If your is not using apps that support transactions, like MySQL or Data store, the Commit error handler just stops the .
Modules that support transactions are labeled with the "ACID" label.
Before you use the Rollback or Commit error handlers, take a look at the auto commit scenario setting first.
The bundle that caused the error doesn't go through the rest of the flow. doesn't process the rest of the bundles.
For example: This demo contains five modules. The is useful for tests and showing the effect of an error handler:
- JSON - Parse JSON provides test data in the form of an array of three record IDs.
- Iterator splits the array into individual bundles.
- Data store - Update a record: Updates the data in the data store.
Data store - Update a record: This module updates the data again. This time the module works differently. In the module mapping, there is a mapping that intentionally creates an error:
The mapping inserts a null value into the required Key field, which always creates the BundleValidationError.
Having two data store modules doing the same thing, but one of them failing, will make a good example for the Commit and Rollback error handlers.
- Slack - Send a message: Sends a message to a private testing channel.
This is how the example looks:
When we would run the example , we would get the BundleValidationError:
If we added the Commit error handler to the Update a record module, the Commit error handler would stop processing the bundle in the and save changes to your data in database apps. wouldn't process the remaining bundles.
Let's check the data in the data store as well.
Before running the , the data store contained the following data:
The mappings for the Update a record modules. The first module updates the ID column to the number 4 and the Name column to the text Test 4.
The second module updates the ID column to the number 5 and the Name column to the text Test 5.
After running the , would update the data in the data store:
- The first bundle of data gets through the flow successfully and updates the first row of data in the data store both times. The first row contains the update from the second Update a record module: ID = 5, Name = Test 5.
- The second bundle gets to the first Update a record module successfully, but causes an error in the second module.The Commit error handler saves the update in the first module, but prevents the update in the second module and stops the . The second row contains the update from the first module only: ID = 4, Name = Test 4.
- doesn't update the third row because the Commit error handler stopped the run already. The data in the third row remain the same: ID = 3, Name = Test 3.
For more information about error handling strategies check the overview of error handling.
With the Commit error handler, you can stop the when an error happens. saves changes in the database apps in your and doesn't process the rest of the bundles in the flow.
Modules that support transactions are labeled with the "ACID" label.
Before you use the Rollback or Commit error handlers, take a look at the auto commit scenario setting first.
For example, the following outputs an error in the Data Store app module:
To stop the and save changes, follow the steps:
- Right-click the module that is causing the error. In the menu, select Add error handler.
- Select the Commit error handler.
- Save your Make.
You added the Commit error handler to your . When an error occurs in the Data store module, the stops and saves changes in modules that support transactions.
