Symptom
During a database copy with SUM using DBCLONE, the process ends with errors similar to:3 error(s) during parallel execution of processes, check 'DBCLONE_PROCS.ELG' for details
ERROR:
The following errors were detected in the log files:
# /usr/sap/sum/SUM/abap/log/DBCLONE01.T28:
3 ETGCLN START ACLPERMIS -> ACLPERMIS~ 20190403073913
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN DROP TABLE "ACLPERMIS~"
3 ETGCLN CREATE COLUMN TABLE "ACLPERMIS~" (
"INTF_NAME" NVARCHAR (000030) DEFAULT '' NOT NULL,
"CLIENT_PAK" NVARCHAR (000030) DEFAULT '' NOT NULL,
"WITH_SUBPACKS" NVARCHAR (000001) DEFAULT '' NOT NULL,
"POINT_2_POINT" NVARCHAR (000001) DEFAULT '' NOT NULL
) UNLOAD PRIORITY 5
3 ETGCLN ALTER TABLE "ACLPERMIS~" ADD CONSTRAINT "ACLPERMIS~0"
PRIMARY KEY("INTF_NAME", "CLIENT_PAK")
1EETGCLN cannot use duplicate index name: ACLPERMIS~0 or constraint name: ACLPERMIS~0
1EETGCLN ACLPERMIS
1EETGCLN Error when cloning table structure
3 ETGCLN START AIMTRKORR_SHD -> AIMTRKORR_SHD~ 20190403073913
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN DROP TABLE "AIMTRKORR_SHD~"
3 ETGCLN CREATE COLUMN TABLE "AIMTRKORR_SHD~" (
"TRKORR" NVARCHAR (000020) DEFAULT '' NOT NULL,
"AS4POS" NVARCHAR (000008) DEFAULT '00000000' NOT NULL,
"TRKORR_MRGFROM" NVARCHAR (000020) DEFAULT '' NOT NULL,
"METHODNAME" NVARCHAR (000030) DEFAULT '' NOT NULL,
"LOCKFLAG" NVARCHAR (000001) DEFAULT '' NOT NULL,
"AS4DATE" NVARCHAR (000008) DEFAULT '00000000' NOT NULL,
"AS4TIME" NVARCHAR (000006) DEFAULT '000000' NOT NULL,
"AS4USER" NVARCHAR (000012) DEFAULT '' NOT NULL
) UNLOAD PRIORITY 5
3 ETGCLN ALTER TABLE "AIMTRKORR_SHD~" ADD CONSTRAINT "AIMTRKORR_SHD~0"
PRIMARY KEY("TRKORR", "AS4POS")
...skipped more lines...
See DBCLONE_PROCS.html for more information.
The main error is:
1EETGCLN cannot use duplicate index name: <name> or constraint name: <name>
1EETGCLN Error when cloning table structure
Read more...
Environment
- SAP HANA DB Version 1.0
- SAP HANA DB Version 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
SUM, DBCLONE, SAP HANA, duplicate index name, duplicate constraint name, cannot use duplicate index name, table rename, RENAME TABLE, shadow tables, ~~OLD, ST22, SM21, DB02, missing indexes, missing tables , KBA , HAN-LM-UPG-SAP , Upgrade of SAP Systems on HANA , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview