Symptom
In the PI system, lots of messages got stuck in SMQ2. The messages were severely delayed due to a performance issue.
- Developer Work Process Trace
In dev trace, SAP was unable to connect due to connection refused errors:
*** ERROR => DpMsgProcess: MsReceive () -> MSENILAYER,partner: [dpxxdisp.c 2585]
*** ERROR => DpMsgProcess: disconnect from msg_server [dpxxdisp.c 2656]
***LOG Q0I=> NiPConnect2: 10.3.97.26:3901: connect (146: Connection refused) [nixxi.cpp 3286]
- ST22 Dump
CONNECT_TO_ENQ_SERVER_FAILED
RAISE_EXCEPTION
SAPLARFC
- Oracle Alert Log
In the oracle alert logs, error ORA-04030 was detected:
ORA-04030: out of process memory when trying to allocate 32792 bytes
(QERHJ hash-joi,QERHJ Bit vector)
- I/O performance symptoms
In /var/adm/messages file, IO issue was detected:
PRODGSU12B Request Sense couldn't get sense data
PRODGSU12B md_stripe: [ID 641072 kern.warning]
WARNING: md: sapdata-ds/d11: read error on /dev/did/dsk/d9s0
PRODGSU12B scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g000b080042003894 (ssd30):
PRODGSU12B Corrupt label; wrong magic number
PRODGSU12B md_mirror: [ID 104909 kern.warning]
WARNING: md: sapdata-ds/d11: /dev/did/dsk/d9s0 needs maintenance
PRODGSU12B md_mirror: [ID 990438 kern.warning]
WARNING: md: sapdata-ds/d11: /dev/did/dsk/d9s0 last erred
PRODGSU12B scsi: [ID 107833 kern.warning] WARNING:
/scsi_vhci/ssd@g000b080041003894 (ssd31):
Read more...
Environment
SAP Kernel 720, SOLARIS 64-bit, Oracle
Product
Keywords
SMQ2, Message stuck, ORA-04030, ulimit, Disk faulty , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.