Skip to end of metadata
Go to start of metadata

Checkstorage Fault 100029

page header error

Indicates an internal inconsistency in the page’s header other than the kind described by the other type codes. The severity of this error depends on the type of page and the inconsistency found.

Recommended actions:

Run dbcc page(database_name, pageno, 1) to examine the contents of the page header.  In general, look for anything unusual, like bizarre combinations of status bits.  

Run dbcc checktable(table_name).

Fault 100029 is an abstraction of around 54 more specific checks of the page header, each of which has a unique fault_state value. 
While the sp_dbcc_faultreport output does not include the fault_state, it is recorded in the dbccdb..dbcc_fault_params table with a type_code of 10014.

Basic sample query to determine fault_state values

These fault state descriptions are based on the ASE source code as of 16.0 SP03 PL08 and are subject to change without notice.

All example output comes from a test system with manufactured data.

Fault_stateDescription (final)Description (working)
0Initialized value for internal variable, report to Support if seen.
1

Unused in 16.0 SP03 PL08. (Report to Support if seen)


2Unused in 16.0 SP03 PL08. (Report to Support if seen)
3
data pages don't belong in a DOL object
4
First page is anchored
5APL data page contains an illegal combination of flags in the status field.
6
Overflow status bits on when they shouldn't be
7
Number of characters encoded
8For the root page of an index, the prevpg and nextpg fields should be 0
9DOL index page contains an illegal combination of flags in the status field.
10
last row offset not recorded in header
11DOL data page status field does not have the PGE_DOL flag set.
12
check chain ends, first page is anchored
13DOL data page contains an illegal combination of flags in the status field
14
incorrect page size
15DOL data page contains an invalid version number (the only legal value is '1'). DOL pages have a version field in their extended page header; APL tables do not.
16
invalid pprivstat values
17DOL data page has invalid flags set in the dol_stat2 field
18
dol_nextrno boundary check
19

number of characters encoded checking

20
root page error
21
non leaf pages must have positive level and no page links
22
btree invalid status
23
pagesize not correct
24
freeoffset limit
25DOL index non-leaf page contains an invalid version number (the only legal value is '1'). DOL pages have a version field in their extended page header; APL tables do not.


26DOL index non-leaf page has invalid flags set in the dol_stat2 fieldstat2 invalid values
27
btn_numentries boundary check
28
bol datapage in apl table
29
first or root page
30

leaf page must have level of zero

31
illegal combination of status flags for bt leaf page
32
page size incorrect
33
freeoffset invalid
34DOL index leaf-level contains an invalid version number (the only legal value is '1'). DOL pages have a version field in their extended page header; APL tables do not.
35DOL index leaf-level page has invalid flags set in the dol_stat2 fieldstat2 bit value invalid
36
btl_numentries boundary check
37
too many rows found
38Obsolete (Long ago was used for "distribution page linked to other pages". Distribution pages held index statistics and have been replaced by the sysstatistics table.)
39Index root page should have 0 in the nextpg and prevpg fields.
40Text/Image/BLOB page (indid = 255) has an illegal combination of bits in the status field.
41
not a txtentry
42
check length of data on page
43
checks on first text page
44
illegal status flags for OAM page
45
page entry count and linkages for OAM page
46Unused in 16.0 SP03 PL08. (Report to Support if seen)
47Unused in 16.0 SP03 PL08. (Report to Support if seen)
48Log page contains an illegal combination of flags in the status field
49Log page has PG_OFFSET status flag set on.
50Log page has PG_HASOVER or PG_OVFLDISC status flags set on
51
highest stored row number not in header
52Sysanchors first page should have prevpg field equal to zero.
53Sysanchors page status field should PG_DATA flag set and only PG_DATA flag set.
54
last row offset not recorded in header
  • No labels