ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC error on co02

[Former Member]

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

[former_member219961]

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.

[Former Member]

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

[paul_bakker2]

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

[Former Member]

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

[Former Member]

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 ?

[former_member188251]

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.

[Former Member]

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

[former_member188251]

Hi Maryam,

Use the new debugger , you can see it.

BR,

Shankar.

[RaymondGiuseppi]

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

[Former Member]

hi the fm is CO_VB_ORDER_POST

[former_member219338]

Have a look at SAP hint 196113 - SAPSQL_ARRAY_INSERT_DUPREC

Regards,

Damian

[SujeetMishra]

Hi,

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

Regards,

Sujeet

[Former Member]

exactly after back to firs screen co02

[Former Member]

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

[Former Member]

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 ">>>>>>").

[former_member298409]

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