A lot of blocking locks on NRIV daily

[former_member211576]

Hi experts,

Our system has a lot of blocking locks on NRIV. I use DMV to check and find many processes update RF_BELEG frequently. I find note 840901 can solve using parallel buffering, but our FI users do not agree sale document number without continuous chronological ascending order. Any solution from SAP or SQL server? Could SQL server parallel update NRIV table?

[Former Member]

Hello Dennis

You mentioned parallel buffering - do you mean the option available in SNRO (as compared to Main Memory) ... or was there something you did at the SQL level?

We have a very high volume set of Sales Order / Delivery / Invoice create interfaces (using BAPIs, not IDOCs) and I'm observing the blocking on NRIV within SQL as well. We are currently not buffering at all and are about to discuss with our tax/finance teams if they can accept number range gaps.

[former_member211576]

parallel buffering

[Former Member]

hi dennis,

this issue would be complicated since if you're not allowing your Apps server buffering NRIV than your SAP performance will decrease. this is because every transaction which require number need to be generated first every time your user save data to your SAP system.

This buffering technique is used to handle this issue so if your Apps server do not need to ask new number every time your user save their transaction data.

i have same issue when our external (public) auditor ask me than i ask for SAP support and then they explain about this. when i explain this issue to my external auditor, they understand this issue and they said no problem as long as this issue could be accepted.

ardhian

http://sapbasis.wordpress.com

http://ardhian.kioslinux.com