SAP Knowledge Base Article - Preview

3113687 - Deadlock or lockwait on table VARINUM

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.