Prerequisites of Using Bulk Insert Error Handling
Before using the bulk insert error handling feature, you have to add a necessary parameter and then configure Subscription Service.
Adding a Parameter
To enable bulk insert error handling, add the adb.<sub-service-name>.bulkInsertErrorHandling <on/off> parameter to the adbagent.tra file in the TIB_ADADB_HOME\bin directory.
This parameter indicates whether the bulk insert error handling feature in Subscription Service is enabled or not. Its default value is off. You can refer to the adbagent.tra file for the parameter format.
To enable the bulk insert error handling feature, change the <sub-service-name> variable to the name of Subscription Service, and set the value to on. The following is an example:
adb.ADBSubscriber.bulkInsertErrorHandling on
Configuring Subscription Service
In addition to the setting in the adbagent.tra file, you have to configure Subscription Service in TIBCO Business Studio.
In the Subscription Options tab, enter values in the Bulk Insert Size, Batch Commit Size, and Batch Commit Timeout (milliseconds) fields. Then save your configuration.
