Error 2591

Severity

16

Message text

Could not find index row which has id %d for table ’%.*s’.

Explanation

Error 2591 is raised when you run a dbcc command if Adaptive Server is unable to find an index in sysindexes. The ’id %d’ parameter in the message text shows the index ID of the index that the dbcc command expected to find.

Error 2591 occurs with the following dbcc commands:

Error 2591 is raised with the following states:

State

Meaning

1

dbcc reindex is unable to locate a primary index row for a clustered index on a system table in sysindexes.

2

dbcc reindex is unable to locate a primary index row for a non-clustered index on a system table in sysindexes.

3

dbcc indexalloc is unable to locate the specified index in sysindexes.

Action

If the error was raised when using dbcc indexalloc, check the index name supplied in the command, and retry using the correct index name. To verify the available indexes for the table, type:

1> sp_help <table_name>
2> go

If the error was raised when using dbcc reindex, use an alternative method for correcting the index. Note the object name and index id appearing in the message text, and identify the object id as follows:

1> select object_id(’<table_name>’)
2> go

Then use the procedure described in “Fixing a corrupted system table index” in the chapter “Other Useful Tasks” in the most recent version of Troubleshooting and Disaster Recovery for instructions on how to repair the system table index.

Versions in which this error is raised

All versions