EIM DELETE - Commit, Rollback using "DELETE EXACT" (Doc ID 857282.1)

Last updated on JULY 20, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.1.1 [19044] and later
Information in this document applies to any platform.

Symptoms

Statement of what the issue is
Environment
========

Siebel/Database: V7.8.1/Oracle 10.2.0.4

Symptom
======

You are trying to run EIM DELETE using DELETE EXACT parameter.

The following ifb file settings have been placed

TYPE = DELETE
TABLE = EIM_SRV_REQ
BATCH = 650000-650001
ONLY BASE TABLES = S_SRV_REQ
DELETE EXACT = TRUE
DELETE ALL ROWS = FALSE
COMMIT EACH TABLE = FALSE
COMMIT EACH PASS = FALSE
ROLLBACK ON ERROR = TRUE

However, while EIM is cascade deleting the child tables like S_SRV_REQ1_FNX, it is issuing a commit.

Actual Behavior
=========

EIM is not issuing commit for each table insert/update/delete. This behavior is noticed only when it is cascade deleting the child tables of S_SRV_REQ. This has been observed in the two batches involved.

Expected behavior
===========

With the following statements:

COMMIT EACH TABLE = FALSE
COMMIT EACH PASS = FALSE
ROLLBACK ON ERROR = TRUE

EIM should not be issuing 'commits' until the batch has been successfully processed. However, EIM is doing commit in between.

Business impact
=============

None specified. but it is not a critical issue at the moment based on the priority of the SR.

Error message
========

DELETE is functioning fine but not as expected based on ifb file file parameters. Hence, no errors have been reported.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms