on 02-21-2012 9:13 PM
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
Dear SDN,
I have finally found the reason of the issue.
1. In RZ10, I only have version 0001 of my instance profile xx_DVEBMGSxx_hostname.
2. But in tabel TPFET, in the db, I also had version 0002 of the instance profile xx_DVEBMGSxx_hostname.
This is the reason of SAPSQL_ARRAY_INSERT_DUPREC.
Best regards
SAP NetWeaverAdmin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Even i had the same issue when the system is cloned/system refreshed from production.
you need to goto se14 and TPFET tabel then select the option to delete the data and activate and adjust the database table. which will eventually delete the prod entries from the table.
then you will be able to import the profiles in RZ10.
Regards
Omkar
1. Check for duplicate profile or remove older profiles @ OS Level.
2. Try to import the profiles again in RZ10 - try again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.