Symptom
/IWBEP/L_MGW_MDE & /IWBEP/I_MGW_CTC are having deadlock, and st22 dump like:
Category Resource bottleneck
Runtime Errors DBIF_RTAB_SQL_ERROR
Except. CX_SY_EXPIMP_DB_SQL_ERROR
Date and Time 28.02.2024 08:30:29
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| SQL error 133 occurred while accessing table "/IWBEP/I_MGW_CTC". |
OR
Category ABAP programming error
Runtime Errors DBSQL_SQL_DEADLOCK_DETECTED
Except. CX_SY_OPEN_SQL_DB
ABAP Program /IWBEP/CL_MGW_MED_UTILS=======CP
Application Component OPU-BSE-SDE
Date and Time 29.02.2024 04:30:30
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| A deadlock has occurred while attempting to access table "/IWBEP/L_MGW_MDE". |
And it shows abap dump code in /IWBEP/CL_MGW_MED_UTILS~CLEAN_UP
| 28| " Delete model dependency entries |
|>>>>>| DELETE FROM /iwbep/l_mgw_mde |
| 30| WHERE tech_name_from = lv_technical_name |
| 31| AND version_from = lv_version. |
OR
| 51| |
|>>>>>| DELETE |
| 53| FROM DATABASE /iwbep/i_mgw_ctc(bm) "bm = Business Data request model |
| 54| ID iv_cache_key. |
| 55| |
RFC info from st22 dump
|Server-Side Connection Information |
| Information on caller of Remote Function Call (RFC): |
| System.............. SID |
| Installation number 0021264687 |
| Database Release..... 753 |
| Kernel Release...... 777 |
| Connection type..... 3 (2=R/2, 3=ABAP-System, E=External, |
| R=Reg.External) call type....... synchronous and non-transactional (emode 0, |
| imode 0) |
| Inbound TID.......... |
| Inbound queue name... |
| Outbound TID......... |
| Outbound queue name.. |
| |
| Client................. 100 |
| User.................. XXXXXXXXXXXXX |
| Transaction......... |
| Call program.........../IWFND/CL_SUTIL_MONI==========CP |
| Function module..... /IWBEP/SUTIL_CLEANUP_MD_CACHE |
| Call destination..... NONE |
Read more...
Environment
SAP Gateway
Product
Keywords
DBIF_RTAB_SQL_ERROR, CX_SY_EXPIMP_DB_SQL_ERROR, /IWBEP/I_MGW_CTC, DBSQL_SQL_DEADLOCK_DETECTED, CX_SY_OPEN_SQL_DB, /IWBEP/CL_MGW_MED_UTILS, /IWBEP/L_MGW_MDE, CLEAN_UP, /IWBEP/SUTIL_CLEANUP_MD_CACHE , KBA , OPU-GW-COR , Framework , OPU-BSE-SDE , SAP Data Enablement , 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.
SAP Knowledge Base Article - Preview