16
Versions earlier than 15.0:
The last page %ld in sysindexes for table '%.*s' has next page # %ld in its page header. The next page # should be NULL. Please check sysindexes.
Version 15.0 and later:
The last page of table '%.*s' is recorded in sysindexes as page number %d, partition ID %d. In its header, this page has page number %d as its 'next page'; however, the 'next page' value should be NULL. Check sysindexes.
The sysindexes table lists each table and index, and the segment where each table, clustered index, nonclustered index, and chain of text pages is stored. It also lists other information such as the first page and root for the object. For heap tables (those with no clustered index), the root entry points to the last page in the table's data page chain.
Adaptive Server expects to find a value of zero for the next page number on the last page for a table (meaning that there are no more pages in the page chain). Error 2575 is raised when dbcc checktable or dbcc checkdb is run, and the next page number in the table’s last page is not zero. This error is caused by an incorrect root page value for the table in sysindexes, or corruption in the table’s last page.
If this is the only error message you see when you run dbcc checktable or dbcc checkdb, it is likely that the table’s root entry in sysindexes is incorrect. Use one of these options to recover from the problem:
Select the table data into a new table, drop the old table, and rename the new table to the old table name. Run dbcc checktable to check that the problem has been resolved.
Bulk copy the affected table out, drop and re-create the table, and bulk copy back in. This is the most efficient solution for a very large table. Run dbcc checktable to confirm that the problem is resolved.
For more information about how to copy a table in a new table or file, refer to “Rescuing data from a corrupted table” in the chapter “Other Useful Tasks” in the most recent version of Troubleshooting and Disaster Recovery.
Call Sybase Technical Support. They may be able to determine the correct last page number and patch the table’s root entry in sysindexes.
If you see other errors in addition to error 2575, the problem may be more extensive. Follow the instructions in this manual for handling those errors.
Before calling Sybase Technical Support, have the information listed in “Reporting errors” available, including the output of dbcc checktable or dbcc checkdb.
All versions
