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:
- 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
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.