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.
SAP Knowledge Base Article - Preview