VL31 Error when Saving Data

[#1]

Dear All,

I am facing Runtime Error problem. This problem occure while i tried to save data.

For many days ago, i got a message when posting VL31N for number... but i didn't remember the full paragraph.

Now, it shows Runtime Error as below:

Runtime Errors	SAPSQL_ARRAY_INSERT_DUPREC
Except.	CX_SY_OPEN_SQL_DB

Please help....

Regards,

Ratana

[ratana_pouy]

VL31N also occured Runtime Error. I have already check SAP Note196113 - SAPSQL_ARRAY_INSERT_DUPREC, BALHDR.

Unluckily, my problem still occur. Do you have other solution?

Thank,

Ratana

[ajitkumar]

it is something about duplicate records. check number ranges. See whether you can get some more info in SM13. Is there any serial number assignment?

[ratana_pouy]

How to check Number Range?

[ajitkumar]

did you find out, whether it is a number range issue and if so which one is the problem?

If you know which object number range, the txn is SNRO, or you can access the number range from the configuration of that particular element

[ratana_pouy]

I didn't find out whether it is a number range issue or not. i still wonder, why while SAP is saving VL31N and then shows ABAP runtime error.

[JL23]

Please investigate the details in SM13  and read the dump as indicated earlier.Here you get all the info that you (or better your ABAPer)  need to analyse further.

Although it looks like an issue with a number range because the document number is usually a unique in the database,there are other possibilities for this issue.

But you are the only one who has this info that enables further analysis, we here can only guess based on this small info given.

SAPSQL_ARRAY_INSERT_DUPREC

here you see the word DUPREC which is an abbreviation of duplicate record. This usually describes a situation that you want add a record with the same keys for which there is already an existing record in a table.

[former_member192897]

Why donot you check this with your abaper? They could be able to help you to find our the rootcause of the issue.

[Former Member]

Hi Ratana Pouy,

VL31 this Transaction is outdated.

SAP recommends using the following transactions for delivery processing instead:

Outbound deliveries

1. VL01N   Create outbound delivery with order reference
2. VL01NO  Create outbound delivery without order reference
3. VL02N   Change outbound delivery
4. VL03N   Display outbound delivery

Inbound deliveries

1. VL31N   Create inbound delivery
2. VL32N   Change inbound delivery
3. VL33N   Display inbound delivery

Best Regards,

Nikhil Ghadge.

[Former Member]

Hi Ratana,

please check Note 196113 - SAPSQL_ARRAY_INSERT_DUPREC, BALHDR. If not helpfu, please post here the details and error analysis of the runtime error.

Regards, Maria