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

book

Article ID: 39373

calendar_today

Updated On:

Products

EHEALTH CA eHealth

Issue/Introduction

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.

Environment

Release:
Component: EHORA