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

Last updated on MARCH 01, 2023

Applies to:

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:.......... 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.
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.

Changes

Cause

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