SAPSQL_ARRAY_INSERT_DUPREC error when copying user profile

Former Member — Wed, 09 Jul 2014 12:31:02 GMT

Hi,

When copying a user profile, the following ABAP dump happened. Can anyone please let me know if there is an OSS note for this issue?

Runtime error: SAPSQL_ARRAY_INSERT_DUPREC

Exception : CX_SY_OPEN_SQL_DB

ABAP prog : CL_PERS_ACCESS_MM_PUR=========CP

Error Analysis:

An exception has occurred which is explained in more detail below. The

exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in

procedure

"IF_PERS_EXTERNAL_TABLE~SAVE_BUFFER" "(METHOD)", nor was it propagated by a

RAISING clause.

Since the caller of the procedure could not have anticipated this

exception, the current program was terminated.

The reason for the exception is:

When an Open SQL array insert is performed, trying to insert a record

into the database causes the function to terminate if a record with the

same key already exists.

(When an Open SQL individual record insert is performed, this situation

does not cause the function to terminate. SY-SUBRC is set to 4

instead.)

The database table was "ESDUS".

Thanks.

Re: SAPSQL_ARRAY_INSERT_DUPREC error when copying user profile

FredericGirod — Wed, 09 Jul 2014 12:32:33 GMT

Hi,

did you have check your range number (SNRO / TNRO) haven't been modified ?

regards

Fred

DieterLorenz — Wed, 08 Oct 2014 09:17:25 GMT