During the "Preprocessing" in MAIN_SHDIMP/PARMVNT_SHD, the index creation fails with te following error:
Retcode 1: SQL-error "1505-The CREATE UNIQUE INDEX statement terminated because a duplicated key was found for the object name '<sid>.<tablename>~' and the index name '<indexname>'. The duplicate key value is (...)." in DDL statement for "<tablename>" error in DDL, nametab for "<tablename>" not activated.
- SAP NetWeaver system running on MS SQL Server database;
- Not restricted to a product or product version.
duplicated keys, duplicate key, duplicated index, mssql database, msqldb, mssqldb, duplicated key sqlserver, duplicate record, duplicated records, duplicated index, duplicate index, during upgrade, during upgradation, upgrade, upgradation, update, updatation, TATAF, shadow, shd, shd_sid, shadow instance, TATAF~, MAIN_SHDIMP/PARMVNT_SHD, MAIN_SHDIMP, PARMVNT_SHD, shadow, shd, mssql, msql, ms sql server, SQL10, SQL11, SQL12, SQL13, Microsoft SQL Server, sqlserver, sqlserv, sqlcmd , KBA , BC-DB-MSS-UPG , SQL Server Upgrades in SAP NetWeaver Products , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DWB-DIC-AC , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.