SAP Knowledge Base Article - Preview

3428072 - SQL-error "289-cannot use duplicate index name"

Symptom

Index creation on a table fails with below error: 

SQL error 289: cannot use duplicate index name: <TABLE_NAME>~0 or constraint name:
<TABLE_NAME>~0
DDL time(___1): .........7 milliseconds
The SQL statement was not executed
Index could not be created completely in the database
Index <TABLE_NAME>-0 could not be created
Request for <TABLE_NAME> could not be executed


Read more...

Environment

SAP HANA

Product

SAP ERP 6.0

Keywords

QCM, SQL-error 289, duplicate index, SUM, PARMVNT_SHD , KBA , HAN-DB-ENG , SAP HANA DB Engines , 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.