Symptom
- Running dbcc checkstorage on master database reports faults on the sysanchors table
- Messages most commonly reported are 100009, 100029 and 100030. Other messages can be seen.
- Sample output returned to the client shows
DBCC CHECKSTORAGE for database 'master' sequence # completed at <datetime stamp>.
X faults and 0 suspect conditions were located. 0 checks were aborted.
- Running sp_dbcc_faultreport will show one or more errors on sysanchors and are likely to include, but not limited to, the ones listed below:
Database Name: master
Table Name Index PartitionId Fault Type Page Number
------------ ------- ----------------- -------------------------- -----------------
sysanchors 0 20 100009 (row format error) 25
sysanchors 0 20 100029 (page header error) 25
sysanchors 0 20 100030 (page format error) 25
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.