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

ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Sun, 15 Sep 2013 14:55:38 GMT

hi expert.

i have many change in read pp master data in co02.

when i want to save i one message comes with "Update was terminated with user xx" .when i go and see the description i see this error.

ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

how can i fix it?

thanks

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

former_member219961 — Sun, 15 Sep 2013 20:31:05 GMT

Hi,

I believe the information provided by you is not enough. Attach the whole short dump, or at least its Sections "Information on where terminated" and "Source Code Extract".

Best regards,

Maurício Grisa.

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 01:05:57 GMT

hi thanks for your reply.

when i click on read pp master data in co02 and then release operation and then save every thing is ok .when my system comes to main screen co02 after 1 on 2 second one email page poup with tittle "update was terminated with user xx" that this youser is my user that login.

when come to email box see this:

Update was terminated

Update was terminated

System ID....   R3D
Client....... 101
User..... xx
Transaction..   CO02
Update key... 9654521D298F4B5DB81B1F2A9D1C68F3
Generated....   15.09.2013, 20:14:43
Completed....   15.09.2013, 20:14:43
Error info...   ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

paul_bakker2 — Mon, 16 Sep 2013 01:06:37 GMT

Hi,

I assume you know that 'DUPREC' means duplicate record? In other words, a program is trying to write an entry to a database table, but an entry with that key already exists.

This can usually be fixed by checking before writing.

good luck

Paul

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 03:27:35 GMT

sorry. i want to explain my scenario,

we have an option in co02 for non pcnf orders ,with the name 'read pp master data'.

i change it .

my work was let pcnf orders use this option .after release operation everything be ok but after save i see the message of order xx save and then system comes to page co02 but after 2 second i see this message .

i check it with one order non pcnf every thing is same .

help me

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 06:02:57 GMT

i found that this update key first check in table VBMOD . i have this field because my status before this was "REL PCNF PRC CSER MANC SETC" and after this again "REL PCNF PRC CSER MANC SETC".

am i right ? how can i fix it ?

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

former_member188251 — Mon, 16 Sep 2013 06:06:05 GMT

Hi Maryam,

Try doing update debugging .

When you open CA02, give /h before Save.

To trigger update debugging, in the debugging screen after typeing /h, Then , press Save. The debgguer will start. Now goto,

System-->Display/Change Debugger Settings-->Update Debugging (tick the check box).

Then do F8.

At this point , all the update tasks are triggered and your debugging will stop at the first FM/subroutine that is triggered in update task. Most likely, the data base update that is giving the error is in one your update FMs.

BR,

Shankar.

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 11:27:36 GMT

hi thank you but i can not see Display/Change Debugger Settings

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

RaymondGiuseppi — Mon, 16 Sep 2013 11:30:03 GMT

Call transaction SM13, there look for the failed update FM.

(Read also Update Management at help.sap.com, look for Analyzing Canceled Updates.)

Regards,

Raymond

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

former_member219338 — Mon, 16 Sep 2013 11:30:25 GMT

Have a look at SAP hint 196113 - SAPSQL_ARRAY_INSERT_DUPREC

Regards,

Damian

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

former_member188251 — Mon, 16 Sep 2013 12:13:14 GMT

Hi Maryam,

Use the new debugger , you can see it.

BR,

Shankar.

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

SujeetMishra — Mon, 16 Sep 2013 12:19:53 GMT

Hi,

Please send the Dump's screen shot where exactly program is getting terminated?

Regards,

Sujeet

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 12:58:35 GMT

This dump can occurs if you use INSERT statement for internal table with duplicate rows. Are you using this in your code? Please, go to ST22 and find exact place in code where the problem occurs (it will be marked with ">>>>>>").

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 14:52:40 GMT

hi the fm is CO_VB_ORDER_POST

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 14:53:23 GMT

exactly after back to firs screen co02

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

Former Member — Mon, 16 Sep 2013 14:54:39 GMT

hi the messages comes exactly after system comes to main window of co02

Re: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

former_member298409 — Mon, 16 Sep 2013 16:18:18 GMT

Hello Maryam,

To know why it is giving Error:

Put a break point in enhancement and debugger mode change the System-->Display/Change Debugger Settings-->Update Debugging (tick the check box).

Root Cuase:

In this FM there is old values and new values was there so ur doing updating so make sure that updat indicatiors like RESB-VBKZ = 'U'

and give your BADI or Exit name so that I will update you more where it is getting trubble

Thanks,

Sekhar