Symptom
Deadlock or lockwait happens on table VARINUM.
A short dump could also happen, following sample was observed frequently in customer systems:
Category ABAP programming error
Runtime Errors DBSQL_SQL_DEADLOCK_DETECTED
Except. CX_SY_OPEN_SQL_DB
ABAP Program RSDBSPJS
Application Component BC-ABA-TO
Short Text
A deadlock has occurred while attempting to access table "VARINUM".
The procedure is in program "RSDBSPJS". The source code begins in line 21 of
(include) program "RSDBSPJS".
>>>>> UPDATE VARINUM connection R/3*VARINUM
59 SET VNUMBER = VNUMBER + 1
60 WHERE NUMID = VARINUM-NUMID
61 AND REPORT = VARINUM-REPORT.
Read more...
Environment
- SAP_BASIS < SAPKB70223
- SAP_BASIS < SAPKB73128
- SAP_BASIS < SAPKB74024
- SAP_BASIS < SAPK-75019INSAPBASIS
- SAP_BASIS < SAPK-75111INSAPBASIS
- SAP_BASIS < SAPK-75207INSAPBASIS
- SAP_BASIS < SAPK-75305INSAPBASIS
- SAP_BASIS < SAPK-75403INSAPBASIS
- SAP_BASIS < SAPK-804I2INSAPBASIS
Keywords
VARINUM, deadlock, lockwait, lock wait, DBSQL_SQL_DEADLOCK_DETECTED, RSDBSPJS , KBA , BC-ABA-TO , Selection Variants, Selection Screen Services , 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.