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

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

QCM, QCM8, SQL-error 289, duplicate index, SUM, PARMVNT_SHD, EQUI , KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem