Error 12326

Severity

21

Message text

Table Corrupt: Free offset in page header is not reasonable; free offset should be >= %1! and <= %2!; check this page and offset (page#=%3! freeoffset on the page header=%4!).

Explanation

While attempting to delete a row in an all-pages-locked (APL) table the value in the page header for the free offset was found to be outside the legal values.

Action

To get the header of the page with the error do the following:

  1. Use the dbcc page command to display information about the page in question. Here is the syntax:

       dbcc traceon (3604) 
    
       dbcc page (<database_name>, <page_number>)
    
  2. Check the HEADER section for the object ID. Adaptive Server Enterprise version 15.0 and laster displays the object ID in the ptnid field.

    Adaptive Server Enterprise versions earlier than 15.0 display the object ID in the objid field. Once you know the object ID, get the name of the object in the affected database:

       select object_name(objectid)
    
  3. Run dbcc checktable on that object to check for any corruption.

Additional information

This error may be the result of a hardware error or misconfigured database device.

Depending on the extent of corruption, you may need to recover from backup or you may be able to rescue the data. See the section “Rescuing data from a corrupted table” in the Troubleshooting and Disaster Recovery guide.

Versions in which this error is raised

Version 12.5.1 and later