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