SAP Knowledge Base Article - Preview

1964255 - Error: 644, Severity: 21 after upgrading to 15.7 ESD#2 - SAP ASE

Symptom

  • Error: 644, Severity: 21 after upgrading to ASE 15.7 ESD#2

server  Error: 644, Severity: 21, State: 5
server  Index row entry for data row id (2147607330, 0) is missing from index page 2141704973 of index id 2 of table '<tablename>' in database '<database_name>'. Xactid is (2393390264,2). Drop and re-create the index.

  • The data row ID in error message above for the object will show > 2147483647(hex 7fffffff)
  • Host machine must be on a big-endian platform (Sunsparc, AIX, HPIA)
  • Table reporting error is a Data Only Locking (DOL) Table
  • The DOL table must have a clustered index create with "allow_dup_row"
  • The data page in which the index refers to must be on a logical page greater than 2147483647
  • An insert to one or more duplicate keys must take place on this ‘high’ (214748364) page causing a page split
  • A subsequent update or delete of this inserted row will result in 644


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Sunsparc, AIX and HPIA

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.