Number range issue

[Former Member]

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

[Former Member]

Solved

[Former Member]

Solved

[Former Member]

Solved

[Former Member]

Hello yogita.

Can you tell me how did you solve this issue?

Thank you

[former_member213682]

HI Yogita,

Could you post the solution for your problem?

Regards,

Siva.