topic Re: DUMP " SAPSQL_ARRAY_INSERT_DUPREC " in Application Development and Automation Discussions

DUMP " SAPSQL_ARRAY_INSERT_DUPREC "

Former Member — Wed, 31 Dec 2008 07:28:20 GMT

Hi,

This dump happening some time and some time its working fine.

while executing VL10F it showing Dump like this .

what will be the cause ?

i debuged it . Its showing VBPA table .

how to find real cause ?

SAPSQL_ARRAY_INSERT_DUPREC

CX_SY_OPEN_SQL_DB

What happened?

Error in ABAP application program.

The current ABAP program "SAPLV05I" had to be terminated because one of the

statements could not be executed.

This is probably due to an error in the ABAP program.

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"SD_PARTNER_UPDATE" "(FUNCTION)"

Since the caller of the procedure could not have expected this exception

to occur, the running program was 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.)

Re: DUMP " SAPSQL_ARRAY_INSERT_DUPREC "

Azeemquadri — Wed, 31 Dec 2008 08:28:47 GMT

This means that the in the partner table VBPA a duplicate record (record with duplicate primary keys ) is being made. VBPA has sales Doc , Item and Partner Function as primary key. Make sure these are unique.

Re: DUMP " SAPSQL_ARRAY_INSERT_DUPREC "

Former Member — Wed, 31 Dec 2008 08:32:51 GMT

The record that u r trying to insert already exists ( means...another record with same PRIMARY KEY exists in the table ).

Kindly check.

Regards,

Rajat

Re: DUMP " SAPSQL_ARRAY_INSERT_DUPREC "

Former Member — Wed, 31 Dec 2008 09:03:17 GMT

Dear Jim

DUPREC -> Duplicate Record

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.

this is from your question itself.

Re: DUMP " SAPSQL_ARRAY_INSERT_DUPREC "

Former Member — Wed, 31 Dec 2008 09:11:09 GMT

In the program / user exits you are trying to update duplicate records in vbpa table, check internal table entries before insert to database

Regards

Sasi