SAP Knowledge Base Article - Preview

3568053 - "duplicate key found" error during InfoObject activation

Symptom

During the Infoobject activation the following error can be seen in the logs:

  • SQL Exception with SQL code 129:
    transaction rolled back by an internal error: cannot CREATE UNIQUE INDEX;
    duplicate key found: [5] several documents with the same ID exist in the index;
    content not unique, cannot define unique constraint, object=SS4::SAPABAP1:/BI0/KDATEen
    Table /BI0/KDATE (error adjusting the database)
  • Unique Index on SID Missing on Table: <SID or Hierarchy SID table>
  • SID-2 found in Table:<SID or Hierarchy SID table> 2times:


Read more...

Environment

SAP BW/4HANA

SAP NetWeaver 7.x

Product

SAP BW/4HANA all versions ; SAP NetWeaver all versions

Keywords

CREATE UNIQUE INDEX, duplicate key, 0DATE, Hierarchy SID table , KBA , BW-WHM-DBA-IOBJ , InfoObjects , BW-BEX-OT-OLAP , Analyzing Data , BW4-DM-MD , Masterdata , BW4-ME-IOBJ , InfoObjects , 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.