SAP Knowledge Base Article - Preview

3845714 - Slow SMQ1 queue processing on HANA DB with expensive SQL select on TRFCQOUT table

Symptom

  • Slow processing of outbound qRFC entries in SMQ1 transaction; 
  • Expensive SELECT statement on TRFCQOUT table. 

Example of statements: 

SELECT arfcipid arfcpid arfctime arfctidcnt 
  qname dest qcount qstate
FROM trfcqout
INTO TABLE all_queue
FOR ALL ENTRIES IN qview
WHERE qname = qview-qname
     and dest = qview-dest
     and nosend = space

  SELECT * FROM trfcqout UP TO 1 ROWS
          INTO trfcqout
          WHERE qname like db_qname
            and dest     = dest.
          qempty = space.
          exit.
        ENDSELECT.


Read more...

Environment

  • SAP NetWeaver
  • SAP NetWeaver Application Server for SAP S/4HANA
  • ABAP PLATFORM - Application Server ABAP

Product

ABAP platform all versions ; SAP NetWeaver all versions ; SAP Web Application Server for SAP S/4HANA all versions

Keywords

RFC, SMQ1, SMQS, qRFC, WAITING, TRFCQOUT, TRFCQOUT~0, QDEST_RUN_DESTINATION  , KBA , BC-MID-RFC-QT , Queued RFC (qRFC) and transactional RFC (tRFC) , 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.