SAP Knowledge Base Article - Preview

3371976 - Error 631 on APL data compressed table - SAP ASE

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.