My Oracle Support Banner

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

Last updated on MARCH 01, 2023

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:.......... 20091231
Batch Id:................. OFSAAINFOD_451892_20091231_10
External Batch Run Id:.... OFSAAINFOD_451892_20091231_10_ESIC_20131102103226

$FIC_HOME/ficapp/icc/bin/esic -JI -UOFSAAUSER -P -ROFSAAINFOD_451892_20091231_10_ESIC_20131102103226 -IOFSAAINFOD -BOFSAAINFOD_451892_20091231_10 -D20091231 -F/tmp
ERROR: ESIC Batch Initialize Failed OFSAAINFOD_451892_20091231_10_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: OFSAAINFOD_451892_20091231_10_ESIC_20131202204405
[20:44:06,796] - Infodom: OFSAAINFOD
[20:44:06,796] - Batch Name: OFSAAINFOD_451892_20091231_10
[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_name, b.v_parameter_value, b.i_parameter_order, c.v_parent_task_id FROM batch_task_master a, batch_parameter_master b, batch_task_precedence_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: OFSAAINFOD_451892_20091231_10_ESIC_20131202204405
[20:44:06,804] - Writing to native socket: ##ICC##I##-1##-28##Database error or Invalid batch name. Unable to initialize batch run for uid: OFSAAINFOD_451892_20091231_10_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.