Element Association Broken
Article ID: 91883
Updated On:
Products
CA eHealth
Issue/Introduction
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....
.
.....
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
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')"
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')"
Feedback
Yes
No
Powered by
