All OFSAA Batches Intermittently Remain Stuck in  Ongoing Status
(Doc ID 2662998.1)
Last updated on MAY 05, 2020
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Security Information and Event Management (SIEM)
Oracle Identity and Access Management (OIAM)
Unified Security Management System (USM)
OFSAA 8.0.x Batches remain stuck in  Ongoing status.
This is a intermittent problem, the Application server has been restarted as a workaround to fix the issue temporarily.
Even though a task remains in Ongoing status, there is no activity in the database. Memory is said to be enough.
You suspect there is a disjoint between the Application server and the Database server. Front-end but doesn’t seem to communicate to the back-end.
The iccserver.log from $FIC_APP_HOME/icc/logs seems to be getting connections from two different servers:
One server is the application server (i.e. <server1>), however the connection from second server (i.e. <server2>) appearing in the iccserver.log occurs at the same time the errors start appearing in the am_log_file.log from $FIC_DB_HOME/log.
[07-04-20 09:03:08,982 AM] - Connection from <server1>
[07-04-20 09:03:08,984 AM] - Starting new ICC Virtual server.
[07-04-20 09:03:08,988 AM] - Received request: [SC:0][ST:1002][SST:2103][Oper:0][Version:0][EF:false][D:INFODMDATA]
[07-04-20 22:01:52,176 PM] - Connection from <server2>
[07-04-20 22:01:52,178 PM] - Connection from <server2>
[07-04-20 22:01:52,179 PM] - Error initializing socket from client.
java.net.SocketException: Connection reset
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