Solution : https://service.sap.com/sap/support/notes/1493644 (SAP Service marketplace login required)
Summary :
This SAP Note identifies performance issues in transactions SM66 and related processes, specifically involving long-running processes on the TRFCQIN table and frequent reads from the QIWKT Majesty table, potentially leading to deadlocks. Issues are signaled by TIMEOUT dumps in "UPDATE_SCHEDULER_STATE" and DBIF_RSQL_SQL_ERROR dumps indicating deadlock scenarios. The root cause is identified as a program error in handling READY and STOP queues in the system. The prescribed action is to apply provided correction instructions to address and resolve these processing inefficiencies.
Key words :
long running process, transaction sm66 reading, correction instructions attached, processes reading qiwktab, dbif_rsql_sql_error dump pointing, qiwktab tables, systems pointing, table trfcqin, deadlock situation, timeout dumps
Related Notes :
| 1500048 | SMQ2 inbound Queue remains in READY state |
| 1497510 | Experiencing deadlocks, lock & waits in inbound processing |
| 1485789 | QRFC: Long running processes in SM50 |
| 1456887 | Many processes select TRFCQIN with SAPLIRFC |
| 1324454 | qRFC scheduler is still set to WAITING status |