23
Unable to find row in sysindexes for clustered index on system catalog %d in database %d. This index should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.
This error can be caused by a hardware problem.
This error occurs when Adaptive Server is unable to access the sysindexes table for a database.
Error 903 can occur under the following circumstances when Adaptive Server accesses sysindexes:
Actions that involve opening a database since those actions access the sysindexes table for that database (for example, database recovery)
Actions that need to access columns in sysindexes. Such actions include:
order_by clause compilation.
Running the update statistics command.
Threshold Manager space calculations. Refer to the chapter “Managing Free Space with Thresholds” in the System Administration Guide: Volume 2.
Possible causes of error 903 are:
A problem has occurred with the device on which sysindexes resides and sysindexes has become corrupted.
The partition on which the database resides has been mounted as a file system or overlapping partitions exist. Refer to “Choosing between raw partitions and UNIX files” in the chapter “Other Useful Tasks” in the most recent version of the Troubleshooting and Disaster Recovery guide.
An Adaptive Server problem.
Determine whether the device on which the database resides is damaged and solve any problems that exist.
If the database named in the error message is accessible, run dbcc checkdb and dbcc checkcatalog to determine whether the database is corrupted. If the database is corrupted, restore it from backup.
If you cannot find any device problems and the database is not corrupted, call Sybase Technical Support.
Before calling Technical Support, have the information listed in “Reporting errors” available, including the output from:
select * from <database_name>..sysindexes where id=object_id(“sysindexes”), and
dbcc checkdb and dbcc checkcatalog.
All versions
