Symptom
Error 631 reported in ASE's log.
====
Error: 631, Severity: 21, State: 1
The length of 91 passed to delete row routine for the row at offset cccc is incorrect on the following page of database 'db01': Page pointer = 0x0xaac00e000, pageno = 1111111, status = 0x000, ptnid = 22222222, indexid = 0, level = 0, pnextrno = xx. The expected row length is 9999. The offset should be no greater than 1111.
Database 'db01' (dbid x): Recovery failed. Check the ASE errorlog for further information as to the cause.
=======
-
During recovery, the following functions in the stack trace can be checked in the memory dump file:
exc_raise
deldrow
undo_apl_insind
redo_clr
rec_redo_log
recovery
boot__recover_and_online
rec__boot_recover_dbs
rec__parallel_hdlr -
During normal processing, the following functions can be reported in the stack trace after error 631:
exc_raise
rec_undo_session
abort__all
xact__rollbackxact
xact__rollback_local
xact_rollback
exec_ri_deferred - Error 631 affects an APL data compressed table.
Read more...
Environment
SAP Adaptive Server Enterprise 16.0 SP03 PL10
Keywords
Error 631 APL data compressed table passed to delete row routine for the row at offset deldrow undo_apl_insind redo_clr rec_redo_log recovery boot__recover_and_online rec__boot_recover_dbs exec_ri_deferred xact__rollbackxact rec_undo_session xact__rollback_local abort__all rec_undo_session abortcmd 828349 CR 828349 CR828349 CR#828349 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.