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.
SAP Knowledge Base Article - Preview