How Records are Handled by the Bulk Insert Error Handling Feature

The following example explains the workflow of bulk insert error handling.

Consider that the plug-in attempts to execute a bulk insert operation that contains the following records. M1, M3, and M4 are correct records. M2 and M5 are incorrect records.

When the Handle Bulk Insert Error check box on the Advanced tab of the Data Merger activity is selected, the following process shows how bulk insert error handling is performed:
  1. When the bulk commit size limit is reached, the plug-in starts to commit this bulk insert into the database.
  2. When an error occurs while inserting the incorrect record (M2), bulk insert error handling inserts this record in the exception table.
  3. Then the plug-in handles the remaining records, and when an error occurs while inserting the incorrect record (M5), bulk insert error handling inserts this record in the exception table.
  4. After the bulk insert operation is complete, you can see all correct records (M1, M3, and M4) are in the destination table and the incorrect records (M2 and M5) are in the exception table.
Note: If a plug-in instance contains multiple Data Merger activities, each activity handles exception logic based on its configuration. Therefore, the exception logic of each Data Merger activity might be different.