SAP Knowledge Base Article - Preview

2021635 - Message stuck in SMQ2 for long duration

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

SAP NetWeaver 7.3

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.