Some eHealth scheduled jobs are getting Oracle error message like ORA-24550: signal received

Document ID : KB000039373
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue/Problem: 

Several eHealth jobs are getting the following Oracle error message:

.....

ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=1] [si_int=98304] [si_ptr=0x18000] [si_addr=(nil)]

kpedbg_dmp_stack()+297<-kpeDbgCrash()+75<-kpeDbgSignalHandler()+107<-skgesig_sigactionHandler()+219<-fgets()+53<-_Z21dbuAnalyzeSchemaStats9RWCStringi()+659<-_Z21dbuAnalyzeSchemaStats9RWCString()+46<-_ZN15DbuAnalyzeDbApp13analyzeSchemaEv()+61<-_ZN15DbuAnalyzeDbApp3runEv()+632<-main()+288<-__libc_start_main()+220<-_start()+33

....

Environment: 

eHealth 6.3.2.05

Linux RHEL 6 

Cause:

The root cause of the problem is the synchronization between nhiIndexStats and nhiAnalyzeDb jobs when starting them together at the same time. 

The nhiIndexStats and nhiAnalyzeDb utilities are using the same dbuAnalyzeSchemaStats function. 

Resolution/Workaround:

This issue has been fixed in eH6.3.2.11.

And there is also a work around to just schedule the index and analyze jobs at different times.

 

Note : Contact CA Support if you have any questions.