Bulk Insert Error Handling and Applicable Restrictions

You can insert records in a bulk in the destination table. The bulk insert error handling feature is used to improve data accuracy and processing efficiency. It also prevents failure during bulk insert operation.

The bulk insert error handling feature restrictions are as follows:
  • This feature applies to the Data Merger activity only.
  • It can be implemented only when the java.sql.BatchUpdateException error occurs.
  • It supports the Oracle and MSSQL databases only.
  • It cannot be used with schemas having a parent-child relationship.

For example, a job attempts to perform a bulk insert of 500 rows to the destination table. If the first 300 rows are inserted successfully but the last 200 rows are not, the job inserts the successful 300 rows to the destination table and the unsuccessful 200 rows to the exception table.

If the bulk insert error handling feature is not enabled and an error occurs, the job inserts all rows (both correct and incorrect) in the exception table when the Data Merger activity performs the bulk insert operation.