SAP Knowledge Base Article - Preview

3718657 - Duplicate key error during upgrade phase MAIN_SHDIMP/PARMVNT_SHD in SAP ERP for table ECLOG_DATA

Symptom

  • Error message: "SQL-error '349-cannot CREATE UNIQUE INDEX; duplicate key found' in DDL statement for 'ECLOG_DATA'".
  • Duplicate key entries detected in shadow table ECLOG_DATA~ during the upgrade process.
  • Discrepancy in record count between original table ECLOG_DATA and shadow table ECLOG_DATA~.
  • Upgrade process stuck in phase MAIN_SHDIMP/PARMVNT_SHD.


Read more...

Environment

SAP ERP 6.0

SAP HANA PLATFORM EDITION 2.0

Keywords

duplicate key error, SQL-error 349, MAIN_SHDIMP/PARMVNT_SHD, shadow table, ECLOG_DATA, ECLOG_DATA~, HANA database upgrade, SAP ERP upgrade, Software Update Manager, record count discrepancy, unique index creation error, duplicate entries, upgrade phase repetition. , KBA , HAN-LM-UPG-DB , Upgrade of HANA Database , 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.