Symptom
- After completion of REORG REBUILD WITH ONLINE on a compressed DOL table, queries against the table may fail with Error 614, for example:
Error: 614, Severity: 21, State: 11
Adaptive Server accessed a row that has an illegal length of 25421 while in data base 'xxx'. Page pointer = 0x0x2a0a858000, pageno = 119870049, status = 0x811, ptnid = 1106256115, indexid = 0, level = 0, pnextrno = 33. The minimum row length is 12. The page size is 16384.
- DBCC CHECKTABLE on the affected table reports Error 9991, for example:
Msg 9991, Level 16, State 1:
Server 'xxx', Line 1:
Page 119870049, partition ID 1106256115, of object 1106256115, contains an orphan row at offset 44 which must be marked committed delete and is not.
Read more...
Product
Keywords
Sybase, ASEServer, SAPASE, dataserver, compression, CR821544, CR#821544, 821544 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.