ASE Error Message (600 – 649)

Number Severity Explanation
601 21 Descriptor for system table `%ld' in database `%d' not found in the descriptor hash table.

Explanation: Refer to the writeup for Error 601.
602 21 Could not find row in sysindexes for dbid `%d' / object `%ld' / index `%d'. Run DBCC CHECKTABLE on sysindexes.

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.
603 19 There are not enough system session descriptors available to run this query. Raise the value of the configuration parameter ’number of aux scan descriptors’ or retry your query later.

Explanation: Refer to the writeup for Error 603.
604 21 Could not find row in sysobjects for object `%ld' in database `%.*s'. Run DBCC checktable on sysobjects.

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.
605 21 An attempt was made to fetch logical page `%ld' in database `%.*s' from cache `%.*s'. Page belongs to object with id `%ld' not to object `%.*s'.

Explanation: Refer to the writeup for Error 605.
607 21 Insufficient room was allocated in the session descriptor for object `%.*s' for search arguments. Only %d search arguments were anticipated.

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.
608 0 Buffer holding logical page %ld of object '%.*s' in database '%.*s' was not kept in the first or second slot o f the session descriptor for that object during a scan.

Explanation: (Version 11.9.2 and higher.)
610 19 Maximum number of databases that may be accessed by a transaction is 16. This number has been exceeded by this query.

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.
611 21 Attempt made to end a transaction that is idle or in the middle of an update.

Explanation: Refer to the writeup for Error 611.
612 21 Attempt made to log a row of unknown type %d.

Explanation: Attempt made to write a log record of unknown type. Report the error to your System Administrator.
613 21 Request made to retrieve more rows from an already completed scan of object `%.*s' in database `%.*s'.

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.
614 21 Adaptive Server accessed a row that has an illegal length of %d while in data base ’%.*s’. %S_PAGE. The minimum row length is %d. The page size is %d.

Explanation: Refer to the writeup for Error 614.
615 21 Unable to find database table.

Explanation: Run dbcc checks on the database. (This error is not raised in Adaptive Server 11.0 and higher.)
616 20 Attempt to hash a previously hashed descriptor for object `%.*s' 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. (Not raised in 11.0 and higher releases).
617 20 Descriptor for object `%ld' in database `%d' not found in the hash table during attempt to unhash it.

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.
618 21 A varno of %d was passed to opentable – the largest valid value is %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.
619 20 A deferred update was requested but the query is not one of INSERT / DELETE or UPDATE.

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.
620 21 Log record encountered at deferred update time with either a row length of less than 2 or an invalid log type. The log type was %d and the row length was %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.
621 21 A log record was encountered of type %d that is not one of the valid deallocation types.

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.
622 20 Opentable was passed a varno of %d. Object ’%.*s’ in database ’%.*s’ already has that session descriptor in use. This occurred while opening object id %d in database id %d.

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.
623 21 Adaptive Server failed to retrieve a row via its RID in database ’%.*s’ because the target page is not a data page. %S_RID. %S_PAGE.

Explanation: Refer to the writeup for this error.
624 21 Adaptive Server failed to retrieve a row via its RID in database ’%.*s’ because the requested RID has a higher number than the last RID on the page. %S_RID. %S_PAGE.

Explanation: Refer to the writeup for this error.
625 21 Adaptive Server failed to retrieve a row via its RID in database ’%.*s’ because the entry in the offset table for that RID is less than or equal to 0. %S_RID. %S_PAGE.

Explanation: Refer to the writeup for this error.
627 20 A transaction tried to call beginupdate while in state `prepare'.

Explanation: There may be a problem due to an application issuing a PREPARE statement followed by an update. Check the application SQL code.
628 13 Attempt to issue `SAVE TRANsaction' when there is no active transaction.

Explanation: Rerun the command that raised this error.
629 21 Clustered index row entry for data page %ld is missing in index page %ld of table '%S_OBJID' in database '%S_D BID'; index row contains data page %ld instead. You can recreate the clustered index to fix this error. Xactid is (%ld / %d).

Explanation: Refer to the writeup for this error.
630 21 The end of page limit has been exceeded while building an offset table for object %ld on page %ld / page addr 0x%lx / eop addr 0x%lx / sargptr addr 0x%lx.

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.
631 21 The length of %d passed to delete row routine for the row at offset %d is incorrect on the following page: %S_PAGE. The expected row length is %d. The offset should be no greater than %d.

Explanation: Refer to the writeup for this error.
632 20 Memmove() was called with a length of %d – maximum allowed length is %d.

Explanation: The error may be caused by data corruption. Run dbcc checkdb on the database that was being accessed and correct any errors reported.
633 21 The PG_DEALLOC bit set by recovery is on at runtime on the following page. %S_PAGE.

Explanation: Report the error to your System Administrator. (Not raised in Release 11.0 and higher.)
634 20 Memmove() was called with an address of 0x%lx and a length of %d – which would cross the boundary address of 0x%lx.

Explanation: There is a possible Adaptive Server problem. Run dbcc checks on the database that was being accessed when the error occurred.
635 20 Process %d tried to remove DES resource lock that it doesn't hold – %S_DES .

Explanation: Report the error to your System Administrator. (Not raised in Release 11.0 and higher.)
637 20 Index shrink program returned invalid status of 0.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. Run dbcc indexalloc / checktable.
638 20 Memmove() was called with an address of 0x%lx – which is not allocated memory.

Explanation: There is a possible Adaptive Server problem. Run dbcc checks on the database that was being accessed when the error occurred.
639 21 Attempt to fetch logical page %ld dbid %d failed – page is not currently allocated.

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.
640 21 Attempt to insert/delete row on wrong type of page. %S_PAGE.

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.
641 21 Attempt to add BEGINUPDATE record in transaction %S_RID that already has an active CMD.

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.
642 20 Attempt to begin update in transaction %S_RID which already has an active transaction.

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.
643 20 Attempt to read page %ld in database `%.*s' which is not allocated.

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.
644 21 Index row entry for data row id (%ld / %d) is missing from index page %ld of index id %d of table ’%S_OBJID’ in database ’%S_DBID’. Xactid is (%ld / %d). Drop and re-create the index.

Explanation: Refer to the writeup for this error.
649 21 Could not find the clustered index entry for Page %ld Objid %ld status 0x%x. Index page %ld was searched for this entry in database `%.*s'.

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.

Credit: http://infocenter.sybase.com/help/index.jsp

You May Also Like

Leave a Reply?