Error 8402

Severity

Message text

Index row for object %ld (index id %d) was not found in database %d.

Explanation

Each database has a sysindexes table. The sysindexes Manager maintains and provides access to the rows of the sysindexes table. It handles inserting and deleting of sysindexes rows and manages the abort and recovery of individual operations performed on the rows. It also provides read/write access to the database information structure.

sysindexes contains one row for each:

Clustered index
Nonclustered index
Table that has no clustered index
Table that contains text or image columns

Error 8402 occurs when one of these rows is expected but not found for the object specified in the error message.

Action

Determine the name of the database mentioned in the error message:
```
1> use master
2> go
```
```
1> select db_name(<database_ID>)
2> go
```
Where <database_ID> is the database ID in the error message.
Search the sysindexes table for the object displayed in the error message:
```
1> use <database_name>
2> go
```
```
1> select * from sysindexes
2> where id = <object_ID>
3> go
```
Where <object_ID> is the object ID in the error message.
If the object is found in sysindexes, continue to step 4.

If the object is not found in sysindexes, call Sybase Technical Support.
If the object specified in the error message is not a system table (a system table’s object ID is less than 100), continue to step 5.

If the object specified in the error message is a system table, refer to “Fixing a corrupted system table index” in the chapter “Other Useful Tasks” in the most recent version of the Troubleshooting and Disaster Recovery guide for instructions on how to repair the system table index, then go to step 7.
Drop the index for the object specified in the error message.
Re-create the index. This clears the corruption in most cases.
Run dbcc checktable on the table to verify that the corruption is gone. If corruption still exists, call Sybase Technical Support.

Additional information

Refer to “drop index” and “create index” in the Reference Manual: Commands for information about dropping and re-creating indexes.

Versions in which this error is raised

All versions