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