Siebel EIM >  SBL-EIM-00426 All batches in run failed

EIM batch failed SBL-EIM-00426 when loading 0 record

APPLIES TO:
Siebel Enterprise Integration Manager - Version 7.5.3 [16157] to 8.2.2 SIA[22320] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000

GOAL
While trying to load the data to the Siebel DB thru EIM, it was found that the error SBL-EIM-00426 will be displayed when the 0 record is loaded into the table.

This started to happen after applying the patch v7.5.3.2 SIA, previously with Siebel v 7.5.2.100 SIA, there is no such behaviour.

Is there a config parameter to disallow the display of 0 record "Error"?

SOLUTION

The behavior of version 7.5.2 and version 7.5.3 are the same:

In fact, this has nothing to do with Siebel version and this is caused because of the way how EIM tables are populated

- If the .ifb file's BATCH parameter specified a single batch number, and there is no interface row for the batch,

7.5.2 EIM will return "EIM-00422: No rows in given batch to process."
7.5.3 EIM will return "SBL-EIM-00422: No rows in given batch to process."

- If the .ifb file's BATCH parameter specified a range of batch numbers (for example 1-10), and there is no interface row for the batch range,

7.5.2 EIM will return "EIM-00426: All batches in run failed."
7.5.3 EIM will return "SBL-EIM-00426: All batches in run failed."

This is the intended behavior, and there is no parameter to prevent EIM from returning the above messages when it cannot find the interface row for the batch.

Suggested customer to run a SQL to check the interface table contains records for the batch before running the EIM task.

Also found that:

- If the .ifb file does not use any SHELL process, and there is no row for the batch, EIM will exit with status 100426.

- If the .ifb file uses SHELL process to run another process, EIM will exit with status 0 unless the EIM task exited abnormally.

This is because the SHELL process allow user to run more than one EIM processes, thus the exit status will not return status of a specific process, it will return status of the task.