2469364 - Locks in table NRIV

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

• Performance issue is identified in the system.
• Many work processes waiting for NRIV table, showing SAPLSNR3 report:
      
  
• Instance may get unresponsive, due to lack of DIA work processes.
• 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".
   (...)

The termination occurred in ABAP program or include "SAPLSNR3", in "READ_NRIV".
>>>>> SELECT SINGLE FOR UPDATE * FROM nriv

SAP NetWeaver release independent

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