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 for Me (Login required).

Search for additional results

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