SAP Knowledge Base Article - Preview

2977063 - Outbound queues getting stuck with select statement on table TRFCQOUT

Symptom

Processing messages (SMQ1) shows large queues after Kernel upgrade to 753_REL.

The following shortdump is found in ST22.

Category               ABAP Programming Error
Runtime Errors         TIME_OUT
ABAP Program           SAPLQOWK
Application Component  BC-MID-RFC

  Time limit exceeded

What happened?
  Program "SAPLQOWK" has exceeded the maximum uninterrrupted runtime and has therefore been terminated.

  "TIME_OUT"
  "SAPLQOWK" bzw. LQOWKU07
  "HANDLE_QUEUES"

Outbound queues getting stuck on statement for table TRFCQOUT.

SELECT /* FDA WRITE */ DISTINCT "TRFCQOUT"."ARFCIPID", "TRFCQOUT"."ARFCPID", "TRFCQOUT"."ARFCTIME", "TRFCQOUT"."ARFCTIDCNT", "TRFCQOUT"."QNAME", "TRFCQOUT"."DEST", "TRFCQOUT"."QCOUNT", "TRFCQOUT"."QSTATE" FROM "TRFCQOUT", ( SELECT * FROM TABLE( SAPTOOLS.
MEMORY_TABLE( CAST( ? AS BLOB( 2G )) ) CARDINALITY 1 ) AS "t_00" ( "C_0" VARCHAR(72) , "C_1" VARCHAR(96) ) GROUP BY ( "C_0", "C_1") ) AS "t_00" WHERE "TRFCQOUT"."MANDT" = ? AND "TRFCQOUT"."QNAME" = "t_00"."C_0" AND "TRFCQOUT"."DEST" = "t_00"."C_1" AND
"TRFCQOUT"."NOSEND" = ? WITH CS

DBACOCKPIT -> Diagnosis -> Explain shows that there is indexscan on index TRFCQOUT~3 with key columns=2 for this statement.


Read more...

Environment

Db2 Linux Unix and Windows

Product

SAP Supply Chain Management 7.0

Keywords

MSJOIN, NLJOIN , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.