SAP Note 678501 - System stoppage, locks on table NRIV

Component : Number Range Management -

Solution : https://service.sap.com/sap/support/notes/678501 (SAP Service marketplace login required)

Summary :
This SAP Note addresses performance issues due to unbuffered accesses on the NRIV table, leading to significant system delays and potential hangs. The problem originates from applications performing direct database locks on NRIV intervals, obstructing additional number retrievals and thereby serializing operations. The solution includes identifying the problematic number range objects via procedures outlined in reference Note 572905 and considering buffer implementations from Note 504875. For countries with legal sequential numbering requirements, alternative buffering strategies must be evaluated carefully. Developers should avoid modifications to standard SAP-delivered number range objects unless guided by specific SAP Notes.

Key words :
customer component bc-srv-num number range management priority recommendations / additional info category consulting validity, unbuffered number ranges 504875   buffering number ranges 179224   doc, __%pdfstyle%__ / } symptom system performance, unbuffered number ranges 504875   buffering number ranges, unbuffered number ranges 62077   info, oracle enqueues 1445374   number range buffering, table nriv 1445374   number range buffering, / __%pdfstyle%__font-size, software component version references, unbuffered number ranges 1091025   data_offset_too_large

Related Notes :

1445936RPCIPE01: Lock in table NRIV
1445374Number range buffering for earmarked funds (IRW_BELEG)
1398444Buffering the document number assignment for RF_BELEG
1091025DATA_OFFSET_TOO_LARGE in SAPLSNR3
1060996
825176Termination DBIF_RSQL_INVALID_RSQL in collective billing run
745639FAQ: Oracle enqueues
572905NR: Unbuffered number ranges
504875Buffering number ranges
179224Doc.no.assignment for unbuffered number ranges
62077Info: Internal number assignment is not continuous
1679514Material, customer, vendor numbers not assigned continuously