ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

Hi,

I get following message

Transaction: VL01N

Update key... A5335BDE580FF1C393BE00215AD01E96

Generated.... 17.06.2009, 14:40:39

Completed.... 17.06.2009, 14:40:39

Error Info... ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

I am not able to save delivery document.

Thanks,

Vrajesh

[former_member212005]

This error...is because you were trying to insert duplicate entries...

Can you please write your codes here...which function module are you using..

[Former Member]

Hi,

Step 1

I created sales order in Va01 and saved it.

Step 2

I created delivery with reference to VL01n and saved it.

I got error message after second step.

Thanks,

Vrajesh

[Former Member]

Hi,

Go to SM13 and it will show you the update termination.

Put a breakpoint there and try to debug once again.

Turn on update debugging and it will come to the break-point in the update task.

At this point check the contents of the internal tables which are being transferred to the particular database table to check if there is any duplicate entry.

The reason for this duplicate entry might be some incorrect coding in a sales userexit.

Regards,

Ankur Parab

[Former Member]

Hi,

Did your server was down/Shut down recently due to any database related problems?

Regards

Karthik D

[Former Member]

No,

Thanks,

Vrajesh

[Former Member]

Hi,

Do you have implemented any enhancements/userexits/BADI which throws error messages/ uses Commit or Rollback statements in VLO1N?

OR

Do you have Number Range buffering ON of the Delivery document number( check in SNRO)?

Regards

Karthik D

[Former Member]

Try checking your Number RAnge for Sales Order.

It is giving Duplicate entry error may be because number range is being repeated.

Reset you NUmber Range Object with help of SD functional person.

[Former Member]

>

> Reset you NUmber Range Object with help of SD functional person.

In the case of the number range is being buffered the problem can be solved just by Resetting the Number range buffer not the entire number range.

Resetting number range buffer can be done in tcode SM56. You can also view the exact number status for your number range object there.

Regards

Karthik D

[Former Member]

I got solution outside Forum.

[former_member212005]

Vrajesh, what was the solution...can you please share it with us?

[Former Member]

I refreshed the Quality server with PRD data.

thanks,

vrajesh