Runtime Errors - SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

Hi all,

I am facing following run time error after creating sales order (VA01). when i create sales order its generating sales order number. But when i go to the change mode (VA02) the following error occurs,

Note: Development server its working properly but in quality server i am facing this error

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Except. CX_SY_OPEN_SQL_DB

Date and Time 01.08.2009 13:51:43

Short text

The ABAP/4 Open SQL array insert results in duplicate database records.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLV05I" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

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

Missing RAISING Clause in Interface

Program SAPLV05I

Include LV05IU15

Row 1

Module type (FUNCTION)

Module Name SD_PARTNER_UPDATE

Trigger Location of Exception

Program SAPLV05I

Include LV05IU15

Row 480

Module type (FUNCTION)

Module Name SD_PARTNER_UPDATE

Thanks in advance

Babu

[Former Member]

Hi,

The issue is because of some userexit where you have changed the partner functions specifically making changes in the internal table XVBAP[] or YVBPA[].

There are duplicate entries in this table with the same key.

Probably someone has modified the table in some user exit and possibly not modfied the update flag (UPDKZ) with the correct value.

Go to SM13.

You will find your update termination.

Put a breakpoint at the statement where the FM SD_PARTNER_UPDATE is called.

Then restrart your sales order creation.

Before saving go into debug mode and the turn on update debugging and system debugging.

Then do F8.

The program should stop at the break-point.

Check the contents of the internal table which is passed to the I_XVBPA and I_YVBPA tables parameter of the FM.

Check if your uuser exits related to partner function are coded properly.

Regards,

Ankur Parab