OFSAAI Sequential Batch Fails to Trigger the Second Process in the Batch (Doc ID 1472635.1)

Last updated on JULY 03, 2012

Applies to:

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

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.6, when attempting to run a batch of allocations (several tasks in the batch), the first task (allocation) remains in Ongoing status and the following error occurs in the iccserver.log

ERROR
[16:47:53,708] - No requests waiting for identifier: OFSAADEV_PFT_Level_1.1_20110921_1.Task1
[16:47:53,708] - Received notification: Notification[IDENTIFIER:OFSAADEV_PFT_Level_1.1_20110921_1.Task1][INFODOM:OFSAADEV][MODE:1002][TYPE:2002][STATUS:3001][MESSAGE:null]
[16:47:53,708] - Task mode
[16:47:53,708] - The query for status: SELECT v_task_status, v_component_id FROM batch_task WHERE v_batch_run_id = ? AND v_task_id = ?
[16:47:53,714] - Unable to fetch status from database for OFSAADEV_PFT_Level_1.1_20110921_1.Task1. Zero rows returned.
[16:47:53,714] - Notification queue empty. Waiting for new notifications.

An allocation if launched through the PFT UI completes successfully. The server.conf.properties file appears to have the correct entries.

STEPS
The issue can be reproduced at will with the following steps:

1. Create a batch with several allocation tasks.
2. Run the batch.
==> Notice the first task remains stuck in Ongoing status even though processing is complete and results have been correctly written.

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