OFSAA SQL Rules in a Batch Hang on the Server Sporadically
(Doc ID 2103256.1)
Last updated on JULY 22, 2022
Applies to:Oracle Financial Services Profitability Management - Version 18.104.22.168 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) 22.214.171.124, 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.
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