ASE Access Method Errors (600s)

New Writeups: 632

Existing Writeups from Troubleshooting Guide:

601        21           Descriptor for system table '%ld' in database '%d' not found in the descriptor hash table.
602        21           Could not find row in sysindexes for dbid '%d', object '%ld',index '%d'. Run DBCC CHECKTABLE on sysindexes.
603        17           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.
604        21           Could not find row in sysobjects for object '%ld' in database '%.*s'.  Run DBCC checktable on sysobjects.
605        21           An attempt was made to fetch logical page '%u' from cache '%.*s'. Page belongs to %S_PTNINFO and not to %S_PTNINFO.
607        21           Insufficient room was allocated in the session descriptor for object '%.*s' for search arguments. Only %d search arguments were anticipated.
610        19           Maximum number of databases that may be accessed by a transaction is 16. This number has been exceeded by this query.
611        21           Attempt made to end a transaction that is idle or in the middle of an update.
612        21           Attempt made to log a row of unknown type %d.
613        21           Request made to retrieve more rows from an already completed scan  of object '%.*s' in database '%.*s'.
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.
615        21           Unable to find database table.
616        20           Attempt to hash a previously hashed descriptor for object '%.*s'  in database '%.*s'.
617        20           Descriptor for object '%ld' in database '%d' not found in the hash table during attempt to unhash it.
618        21           A varno of %d was passed to opentable - the largest valid value is %d.
619        20           A deferred update was requested but the query is not one of INSERT, DELETE or UPDATE.
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.
621        21           A log record was encountered of type %d that is not one of the valid  deallocation types.
622        20           Opentable was passed a varno of %d. Object '%.*s' in database '%.*s' already has that session descriptor in use. This occured while opening object id %d in database id %d.
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.
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.
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.
627        20           A transaction tried to call beginupdate while in state 'prepare'.
628        13           Attempt to issue 'SAVE TRANsaction' when there is no active transaction.
629        21           Clustered index row entry for data page %u is missing in index page %u of table '%S_OBJID' in database '%S_DBID'; index row contains data page %u instead.
                             You can recreate the clustered index to fix this error. Xactid is (%u,%d).
630        21           The end of page limit has been exceeded while building an offset table for object %d on page %u, page addr 0x%lx, eop addr 0x%lx, sargptr addr 0x%lx.
631        21           The length of %d passed to delete row routine for the row at offset %d is incorrect on the following page of database '%S_DBID': %S_PAGE.
                             The expected row length is %d. The offset should be no greater than %d.
632 *     20           Attempt to move memory with an incorrect length of %d. Maximum allowed length is %d.
633        21           The PG_DEALLOC bit set by recovery is on at runtime on the following page. %S_PAGE.
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.
635        20           Process %d tried to remove DES resource lock that it doesn't hold  - %S_DES .
637        20           Index shrink program returned invalid status of 0.
638        20           Memmove() was called with an address of 0x%lx - which is not allocated memory.
639        21           Attempt to fetch logical page %u dbid %d failed - page is not currently allocated.
640        21           Attempt to insert/delete row on wrong type of page. %S_PAGE.
641        21           Attempt to add BEGINUPDATE record in transaction %S_RID that already has an active CMD.
642        20           Attempt to begin update in transaction %S_RID which already has an active transaction.
643        20           Attempt to read page %u in database '%.*s' which is not allocated.
644        21           Index row entry for data row id (%u, %d) is missing from index page %u of index id %d of table '%S_OBJID' in database '%S_DBID'.
                             Xactid is (%u,%d). Drop and re-create the index.
649        21           Could not find the clustered index entry for Page %u Objid %d status 0x%x. Index page %u was searched for this entry in database '%.*s'.
650        26           Page %u of table '%.*s' (id = %d) in dbid %d not locked.
651        26           Startscan was called with an illegal combination of index and scan mode.
652        20           The buffer 0x%lx should be kept in sdes 0x%lx on entry to this function and it is not.
653        26           Buffer not rlocked. %S_BUF. %S_PAGE.
654        26           Page %u, dbid %d not exclusive locked.
655        26           Page should be marked as having overflow page: %S_PAGE.
656        26           Locking not stipulated while attempting to modify page.  %S_PAGE.
657        26           Passed buffer pointer for previous page is for page %u, when the actual previous page is %u. These pages are in database '%*.s'.
658        22           Last log page in database '%.*s' incorrectly identified as page %u. Run DBCC checktable on syslogs.
659        16           Table id %ld contains suspect indexes. This table is only available for read-only purposes until the DBCC REINDEX command has been 
                             run on the indicated table to rebuild its suspect indexes.
660        10           Index id %d cannot be used to access table id %d as it is SUSPECT. Please have the SA run the DBCC REINDEX command on the specified table.
661        21           As part of a transaction rollback, an attempt was made to modify object '%S_OBJID' in database '%.*s', even though
                             the current session is not holding an exclusive lock on that object.
662        18           The index with index id '%d' on object with object id = '%d' was not found during cursor scan fixups. The fixup was being done for cursor '%.*s'. This is an internal error.
663        18           The lock on page '%u' for object with object id = '%d' could not be obtained during cursor scan fixups. The fixup was being done for cursor '%.*s'. This is an internal error.
664        18           The parameters passed to cursfix_main() were not correct. This is an internal error.
665        18           The cursor fixup is being done for the pre delete case with the data row for a scan using a non-clustered index and there was no fixup done for
                             pre-delete of the non-clustered index row. This is an internal error.
666        18           The current position deleted bit is set for an SDES but there is no fixup information saved. This is an internal error.
667        26           Illegal locking strategy encountered at scan initialization.  Object %S_OBJID, database %S_DBID.  This is an internal error.
668        18           The cursor '%.*s' which is scanning a list of rids i.e a work table is having it's tables changed. This cursor should be read only and the tables
                             should be private to it's query. This is an internal error.
669        18           The length computation of the row %d is wrong. Ensure that row-length is no greater than max possible size of %d. This error was detected during
                             cursor scan fixups for cursor '%.*s'. This is an internal error.
670        16           Out of bound insert attempted on table '%.*s'.
671        14           Writetext is not allowed in reclassify mode.
672        16           Out of bound update attempted on table '%.*s'.
673        16           Out of bound delete attempted on table '%.*s'.
674        20           Invalid Buffer Cache Access: Attempt to locate page '%u', database '%d' in cache failed because the cache id '%d' in scan_context is invalid.
                             scan_context={objid '%d', indid '%d', cid '%d'}. Contact Technical Support for assistance.
675        20           Invalid Buffer Cache Access: Attempt to locate page '%u', database '%d' in cache failed because no object id was specified. 
                             scan_context={objid '%d', indid '%d', cid '%d'}. Contact Technical Support for Assistance.
676        21           NULL cache id specified in log record.
677        20           Invalid Buffer Cache Access: Attempt to locate page '%u', dbid '%d', objid '%d', indid '%d' in cache failed because the cache ID was not set
                             in the scan_context structure. Contact Technical Support for assistance.
678        20           Invalid Buffer Cache Access: Could not open object '%ld' in database '%d'
679        20           Inconsistent update state found during expensive direct update of object '%ld'.
680        20           Attempt to extend the log in database '%.*s' failed due to an internal error. The returned status was %d.
682        20           The buffer 0x%lx , page number '%u' for object '%.*s' in database '%.*s' should be latched on entry to this function and it is not.
683        20           Failed to get lock on data page '%u' row '%d' for object '%.*s' in database '%.*s'.
684        26           Page %u, Row %d, for object '%.*s' in database '%.*s' is not exclusive locked.
685        21           Expected page %u to be in cache '%.*s' for object id %d, index id %d, database id %d. Instead, the server brought the page into wrong cache '%.*s'.
686        20           Page %u is corrupted.
688        21           Insufficient CFS while redo of expanding update on page %u belonging to object %d. CFS - %d, length of new row - %d
689        10           An unexpected log record (log op %d) was encountered when scanning the log for a trigger.
690        20           Pageno in lk_pglocked (%u) different from lockobj (%u).
691        20           Encountered invalid logical page '%u' while accessing %S_PTNINFO. This is an internal system error. Please contact SAP Technical Support.
692        20           Uninitialized logical page '%u' was read while accessing %S_PTNINFO. Please contact SAP Technical Support.
693        20           Multiple copies of logical page '%u' from %S_PTNINFO reside in more than one cache. This is an internal system error. Please contact SAP Technical Support.
694        24           An attempt was made to read logical page '%u', virtpage '%d' from virtual device '%d' for %S_PTNINFO. The page was not read successfully.
                             You may have a device problem or an operating system problem.
695        21           An attempt was made to read logical page '%u' for %S_PTNINFO from disk. Wrong logical page '%u' was brought into cache '%.*s'.
696        21           An attempt was made to fetch logical page '%u' from cache '%.*s'. Page belongs to %S_PTNINFO and not to %S_PTNINFO.
                             Restart of ASE will clear the error. Please contact your System Administrator for help.
697        21           An attempt was made to fetch logical page '%u' for %S_PTNINFO from cache '%.*s'. Wrong logical page '%u' was found in cache.
698        21           An attempt was made to access row from cache '%.*s'. It belongs to row id ('%u', '%u') %S_PTNINFO and not to row id ('%u', '%u') %S_PTNINFO.