Symptom
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.
Read more...
Environment
- SAP NetWeaver system running on MS SQL Server database;
- Not restricted to a product or product version.
Product
Keywords
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 , ABAP Dictionary Activation and Conversion , 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.