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.