OFSAA SQL Rules in a Batch Hang on the Server Sporadically

Last updated on MAY 09, 2018

Applies to:

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