OFSAA SQL Rules in a Batch Hang on the Server Sporadically
Last updated on MAY 09, 2018
Applies to:Oracle Financial Services Profitability Management - Version 188.8.131.52 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)
For Oracle Financial Services Analytical Applications (OFSAA) 184.108.40.206, 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.
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