Error when deleting a full text index

[Former Member]

Hi,

I get the following error when trying to delete a full text index of a large table (more than 13 million rows/documents).

Could not execute 'DROP FULLTEXT INDEX TEXT_MINING.MEDLINE_INDEX' in 4:22.793 minutes .

SAP DBTech JDBC: [2048]: column store error: index delete error:  [6010801] message not found;object=TEXT_MINING:$TA_MEDLINE_INDEXen

Thanks for the help,

Mariana

[Former Member]

Can you provide your HANA version?

Looks like this is an internal error related the dictionary for the rowid column.

[Former Member]

This error message alone is unfortunately not really clear. The piece "6010801" could indicate the problem described in SAP Note 2135718 (i.e. a corruption in the underlying table), but that's just a first guess. Which revision do you use?

In order to find out more, you have to check the indexserver trace file for more error details. You may also run CHECK_TABLE_CONSISTENCY on the underlying table to identify corruptions (SAP Note 1977584).