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:

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

NoteThese errors may be due to hardware problems.

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.

NoteIf a Replication Agent is configured on this database, investigate replication solutions by contacting Sybase Technical Support.

Additional information

Refer to the write-up for “Error 605” for a discussion of potential causes of hardware errors.

Have the information available that is listed in “Reporting errors” before calling Sybase Technical Support, including the output of the dbcc checks from step 3 above.

Versions in which this error is raised

All versions