2992759 - Multiple Errors 644: Invalid column length or Invalid DOL data row pointer - SAP ASE 16.0

• 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.

SAP Adaptive Server Enterprise (SRS) 16.0

CR#823476, CR823476, 823476 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed