SAPSQL_ARRAY_INSERT_DUPREC error when copying user profile

[Former Member]

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.

[FredericGirod]

Hi,

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

regards

Fred

[DieterLorenz]

Found a note:  1597172 - SAPSQL_ARRAY_INSERT_DUPREC dump in SU01 when copying users