SAP Knowledge Base Article - Preview

2237610 - Duplicate keys during MAIN_SHDIMP/PARMVNT_SHD

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

SAP NetWeaver all versions

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.