topic Number range issue in Application Development and Automation Discussions

Number range issue

Former Member — Mon, 24 Sep 2007 19:49:56 GMT

Hi,

I am trying to create idoc wherein I am getting error :

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

I checked the details and error is at:

INSERT EDID4 FROM TABLE LIST_CONTAINER_CREATE

I checked the number range for object EDIDOC and it has NRLEVEL(current no) as <b>1700</b> which is same as displayed in t-code SNRO for the object EDIDOC.

But when I debug the issue, the next document number generated in FM 'NUMBER_GET_NEXT' is <b>1500</b>.

How's it possible?

In debug mode, I found below code which gets the next no.

Include LSNR3F01.

CALL 'ThNoGet' ID 'BNRIV' FIELD BNRIV

ID 'NO' FIELD G_NOIVBUFFER

ID 'QUAN' FIELD P_QUANTITY

ID 'PERCENT' FIELD TNRO-PERCENTAGE

ID 'NONRSWAP' FIELD TNRO-NONRSWAP.

Can somebody clarify this and help me how to solve this short dump issue?

Also when I check EDID4 table, it shows document nos like 1800?

How to solve this?

Regards,

Yogita

Re: Number range issue

Former Member — Mon, 24 Sep 2007 22:32:34 GMT

Solved

Re: Number range issue

Former Member — Mon, 24 Sep 2007 22:32:36 GMT

Solved

Re: Number range issue

Former Member — Mon, 24 Sep 2007 22:32:38 GMT

Solved

Re: Number range issue

Former Member — Wed, 04 Nov 2009 12:32:36 GMT

Hello yogita.

Can you tell me how did you solve this issue?

Thank you

Re: Number range issue

former_member213682 — Mon, 15 Apr 2013 12:25:02 GMT

HI Yogita,

Could you post the solution for your problem?

Regards,

Siva.