SAP Knowledge Base Article - Preview

2237610 - Duplicate keys during MAIN_SHDIMP/PARMVNT_SHD


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.


SAP NetWeaver all versions


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.