Error in NUMBER_GET_NEXT

[Former Member]

Hi All,

I am using FM 'NUMBER_GET_NEXT' to generate a unique number. But it is failing in production system sometimes.

In SNRO, we have done the following setting for the object -

To-year flag                             -
Number length domain         CHAR20
No interval rolling                    -


Number range transaction         -
Warning %                             10,0
Main memory buffering            yes

No. of numbers in buffer           10

Did someone encountered the same problem?

Regards,

Manish

Edited by: Manish Bisht on Jun 18, 2009 6:43 PM

[Former Member]

Hi All,

I am using FM 'NUMBER_GET_NEXT' to generate a unique number. But it is failing in production system sometimes.

In SNRO, we have done the following setting for the object -

To-year flag                             -
Number length domain         CHAR20
No interval rolling                    -


Number range transaction         -
Warning %                             10,0
Main memory buffering            yes

No. of numbers in buffer           10

Did someone encountered the same problem?

Regards,

Manish

Edited by: Manish Bisht on Jun 18, 2009 6:43 PM

[former_member723628]

Manish,

What do you mean by failing. Are you getting duplicate numbers or you are getting some other error? Please elaborate.

Why do you have buffering turned? Is it because by default system propses buffering turned on with the 10 numbers in buffer? Or it was an informed decision? If the answer is because system proposed it then I would suggest trying turning of the buffering. To turn off the buffering open you number range object in SNRO in change mode and go to menu path EDIT --> Setup Buffering --> No Buffering.

It is also important to note that in case you don't expect gaps in the number sequence then buffering is not recommended.

Regards,

Gajendra

[Former Member]

Hi Gajendra,

FM is failing - Its not generating a number.

Why do you have buffering turned? - I think its taken fro the standard one and not specific.

But why should i turn off buffering as the FM is used very regularly and keeping numbers in the buffer only leads to better performance. We are thinking of increasing the Numbers in Buffer. Will it help? Why or why not.

Please explain.

Regards,

Manish

[Former Member]

Hi,

Check your Number Range Buffer in Tcode SM56. Goto->Entries Enter Object, subobject(if any), range number to check the current status of the number.

Regards

Karthik D

[Former Member]

Can anyone help,

Whether to use numbers in buffer or not and why ?

Is there any other solution?

Regards,

Manish

[former_member723628]

Manish,

If the FM is not returning the any values is it getting terminated with exception?

As far as buffering is concerned it was a question based on the fact that

a) even one of the most common number range object RV_BELEG - SD document number range, has buffering turned off;

b) by default the buffering is turned on.

The reason in case of RV_BELEG is obvious, no gaps are expected in the generated numbers. Suggestion to turn off the buffering was to rule out possiblity of any memory related issues.

Regards,

Gajendra

[Former Member]

Solved by myself

[Former Member]

I am facing the same issue . Pl let me know the solution

bala