Skip to Content
0
Former Member
Feb 21, 2012 at 09:13 PM

SAPSQL_ARRAY_INSERT_DUPREC - When saving an instance profile from RZ10

446 Views

Dear SDN,

I have an issue when I try to save my instance profile from RZ10.

I always get a dump (ST22) :

==========================================================

Erreur d'exécution SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

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

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

==========================================================

In RZ10, I only have version 0001 of my instance profile (SID_DVEBMGSxxx_Hostname)

But in table tpfet, I have 2 version of the same profile.

I have already tried to remove the profile from RZ10 and try to re-import it.

I have get SAPSQL_ARRAY_INSERT_DUPREC error.

Thanks

SAP NetWeaver Admin