SAP Knowledge Base Article - Preview

2838779 - Error "duplicate key found" when trying to recreate a missing primary index

Symptom

  • Transaction ST04 reports a missing primary index in a table.
  • When trying to create the missing index you get the following error:
cannot CREATE UNIQUE INDEX; duplicate key found: [5] Several documents with the same ID exist in the index;
<SCHEMA_NAME>:<TABLE_NAME>.$trexexternalkey$ content not unique, cannot define unique constraint. rowCount != distinctCount



Environment

  • SAP HANA 1.0 SPS12
  • SAP HANA 2.0

Product

SAP ERP 6.0 ; SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

HANA, ST04, index, duplicate, table, database, missing, primary index , KBA , HAN-DB , SAP HANA Database , BC-DWB-DIC , ABAP Dictionary , Problem

About this page

This 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.