SAP Knowledge Base Article - Preview

2624740 - How to resolve error 644 on a user table in SID database? - SAP ASE for Business Suite

Symptom

  • In T-Code SM21 and ST22, the following error is reported:

    |17:35:08|BTC |012|000|SWOMGR | | |BY |0|> [ASE Error SQL21][SAP][ASE ODBC Driver][Adaptive Server |
    |17:35:08|BTC |012|000|SWOMGR | | |BY |0|> Enterprise]WARNING - Fatal Error 644 occurred at Feb 22 2018 |
    |17:35:08|BTC |012|000|SWOMGR | | |BY |0|> 5:35PM. Please note the error and time, and contact a user |
    |17:35:08|BTC |012|000|SWOMGR | | |BY |0|> with System Administrator (SA) authorization.
    |
    |17:35:10|BTC |012|000|SWOMGR | | |AB |0| Run-time error "DBIF_RSQL_SQL_ERROR" occurred |
    |17:35:11|BTC |012|000|SWOMGR | | |AB |1|> Short dump "180222 173510 NCYSV0041_<SID>_00 SWOMGR " created. |

  • In ASE error log, the following error message is reported:

    Error: 644, Severity: 21, State: 5
    Index row entry for data row id (123456, 3) is missing from index page 456789 of index id 3 of table 'SNAP' in database '<SID>'. Xactid is (876543, 21). Drop and re-create the index.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

error,644,sm21,short,dump,index , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.