Error 691

Severity

20

Message text

Encountered invalid logical page '%ld' while accessing   object '%ld' in database '%d'. This is an internal system error.   Please contact Sybase Technical Support.

Explanation

This error occurs when Adaptive Server tries to access an object but requests an invalid page number. There are two possibilities:

• A negative page number is requested.

• Page number 0 (zero) is requested. To be more specific, a request is issued for page 0, which is an allocation page, as if it was a data page. Data pages do not use page ID 0. Corrupt page links or incorrect entries for the object in sysindexes can cause the server to request page 0.

Error 691 results in a stack trace and breaks your connection to Adaptive Server.

Action

Take the following steps:

1. Check the server error log for other errors that may have been raised prior to the 691 error. Save the entire error log.

2. Identify the object named in the error message using the following isql commands:

   1> use <database name>
   2> go
   

   
   1> select name from sysobjects where id=<object id>
   2> go
   

3. To determine the full extent of the corruption, run dbcc checkstorage, the dbcc checkdb and dbcc checkalloc commands, or dbcc checktable and dbcc tablealloc) as soon as possible.

4. To check if this error is a result of hardware failure, examine your operating system error log and correct hardware problems.

If the 691 error is not a soft error (one that exists only in memory), the problem is severe. Sybase Technical Support may be able to help you recover from the error. However this recovery procedure often results in loss of data; if this is unacceptable, you will probably need to restore from backups.

Additional information