A weird dump that cannot be reprodeced every time

[Former Member]

Hi folks,

I'm doing PCUI enhancement for account, and right now I encountered this issue:

When user try to create an account with general fields together with marketing attributes filled in, and save, there's a dump occured. But not every time we try there will be a dump, only occationally. The error log in st22 is as follows:

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

Occurred on 2009-02-13 at 16:48:10

Source code extract

000010 FUNCTION crm_bupa_frg0040_save_tabs.

000020 *"

000030 ""Verbuchungsfunktionsbaustein:

000040 *"

000050 ""Lokale Schnittstelle:

000060 *" TABLES

000070 *" IT_FRG0040_INSERT STRUCTURE CRMM_BUT_FRG0040

000080 *" IT_FRG0040_UPDATE STRUCTURE CRMM_BUT_FRG0040

000090 *" IT_FRG0040_DELETE STRUCTURE CRMM_BUT_FRG0040

000100 *" IT_FRG0041_INSERT STRUCTURE CRMM_BUT_FRG0041

000110 *" IT_FRG0041_UPDATE STRUCTURE CRMM_BUT_FRG0041

000120 *" IT_FRG0041_DELETE STRUCTURE CRMM_BUT_FRG0041

000130 *" IT_FRG0042_INSERT STRUCTURE CRMM_BUT_FRG0042

000140 *" IT_FRG0042_UPDATE STRUCTURE CRMM_BUT_FRG0042

000150 *" IT_FRG0042_DELETE STRUCTURE CRMM_BUT_FRG0042

000160 *"

000170

000180 * Clear unused workareas.

000190 CLEAR it_frg0040_insert.

000200 CLEAR it_frg0040_update.

000210 CLEAR it_frg0040_delete.

000220 CLEAR it_frg0041_insert.

000230 CLEAR it_frg0041_update.

000240 CLEAR it_frg0041_delete.

000250 CLEAR it_frg0042_insert.

000260 CLEAR it_frg0042_update.

000270 CLEAR it_frg0042_delete.

000280

000290 IF NOT it_frg0040_insert[] IS INITIAL.

> INSERT crmm_but_frg0040 FROM TABLE it_frg0040_insert[].

000310 ENDIF.

000320

000330 IF NOT it_frg0040_update[] IS INITIAL.

000340 UPDATE crmm_but_frg0040 FROM TABLE it_frg0040_update[].

000350 ENDIF.

Can anyone provide help of suggestions on this?

Thanks

[Former Member]

Thanks for your reply.

This issue is resolved.

[athavanraja]

since this is happening in the standard code, would suggest you to search OSS.

its a case of duplicate keys and generally to handle this the insert stt. should have had

FROM TABLE itab [ACCEPTING DUPLICATE KEYS]

or exception handling should have been in place.

Regards

Raja