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

Last updated on JANUARY 13, 2017

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)

Symptoms

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:

ERROR
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.
v_task_id
[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
204405
[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.
java.net.SocketException: Socket is closed
  at java.net.Socket.shutdownOutput(Socket.java:1407)

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.

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