Symptom
- Multiple 644 errors are reported in the ASE errorlog may:
Error: 644, Severity: 21, State: 5
Index row entry for data row id (256166003, 10) is missing from index page 25616 1116 of index id 6 of table 'xxxx' in database 'db'. Xactid is (15392632,6). Drop and re-create the index.
- ASE error log also report "Invalid DOL data row pointer" messages followed by a stack trace:
Invalid DOL data row pointer: row -12767 with status 0xef00 must be normal row instead of compressed row. - The stack trace shows functions:
collocate__impl
collocate
LeSubst
getnext
LeScanOp::_LeOpNext
LeRestrictOp::_LeOpNext
LeDMLOp::printXMLCostMetrics
LeSortInputStream
startsort
sort
- Also the "Invalid column length" messages may be reported with a similar stack trace:
Invalid column length: 18505. Value must be between 0 and 4 at offset -7 for 'data-only' row with minimum row length of 29.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR#823476, CR823476, 823476 2812828 - Error "Invalid DOL data row pointer ... must be normal row instead of compressed row" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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