Monday, October 3, 2016

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.


No comments:

Post a Comment