SAP Knowledge Base Article - Preview

3573731 - Index creating is failed due to SQL error 289 cannot use duplicate index name

Symptom

Index cannot be created due to following error.

Could not execute 'ALTER TABLE "E071K~" ADD CONSTRAINT "E071K~0" PRIMARY KEY ...'
SAP DBTech JDBC: [289]: cannot use duplicate index name: E071K~0 or constraint name: E071K~0


Read more...

Environment

HANA 2.0

Product

SAP HANA, platform edition 2.0

Keywords

shadow table, database object with this name exists, SWPM, SAPAPPL1.log, instdir_import_monitor.log, dbrc = 102, database object with this name exists , KBA , HAN-DB , SAP HANA Database , How To

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.