SAP Knowledge Base Article - Preview

3115727 - Errors when turning compression off - SAP ASE

Symptom

 Errors are reported when turning compression off for table and its clustered index is not rebuilt. For example:

  1.  

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

  1.  

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.

  1.  

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

SAP Adaptive Server Enterprise 16.0

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.