Symptom
Errors are reported when turning compression off for table and its clustered index is not rebuilt. For example:
Error: 806, Severity: 21, State: 1
Could not find virtual page for logical page NNNNNNN in database 'tbxx'.
....
....
exc_raise
log_to_virt
virtmap
bufgrab
getpage_with_validation
scan_getrow
...
...
Error: 614, Severity: 21, State: 7
Adaptive Server accessed a row that has an illegal length of 28928 while in database 'db01'. Page pointer = 0x0x15b0a6000, pageno = 4992,status = 0x151, ptnid = 608002166, indexid = 0, level = 0, pnextrno = 1. The minimum row length is 1815. The page size is 2048.
Error: 9829, Severity: 22, State: 2
Compressed data row 0x15af2079d in objid 592002109, dbid 5 is corrupted.
************************************
SQL causing error : update tb02 set colb = "1" where cola > 0
...
************************************
....
....
exc_raise
decompress__crow_to_apl
....
....
Read more...
Environment
SAP Adaptive Server Enterprise 16.0 SP03 PL08 HF1 and higher
Product
Keywords
compression alter table set compression page none clustered index disable compression turn off errors 806 614 9829 decompress__crow_to_apl log_to_virt virtmap bufgrab row that has an illegal length 825793 CR 825793 CR 825793 CR# 825793 , 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.