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