Server Error Messages 800 - 899

Number

Severity

Text and Explanation

801

20

 Process %d tried to remove resource lock it doesn't hold on buffer 0x%lx - %S_PAGE in cache %s.

Explanation: Check the Adaptive Server error log for 1105 or other errors. Restart Adaptive Server.

803

20

 Unable to place buffer `0x%lx' from cache `%.*s' holding logical page `%ld' in sdes for object `%.*s' - either there is no room in sdes or buffer already in requested slot.

Explanation: Refer to the writeup for this error.

804

20

 Unable to find buffer `0x%lx' from cache `%.*s' holding logical page `%ld' in sdes `0x%lx' kept buffer pool for object `%.*s'.

Explanation: Refer to the writeup for this error.

805

21

 Unable to find descriptor for object `%.*s' in database `%.*s' in hash table when marking buffer dirty or flushing syslogs.

Explanation: Report the error to your System Administrator. (Not raised in Release 11.0 and higher.)

806

21

 Could not find virtual page for logical page %ld  in database `%S_DBID'.

Explanation: Refer to the writeup for this error.

807

10

 Logical page %ld in buffer 0x%lx already kept in SDES for object `%.*s' in database `%.*s'.

Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. (Not raised in Release 11.0 and higher.)

808

20

 Alloc page buffer pool in Pss is full - logical pages %ld, %ld, and %ld in respective databases `%.*s', `%.*s' and `%.*s' are already held there. Cannot add logical page %ld in database `%.*s'.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

809

20

 Buffer 0x%lx, alloc pg %ld, in database `%.*s' not in alloc buf pool in Pss.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

810

20

 Attempt to pin log page buffer.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.)

811

21

 Attempt to grab buffer (from cache `%.*s') which is on descriptor chain.

Explanation: Report the error to your System Administrator. Adaptive Server must be restarted and DBCC diagnostics run. This error occurs in diagserver.

812

21

 Attempt to grab a pinned buffer. 

Explanation: Adaptive Server encountered an internal error affecting all current processes. The server must be restarted.

813

20

 Logical page `%ld' in database `%S_DBID', cache `%.*s' is already hashed.

Explanation: Refer to the writeup for this error.

814

20

 Keep count of buffer `0x%lx' in cache `%.*s' holding logical page `%ld' in database `%.*s' has become negative.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

815

21

 Unable to find buffer holding sysindexes page in the cache - pageno = %ld dbid = %d.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

816

20

 Process %d tried to remove a buffer resource lock %S_BUF that it does not hold in SDES %S_SDES.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.

817

20

 Process %d tried to remove a buffer resource lock %S_BUF that it does not hold in Pss 0x%lx.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

818

19

 There is no room to hold the buffer resource lock %S_BUF in SDES %S_SDES.

Explanation: Command failed when a configurable limit was exceeded. Reconnect to Adaptive Server and report the error to your System Administrator.

819

19

 There is no room for process %d to hold buffer resource lock %S_BUF in Pss.

Explanation: Command failed when a non-configurable limit was exceeded. Adaptive Server could not recover gracefully. Reconnect to Adaptive Server, and report the error to your System Administrator.

820

21

 Attempt to dirty non-log buffer %S_BUF which is in I/O.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

821

20

 Attempt to unhash buffer in cache `%.*s' at `0x%lx' with a buffer pageno of `%ld' and database id `%ld' with HASHED status set failed - buffer was not found. `%S_PAGE'.

Explanation: Refer to the writeup for this error.

822

21

 Could not start I/O for request BLKIO flags = 0x%lx, size = %ld, errcode = 0x%lx, %S_BUF.

Explanation: Refer to the writeup for this error.

823

24

 I/O error detected during %S_MSG for %S_BUF.

Explanation: Refer to the writeup for this error.

824

21

 Attempt made to write page in buffer in database that has no entry in sysdatabases. %S_BUF.

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator. Adaptive Server must be restarted and DBCC diagnostics run. (Not raised in Release 11.0 and higher.

825

21

 Attempt made to write page in buffer in database with no DBTABLE structure - sysdatabases row marked as in use by process %d. %S_BUF.

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator. Adaptive Server must be restarted and DBCC diagnostics run. (Not raised in Release 11.0 and higher.

826

20

 Attempt made to hold allocation page %ld that is already in Pss pool. Database `%.*s'.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.

827

20

 Attempt to dirty unkept page `%ld' in database `%.*s', cache `%.*s'.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

829

21

 A problem with ordered writes was detected.  Please call SYBASE.

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator. Adaptive Server must be restarted and DBCC diagnostics run. (Not raised in Release 11.0 and higher.

830

20

 Invalid magic number %ld for aux kept buffer structure 0x%x, for sdes 0x%x, object id %ld.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

831

20

 Unable to find buffer 0x%x holding logical page %ld in sdes 0x%x, aux keep struct 0x%x, for object `%.*s'.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

832

20

 Unable to place buffer 0x%x holding logical page %ld in sdes for object `%.*s' - there is no room in sdes aux keep pool.

Explanation: Adaptive Server encountered an internal error or an error due to lack of resources. Report the error to your System Administrator.

833

20

 Attempt to read logical page %ld, database `%S_DBID' into buffer 0x%x that is hashed.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

834

20

 Illegal attempt to clean buffer: %S_BUF.

Explanation: Refer to the writeup for this error.

835

20

Illegal attempt to change contents of buffer: %S_BUF. 

Explanation: Shut down and restart Adaptive Server to clear the buffer structure.

836

21

 Attempted to grab lru header.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

837

21

 Attempted to grab wash header.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

838

21

 Grabbed buffer not marked in wash: %S_BUF.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

839

21

 Grabbed buffer dirty but not writing: %S_BUF.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

840

17

 Device `%.*s' (with physical name `%.*s', and virtual device number %d) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.

Explanation: Refer to the writeup for this error.

841

10

 Attempt to set bufreserves in RESOURCE structure to negative value while unclaiming cache.

Explanation: This is an informational message but may require follow-up action. Contact your System Administrator.

842

20

 Attempt to set bufclaims in PSS structure for process %d to negative value while unclaiming cache.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

843

20

 Unable to find original instance of buffer `0x%x' holding logical page `%ld' in cache `%.*s' for object `%.*s'.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

844

20

 Attempt to unpredirty buffer %S_BUF which is %s.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

845

20

 Attempt to do a large I/O for page %ld in database `%.*s' with buffer 0x%x, which is not a large buffer.

Explanation: Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.)

846

10

 Hardware error detected writing logical page `%ld', virtual page `%ld' for dbid `%ld', cache `%.*s'. The user process will sleep until write completes successfully.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

847

10

 Checkpoint process detected hardware error writing logical page `%ld', virtual page `%ld' for dbid `%ld', cache `%.*s'. It will sleep until write completes successfully.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

848

21

 Could not start I/O for device `%.*s' (with physical name `%.*s', and virtual device number %d).  Operating system error %d.

Explanation: Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.)

849

21

 I/O error detected for device `%.*s' (with physical name `%.*s', and virtual device number %d).

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

850

20

 Wrong cache descriptor in buffer `0x%x', page `%d', dbid `%d'. Cache descriptor points to cache `%.*s'.

Explanation: Internal error with a buffer pointer. Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.)

851

20

 Wrong cluster mask for cache `%.*s', mask encountered = %d, should = %d.

Explanation: Internal error with a cache descriptor. Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.)

852

20

 Command Failed: Invalid request to move `%ld' buffers from the `%ld'K pool of the `%.*s' cache to the `%ld'K pool.  Source pool only contains `%ld' buffers.  Retry the command specifying fewer buffers.

Explanation: Refer to the writeup for this error.

853

16

 Invalid Configuration: Unable to start SQL Server since no information is available for configuring the data cache.  The server may be started with a default configuration using the -c startserver option.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

854

20

 Fatal buffer pool error.  Please contact Sybase technical support.

Explanation: Internal error in finding a buffer pool descriptor. Report the error to your System Administrator. (Not raised in Release 11.0 and higher.)

855

16

 Bad prefetch size of %d encountered.

Explanation: Refer to the writeup for this error.

856

16

 Command Failed: Cannot move buffers from the `%ld'K pool to the `%ldK' pool. `%ld'K pool does not exist.  Please specify a valid buffer pool.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.

857

16

 Command Failed: Cannot bind or unbind database `%S_DBID' to or from a cache because it is currently in use. Retry the command once all users have stopped using the database.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

858

16

 Cache `%.*s' does not exist.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.

859

20

 Invalid Buffer Cache Access: Attempt to locate page `%ld', database `%ld' in cache failed because the cache id `%ld' in scan_context is invalid.  Scan_context = {objid `%ld', indid `%ld', cid `%ld'}.  Contact Technical Support for assistance.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

860

20

 Invalid Buffer Cache Access: Attempt to locate page `%ld', dbid `%ld' objid `%ld', indid `%ld' in cache failed because the cache ID was not set in the scan_context structure.  Contact Technical Support for assistance.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

861

16

 Command Failed: Cannot bind object `%ld', dbid `%d' to cache because you have an open cursor on the target object.  Retry the command after closing the cursor.

Explanation: Refer to the writeup for this error.

862

16

 Command Failed: Database `%d' must be in single user mode to bind target object.

Explanation: Command failed. The database must be in single user mode to execute this command.

863

20

 Buffer resources in cache %s, id %d are unavailable. Please re-run this query or ask the system administrator to re-configure buffer cache memory.

Explanation: Refer to the writeup for this error.

864

16

 Command Failed: Cannot bind object `%ld', dbid `%d' to cache because you have active level0 scans on the target object. Retry the command after terminating the scans.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

865

21

 Error deleting row from Sysattributes during cache binding validation.

Explanation: Adaptive Server was unable to delete an existing row from sysattributes. This is an internal error affecting all processes using the current database. Report the error to your System Administrator.

866

21

 Error inserting row into Sysattributes during cache binding validation.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

867

16

 The system table Sysattributes or its indices may not be bound to a named cache.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

868

16

 The system table Sysallocpg may not be bound to a named cache.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.

869

21

 Error updating row %S_RID in Sysattributes during cache binding validation.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

870

10

 WARNING!!! You may have to change the log I/O size for the database `%.*s'. Current setting is `%dK' and the cache `%.*s' does not have a `%dK' memory pool.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

871

20

Process %d is trying to release a latch on buffer 0x%x (dbid: %d, pageno: %d) without holding a latch on the buffer.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

872

20

Process %d is trying to get a %s latch on buffer 0x%x (dbid: %d, pageno: %d) while already holding a %s latch on the buffer.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

873

20

Process %d is requesting %s latch on buffer 0x%x (dbid: %d, pageno: %d) while holding %d latches. A process can hold only %d latches at a time.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

874

20

Process %d is trying to unkeep buffer 0x%x (dbid: %d, pageno: %d) without releasing the %s latch it holds on t he buffer.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

875

20

 Unable to grab a buffer to allocate a page to the log in database id %d. Tried %d buffers in the wash but found them to be pinned (either directly or indirectly). See the error log for more information.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

876

20

The process is holding log semaphore on database %d and is about to sleep on mass=0x%x with stat=0x%x for page=%ld which is being written by some other  process that needs the log semaphore. This causes a deadlock, and can only be cleared by a reboot.

Explanation: Adaptive Server encountered an internal error affecting the current process. The System Administrator can clear the problem by restarting the server.

878

21

Task %d was expected to hold latch on buffer 0x%x of page %ld in database %d. 

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

879

21

Task %d was expected to hold exclusive latch on buffer 0x%x of page %ld in database %d. 

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

880

10

Your query is blocked because it tried to write and database ’%.*s’ isin quiesce state. Your query will proceed after the DBA performs QUIESCE DATABASE RELEASE.

Explanation: Your query cannot be processed at this time. Retry when the database becomes available.