Symptom
DBCC checkstorage() reports lots of 100001 faults (Invalid page ids in header) for DOL tables after a shrink database operation.
For example:
1> sp_dbcc_faultreport 'long', mydb
2> go
Generating 'Fault Report' for object mytab, indid 0, partition id 640002280 in database mydb.
Fault Type: 100001 (page id error); Hard fault
The page id, next page, or previous page value in the page header is invalid.
The page id, next page, or previous page value in the page header is invalid.: 3
page id: 899
Data Only Locked data page header:
0x000003830000EA610000EA602625A8E800002A6A000100000000073E08810712020001010000000000BE
Header for 899, next 60001, previous 60000, id = 640002280:0
time stamp = 0x000000002A6A, next row = 1, spare1 = 0
free offset = 1854, minlen = 1810, status = 2177(0x0881)
status2 = 2(0x0002), private status = 0(0x0000), page size = 1, version = 1
non-contiguous free space (ncfs) = 0, deleted rows = 0
insert free space = 190
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE) 15.7 and later
-
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
CR747572 , 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.