23
Could not locate row in sysobjects for system catalog %d in database %d. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.
This error can be caused by a hardware problem.
Adaptive Server expects to find certain information in static locations within a database or on the server:
Page 1 of each database is the first page for sysobjects
Page 24 of each database is the first page for sysindexes
As part of open database processing, the Descriptor Manager searches page 1 for entries for sysobjects and page 24 for entries for sysindexes. If the entries are not found on the expected page, error 906 occurs.
Error 906 occurs during open database actions such as recovery and create database. Other possible causes are:
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 Troubleshooting and Disaster Recovery.
A database device has been created that exceeds the operating system maximum size limit (for example, 2GB on some 32-bit machines).
Error 906 means that, for the database specified in the message, either page 1 or page 24 is corrupted. Restore that database from backup.
All versions
