Error 2511

Versions earlier than 15.0:

Keys of index id %d for table ’%.*s’ in %S_MSG not in correct order. Drop and re-create the index. (index page %d)

Version 15.0 and later

Keys of index ID %d for table '%.*s' in %S_MSG are not in the correct order. Drop and re-create the index (index page %d, partition ID %d).

This error can be caused by a hardware problem.

This error occurs when an index is not correctly ordered.

There are three possible values of “%S_MSG” from the error message text:

Note the index ID and table name displayed in the error message output.
Depending on the type of object, select the most appropriate procedure:
- If the object with the error is not a system table (object ID is more than 100), go to step 3.
- If the object with the error is a system table, see “Fixing a system table corrupted index” in the chapter “Other Useful Tasks” in the most recent version of the guide Troubleshooting and Disaster Recovery for instructions on how to repair the system table index.
If the object with the error is a user table, find the name of the index involved by executing this query:
```
1> select name from sysindexes 
2> where indid = <index_ID>
3> and id = <object_ID>
4> go
```
Drop and re-create the index. Refer to “drop index” and “create index” in the Reference Manual: Commands for more information.
Verify that all problems have been resolved at the table level by running the dbcc checktable and dbcc tablealloc commands on the affected table.

If problems persist, contact Sybase Technical Support. Have the output from the appropriate dbcc commands available for their review.

All versions