SAPSQL_ARRAY_INSERT_DUPREC runtime error.

[Former Member]

Hello experts.

I have this ABAP dump. I tried searching on google but I can't find any document or link that will solve the problem. Hope you can help me solve the issue.

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

Date and Time 11/19/2010 14:17:40

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "BBP_BUPA_FRG0060_SAVE_TABS" "(FUNCTION)", nor was it propagated by a

RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

Information on where terminated

Termination occurred in the ABAP program "SAPLBBP_BUPA_FRG0060_SAVE" - in

"BBP_BUPA_FRG0060_SAVE_TABS".

The main program was "RSM13000 ".

In the source code you have the termination point in line 36

of the (Include) program "LBBP_BUPA_FRG0060_SAVEU03".

The program "SAPLBBP_BUPA_FRG0060_SAVE" was started in the update system.

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

procedure "BBP_BUPA_FRG0060_SAVE_TABS" "(FUNCTION)", but it was neither handled

locally nor declared

in the RAISING clause of its signature.

The procedure is in program "SAPLBBP_BUPA_FRG0060_SAVE "; its source code

begins in line

1 of the (Include program "LBBP_BUPA_FRG0060_SAVEU03 ".

Source Code Extract

27 if not it_frg0060_update[] is initial.

28 update bbpm_but_frg0060 from table it_frg0060_update[].

29 endif.

30

31 if not it_frg0060_delete[] is initial.

32 delete bbpm_but_frg0060 from table it_frg0060_delete[].

33 endif.

34

35 if not it_frg0061_insert[] is initial.

>>>>> insert bbpm_but_frg0061 from table it_frg0061_insert[].

37 endif.

38

Thank you in advance for all your help.

[Former Member]

WELCOME TO SDN

Most dicussed dump!

This must be a problem from functional end ask them to recheck the NUMBER RANGE specially.

Regards,

Edited by: Gagan Deep Kaushal on Nov 20, 2010 7:29 AM