Error 2507

Severity

16

Message text

Versions earlier than 15.0:

Table Corrupt: Offset table is incorrect (page#=%ld row#=%d offset in offset table is=%d correct offset is=%d)

Version 15.0 and later:

Table Corrupt: Offset table is incorrect (page number %d, partition ID %d; row number %d; offset in the offset table is %d; the correct offset is %d).

NoteThis error can be caused by a hardware problem.

Explanation

An “offset table” is stored at the end of every data page and indicates where rows are located on that page. Adaptive Server uses the offset table to quickly access the rows in each page.

Error 2507 occurs when dbcc checkdb or dbcc checktable detects inconsistencies in the offset table of a row on the page specified by the error message.

Action

Refer to “Identifying and fixing a corrupted table” in the chapter “Other Useful Tasks” in the most recent version of the guide Troubleshooting and Disaster Recovery.

WARNING! Some data on this page might be lost if you recover your table using bcp or select into (that is, the corrupted row and rows following it might be truncated and contain the wrong keys). Compare the two tables (old and new) row by row (by joining them on a primary key, for example) to determine which rows are different (corrupted).

Before dumping your database, make sure it is working correctly. More specifically, run the following commands prior to each dump:

  1. dbcc checkdb.

  2. dbcc checkalloc or dbcc checkalloc with the fix option. Refer to “Fixing and preventing allocation errors” in the chapter “Other Useful Tasks” in the most recent version of the guide Troubleshooting and Disaster Recovery for information about running these commands in multi-user mode and preventing false allocation errors from dbcc commands.

    NoteAlternatively, using dbcc checkstorage with checkverify can examine for most types of consistency problems in less time.


Hardware errors

In addition to the preceeding causes, hardware errors on database devices can cause error 2507. To rule out this possibility:

If problems persist, refer to the error documentation in this manual or contact Sybase Technical Support.

Additional information

Refer to bcp in the most recent version of the Adaptive Server Enterprise Utility Guide.

Refer to “select” in the Reference Manual: Commands for information about the select into command.

Before calling Sybase Technical Support, have information available that is listed in “Reporting errors”, including the output from dbcc checkdb, dbcc checktable, and dbcc checkalloc.

Versions in which this error is raised

All versions