cancel
Showing results for 
Search instead for 
Did you mean: 

Runtime Errors - SAPSQL_ARRAY_INSERT_DUPREC

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

This error are mainly due to number range please check the number ranges for the object in SNRO T code and for the corresponding obejct and it will solved and any number ranges buffers is there please remove the number range buffers.

Former Member
0 Kudos

Thanks Rajesh kumar,

Issue has been solved.

Rahul_Chandran
Newcomer
0 Kudos
Which object you have refrerred here

Answers (1)

Answers (1)

Lakshmipathi
Active Contributor
0 Kudos

Check these threads

[ Update terminate:|]

[Sales order create dump |]

thanks

G. Lakshmipathi