My Oracle Support Banner

OFSAAI ESIC Program Not Initializing When Executing a Single Batch (Doc ID 1609154.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.10 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)


In OFSAAI 7.2.10, when attempting to use ESIC script to execute batches via a scheduler, ESIC program fails to initialize a single OFSA Batch process and throws a return code of 130. The following error is found:

Processing Date:.......... 20131031
Batch Id:................. OFSA72_STRD_PRCDR_EVL_1
External Batch Run Id:.... OFSA72_STRD_PRCDR_EVL_1_ESIC_20131102103226

/app/reveleusofs/ficapp/icc/bin/esic -JI -UOFSAMTH -P -ROFSA72_STRD_PRCDR_EVL_1_ESIC_20131102103226 -IOFSA72 -BOFSA72_STRD_PRCDR_EVL_1 -D20131031 -F/tmp
ERROR: ESIC Batch Initialize Failed OFSA72_STRD_PRCDR_EVL_1_ESIC_20131102103226 20131102103227
ERROR: ESIC exit code = 25

The following error is discovered in the iccserver.log:

[20:44:06,796] - Validated user.
[20:44:06,796] - Creating handler for request type: I
[20:44:06,796] - External unique ID: OFSA72_STRD_PRCDR_EVL_1_ESIC_20131202204405
[20:44:06,796] - Infodom: OFSA72
[20:44:06,796] - Batch Name: STRD_PRCDR_EVL_1
[20:44:06,796] - Infodate: 20131130
[20:44:06,796] - Temp Path: /tmp
[20:44:06,796] - Executing request through handler.
[20:44:06,796] - Fetching batchrun object
[20:44:06,796] - Executing query to get batchrun object: SELECT a.v_task_id, a.v_task_description, a.v_component_id, b.v_parameter_n
ame, b.v_parameter_value, b.i_parameter_order, c.v_parent_task_id FROM batch_task_master a, batch_parameter_master b, batch_task_pre
cedence_master c WHERE a.v_batch_id = ? AND b.v_batch_id = ? AND b.v_task_id = a.v_task_id AND c.v_batch_id = ? AND c.v_task_id = a.
[20:44:06,804] - Error. zero rows received.
[20:44:06,804] - Database error or Invalid batch name. Unable to initialize batch run for uid: OFSA72_STRD_PRCDR_EVL_1_ESIC_20131202
[20:44:06,804] - Writing to native socket: ##ICC##I##-1##-28##Database error or Invalid batch name. Unable to initialize batch run f
or uid: OFSA72_STRD_PRCDR_EVL_1_ESIC_20131202204405## with padding
[20:44:06,804] - Error writing to client. Socket is closed

This problem occurs randomly during the month end cycle. It appears to be random, one month the batch will execute without issue, the next month ESIC will fail to initialize.
Other batches run fine before and after this occurs.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.