SAP Knowledge Base Article - Preview

2133117 - Error 644 index row error while ONLINE DATABASE after dump and load - SAP ASE

Symptom

  • LOAD DATABASE from ASE 12.5.x to ASE 15.7
  • ONLINE DATABASE fails with ASE Error 644:

    Msg 644, Level 21, State 5
    Server 'SYBASE', Line 1
    Index row entry for data row id (1506827, 6) is missing from index page 15185 of index id 2 of table 'sysstatistics' in database
    'mydb'. Xactid is (7036611,4). Drop and re-create the index.

  • Error 644 may be followed by 12807 and 3454 error:

    Msg 12807, Level 18, State 1
    Server 'SYBASE', Line 1
    cannot delete a tuple in sysstatistics
    Msg 3454, Level 20, State 1
    Server 'SYBASE', Line 1
    Database 'mydb': ASE could not completely upgrade this database; upgrade item 1501 could not be installed.
    ASE could not bring database 'mydb' online.

  • Database was previously upgraded from a still older version to ASE 12.5.x


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

777475, CR 777475 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

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.