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 PLATFORM EDITION 2.0
Product
SAP ERP 6.0
Keywords
QCM, QCM8, SQL-error 289, duplicate index, SUM, PARMVNT_SHD, EQUI , 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.