SAP Knowledge Base Article - Preview

3586413 - Frequent access to the ARFCRSTATE table with every LUW execution lead to significant performance degradation

Symptom

In high load situations there are multiple DBSQL_SQL_DEADLOCK_DETECTED runtime errors, exception CX_SY_OPEN_SQL_DB in ARFC_DEST_SHIP while inserting in ARFCRSTATE:

  188
>>>>>   INSERT arfcrstate.
  190   l_subrc = sy-subrc.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


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

Slow processing tRFC, qRFC, high load, abap/arfcrstate_col_delete, RSTRFCEU, Deadlock, DBSQL_SQL_DEADLOCK_DETECTED, CX_SY_OPEN_SQL_DB, ARFC_DEST_SHIP, ARFCRSTATE, INSERT arfcrstate, RFC, Asynchronous RFC, Transactional RFC, bgRFC, RFC_GDPR  , KBA , BC-MID-RFC-QT , Queued RFC (qRFC) and transactional RFC (tRFC) , BC-MID-RFC-BG , Background RFC (bgRFC) , 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.