SAP Knowledge Base Article - Preview

2469364 - Locks in table NRIV

Symptom

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

  • You notice general performance issues on the system.
  • Many work processes waiting for NRIV table, showing SAPLSNR3 report:
        
    SM50.jpg
  • Instance may get unresponsive, due to lack of DIA work processes.
  • General performance issues.
  • Different dumps may appear on ST22, showing SAPLSNR3 report: 

   Category ABAP Programming Error
   Runtime Errors TIME_OUT
   ABAP Program SAPLSNR3
   Application Component BC-SRV-NUM
   (...)
    Short Text
     Time limit exceeded
   (...)
    What happened?
     Program "SAPLSNR3" has exceeded the maximum uninterrrupted runtime and has
     therefore been terminated.

   Category Installation Errors
   Runtime Errors DBSQL_SQL_ERROR
   Except. CX_SY_OPEN_SQL_DB
   (...)
    Short Text
     SQL error "SQL code: xxxx" occurred while accessing table "NRIV".
   (...)

We can see on those dumps that the termination occurred in ABAP program or include "SAPLSNR3", in "READ_NRIV".
>>>>> SELECT SINGLE FOR UPDATE * FROM nriv


Read more...

Environment

SAP NetWeaver release independent

Product

SAP NetWeaver all versions

Keywords

lock, locks NRIV, work processes, NRIV, skipping numbering, SQL error "SQL code: -911" occurred while accessing table "NRIV",
SQL error "SQL code: 1205" occurred while accessing table "NRIV", SAPLSNR3, TIME_OUT, DBSQL_SQL_ERROR, Performance, Slowness, SM66,
SELECT SINGLE FOR UPDATE * FROM nriv , KBA , BC-SRV-NUM , Number Range Management , 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.