OFSAA SQL Rules in a Batch Hang on the Server Sporadically (Doc ID 2103256.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Analytical Applications (OFSAA) 6.1.0.3, during a processing cycle, a SQL Rule will randomly hang on the server.  When you check the server, you see a process with sqlrule.sh running on the server but the SQL is not actually running on the database.

In the am_log_file.log from $FIC_DB_HOME/log, the SQL Rule batch reports a Signal 9 error:

Log Message here 1: Thu Oct 8 20:28:37 2015||INFO||Thread 1 : Bytes Read Data = %%##F##I##D##servername##servername##INsqlrule!!main!!NINFODOM_ST_LS_ACT_ORG_FTP_20150930_4^^SQLRULE^^Task9^^20150930^^EDW^^INFODOM^^servername^^409868##%%
.
.
.
Log Message here 1: Thu Oct 8 21:41:21 2015||SEVERE||GetChildStatus : Child Terminated abnormally. Signal number = 9
Log Message here 1: Thu Oct 8 21:41:21 2015||SEVERE||Sigchild Handler : Child process Returned failure

If you stop and re-start the OFSAA server processes and re-run the SQL Rule, it completes successfully.  You do not understand why the process was hanging in the first execution.

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