Hana Error: cannot use duplicate index name

sometimes adjusting table thru SE14 error occurs because table data is not valid in field type.

it has no short dump in ST22 but table is not activating with the message

'SQL exception SQL code 289 SQL message cannot use duplicate index name'.

in this case try to find out existing index on temp table generated while adjusting.

 

in tcode ST04, execute query below.

SELECT * from sys.indexes where table_name like '%CBO_TABLE%'

 

if you found the index execute DDL below

ALTER TABLE cbo_table DROP INDEX index_name