Element Association Broken

Document ID : KB000091883
Last Modified Date : 18/04/2018
Show Technical Document Details
Issue:
After restart nhServer and Db, server started to restart itself (flipping) without any actions. 
.....
from the Log file we can observe the following message : 
ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=1] [si_int=0] [si_ptr=(nil)] [si_addr=(nil)] 
kpedbg_dmp_stack()+397<-kpeDbgCrash()+104<-kpeDbgSignalHandler()+107<-skgesig_sigactionHandler()+291<-0824CAF7<-_ZN17DccOperIndividual7doMergeER7CuError()+211<-_ZN8DccMerge7doMergeER7CuError()+373<-_ZN11PlrCfgMerge10asyncReplyEPv11CuReplyTypeS0_PK7CuError()+170<-_ZN14CdtDbElemTrans8getAdlCbEPv11CuReplyTypeS0_PK7CuError()+710<-_ZN14CdtDbElemTrans9getAdlCCbEPvS0_11CuReplyTypeS0_PK7CuError()+57<-_ZN6DbsApi11getAssocsCbEP5CuMsgPvPj()+209<-_ZN6DbsApi12getAssocsCCbEPvP5CuMsgS0_Pj()+50<-_ZN10CuMsgCbRef5msgCbEP5CuMsgPvPj()+39<-_ZN12CuDispatcher12sendToTargetEP13RWCollectableP5CuMsgPvPj()+245<-_ZN12CuDispatcher10sendByTypeEP5CuMsgPvPj()+446<-_ZN12CuDispatcher4sendEP5CuMsgPvPj()+145<-_ZN10CbaBaseApp12handleIpcMsgEP8CuIpcMsgPvPj()+95<-_ZN10CbaBaseApp9ipcMsgCCbEPvP5CuMsgS0_Pj()+173<-_ZN12CcmConSocket11invokeMsgCbEP8CuIpcMsgPj()+42<-_ZN9CcmClient14handleSelectCbE15CosSelectCbType9CosFdTypeiPv()+145<-_ZN9CcmSocket9selectCCbEPv15CosSelectCbType9CosFdTypeiS0_()+48<-_ZNK9CosFdInfo8invokeCbE15CosSelectCbType9CosFdType()+83<-_ZNK8CosFdSet8doSelectEv()+450<-_ZN9WscAppApi7rpcCallEP8CuIpcMsgRKS0_()+293<-_ZN6CbaApp7rpcCallEP8CuIpcMsgRKS0_()+145 
ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=1] [si_int=0] [si_ptr=(nil)] [si_addr=(nil)] 
kpedbg_dmp_stack()+397<-kpeDbgCrash()+104<-kpeDbgSignalHandler()+107<-skgesig_sigactionHandler()+291<-0824CAF7<-_ZN17DccOperIndividual7doMergeER7CuError()+211<-_ZN8DccMerge7doMergeER7CuError()+373<-_ZN11PlrCfgMerge10asyncReplyEPv11CuReplyTypeS0_PK7CuError()+170<-_ZN14CdtDbElemTrans8getAdlCbEPv11CuReplyTypeS0_PK7CuError()+710<-_ZN14CdtDbElemTrans9getAdlCCbEPvS0_11CuReplyTypeS0_PK7CuError()+57<-_ZN6DbsApi11getAssocsCbEP5CuMsgPvPj()+209<-_ZN6DbsApi12getAssocsCCbEPvP5CuMsgS0_Pj()+50<-_ZN10CuMsgCbRef5msgCbEP5CuMsgPvPj()+39<-_ZN12CuDispatcher12sendToTargetEP13RWCollectableP5CuMsgPvPj()+245<-_ZN12CuDispatcher10sendByTypeEP5CuMsgPvPj()+446<-_ZN12CuDispatcher4sendEP5CuMsgPvPj()+145<-_ZN10CbaBaseApp12handleIpcMsgEP8CuIpcMsgPvPj()+95<-_ZN10CbaBaseApp9ipcMsgCCbEPvP5CuMsgS0_Pj()+173<-_ZN12CcmConSocket11invokeMsgCbEP8CuIpcMsgPj()+42<-_ZN9CcmClient14handleSelectCbE15CosSelectCbType9CosFdTypeiPv()+145<-_ZN9CcmSocket9selectCCbEPv15CosSelectCbType9CosFdTypeiS0_()+48<-_ZNK9CosFdInfo8invokeCbE15CosSelectCbType9CosFdType()+83<-_ZNK8CosFdSet8doSelectEv()+450<-_ZN9WscAppApi7rpcCallEP8CuIpcMsgRKS0_()+293<-_ZN6CbaApp7rpcCallEP8CuIpcMsgRKS0_()+145....
Environment:
Release: 6.3.3, 
Operating System: REDHAT 
Cause:
Following a discovery suddenly interrupted during the update phase of the database, the data of some element could not be complemented registered, which created a break in the table nh_elem_assoc
 
Resolution:

1. stop the eHealth server processes (if they are currently running): nhServer stop 
2. Log into the database as the $NH_USER : sqlplus $NH_USER/$NH_USER 
3. run the following sql command 
   delete from nh_elem_assoc where element_id not in(select element_id from nh_element); 
   delete from nh_elem_assoc where parent_id not in(select element_id from nh_element); 
   commit; 
   exit 
4. start the eHealth server processes : nhServer start
Additional Information:
to verify the existing bad associations, please run through the following SQL commands to check for mtf issues and bad associations 

1. $NH_HOME/bin/sys/nhisql "select name, mtf_name, element_id from nh_element where mtf_name not in (select name from nh_mtf)" 
2. $NH_HOME/bin/sys/nhisql "select * from nh_elem_assoc where element_id not in (select element_id from nh_element)" 
3. $NH_HOME/bin/sys/nhisql "select parent_id from nh_elem_assoc where parent_id not in(select element_id from nh_element)" 
4. $NH_HOME/bin/sys/nhisql "select element_id, name, mtf_name from nh_element where mtf_name not like ('%.mtf')"