NRIV Table Lock

Former Member — Fri, 04 Jul 2008 14:47:14 GMT

Hi,

I need a help on how to get NRIV table lock released ?

The users create Claims using portal as well R/3.

While creating claim, a number will be generated.

Problem is :

When users create claim , one user gets system hang and other are not able to create claim.

In DB01 we can see a lock on NRIV table HOLD status and DBTABLOG WAIT status.

Once this lock is released, the users are able to create claim as usual.

Program logic:

Thre is a number range used for Claim number.

This object is locked and unlocked by FM 'NUMBER_RANGE_ENQUEUE' and 'NUMBER_RANGE_DEQUEUE'.

To generate number : NUMBER_GET_NEXT is used.

This object is not buffered.

While Header table Enqueue , Lock mode is 'E'.

Suggestion i gave : To increase the buffer size. we can give No of number in buffer as 10 - 20.

But if so, how will the GAPS in the number generated would be. So user is afraid on this gap.

Please help me to get rid of this NRIV table lock.

Regards,

Priya

Re: NRIV Table Lock

Former Member — Fri, 04 Jul 2008 14:52:07 GMT

Check

the note 399207