topic Re: SAPSQL_ARRAY_INSERT_DUPREC error in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC error

Former Member — Fri, 16 Nov 2012 19:02:49 GMT

Hello all,

I've come across the above mentioned error while running Standard TX FMX1 in the following function module:

SAPSQL_ARRAY_INSERT_DUPREC -- runtime error

CX_SY_OPEN_SQL_DB -- exception

INCLUDE LFMR3U16. "FMR3_UPDATE_KBLKPW --FM

Portion of code where this error occurs:

*************************

1 function fmr3_update_kblkpw.

2 *"----------------------------------------------------------------------

3 *"*"Verbuchungsfunktionsbaustein:

4 *"

5 *"*"Lokale Schnittstelle:

6 *" IMPORTING

7 *" VALUE(INSERT) LIKE FMDY-XFELD OPTIONAL

8 *" VALUE(I_FLG_WAS_PARKED) LIKE BOOLE-BOOLE DEFAULT SPACE

9 *" TABLES

10 *" T_KBLK STRUCTURE KBLK OPTIONAL

11 *" T_KBLP STRUCTURE KBLP OPTIONAL

12 *"----------------------------------------------------------------------

13 if insert is initial.

15 * geparkte Zeilen vorher löschen

16 if i_flg_was_parked = con_true.

17 loop at t_kblk.

18 delete from kblp where belnr = t_kblk-belnr.

19 endloop.

20 endif.

22 * Update

23 modify kblk from table t_kblk.

25 modify kblp from table t_kblp.

27 else.

28 * Beim Insert doppelte Belegnummernvergabe verhindern

>>>> insert kblk from table t_kblk.

31 insert kblp from table t_kblp.

33 endif.

35 endfunction.

*******************************

I've read in several forums that applying a note could resolve this issue. However, I do not know which specific note to apply.

Any help with this will be greatly appreciated.

Thanks in advance

Re: SAPSQL_ARRAY_INSERT_DUPREC error

former_member206439 — Fri, 16 Nov 2012 19:20:33 GMT

the dump clearly says thats

you are try to insert a duplicate record

try to explore that you can find that value in Short dump details.

Re: SAPSQL_ARRAY_INSERT_DUPREC error

Former Member — Fri, 16 Nov 2012 22:17:47 GMT

Hello Juan,

Pls try to put the break point at the statement "insert kblk from table t_kblk." and execute the transaction and see what are the values inserting into the table kblk. I think those values are already exist in table kblk.

Also check with your functional consultant is there any process is done in a wrong way recently.

Shravan

Re: SAPSQL_ARRAY_INSERT_DUPREC error

juan_suros — Fri, 16 Nov 2012 23:52:56 GMT

There seem to be several notes that might apply to this situation. Here are the numbers with the symptoms text:

1054457 -

You call transaction F871 to enter a request with reference to a funds commitment. The request has at least two items, that refer to the same item in the funds commitment. When you save the request, the program terminates with a short dump.
When you update the KB tables (KBLE, KBLK.), a termination occurs in the INSERT_POS_IN_DB form.

1400545 -

You use the correction report RKMOBREP to correct commitment data for earmarked funds. When you do this, the system generates duplicate commitments.
If you run the payroll now, the update may terminate with the dump SAPSQL_ARRAY_INSERT_DUPREC.

419538 - At production startup, you delete all earmarked funds created in Funds Management with the report RFDLKBLX, in accordance with the IMG documentation. When you do this, the relevant commitments in CO are not deleted.