Siebel Enterprise Integration Manager Administration Guide > Deleting Data > Editing the Configuration File for Delete Processing >

Handling Aborts of EIM Delete Processing


If an EIM delete process is aborted, base tables associated with deleted rows may not be updated. Orphans rows may be created because foreign keys may not have been updated. This may cause critical data integrity issues.

To avoid this problem, you should set the following parameters in the .IFB file to make sure that the EIM delete process performs only one commit and rollback when aborted:

COMMIT EACH TABLE = FALSE

COMMIT EACH PASS = FALSE

ROLLBACK ON ERROR = TRUE

Siebel Enterprise Integration Manager Administration Guide Copyright © 2006, Oracle. All rights reserved.