topic Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions

ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Wed, 17 Jun 2009 11:45:21 GMT

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

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

former_member212005 — Wed, 17 Jun 2009 11:50:09 GMT

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

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

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Wed, 17 Jun 2009 11:55:00 GMT

Hi,

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

Regards

Karthik D

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Wed, 17 Jun 2009 12:16:33 GMT

No,

Thanks,

Vrajesh

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Wed, 17 Jun 2009 12:18:08 GMT

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

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Wed, 17 Jun 2009 12:19:52 GMT

Hi,

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

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

Regards

Karthik D

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Wed, 17 Jun 2009 12:21:01 GMT

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.

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Wed, 17 Jun 2009 12:25:25 GMT


> 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

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 18 Jun 2009 05:08:03 GMT

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

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 07 Jul 2009 11:34:39 GMT

I got solution outside Forum.

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

former_member212005 — Tue, 07 Jul 2009 13:13:32 GMT

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

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 07 Jul 2009 14:23:55 GMT

I refreshed the Quality server with PRD data.

thanks,

vrajesh