We have Team Foundation Server 2005. In our normal maintenance plan, we are
getting the following database consistency error on the database 'TWO':

Command:
DBCC CHECKDB WITH NO_INFOMSGS

Output:
Msg 2570, Level 16, State 3, Line 1
Page (1:18788), slot 6 in object ID 34, index ID 1, partition ID
281474978938880, alloc unit ID 281474978938880 (type "In-row data"). Column
"modified" value is out of range for data type "datetime". Update column to
a legal value.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'sys.sysschobjs' (object ID 34).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'TWO'.

How would I even begin to troubleshoot/fix this error which appears to be in
a system table??

This is a dump of the slot it's complaining about:
Slot 6 Offset 0x106 Length 68

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
VARIABLE_COLUMNS

Memory Dump @0x6258C106

00000000: 30002c00 5998cd5b 01000000 0000000e â€0.,.Y..[........
00000010: 00552000 00000001 20000000 dd2fb500 â€.U ..... ..../..
00000020: 78970000 00828b01 a6980000 0b0000f8 â€x...............
00000030: 01004400 50004a00 4f005500 52004e00 â€..D.P.J.O.U.R.N.
00000040: 41004c00 â€â€â€â€â€â€â€â€â€â€â€â€â€â€â€â€â€ â€â€â€â€â€â€â€â€â€â€â€A.L.

Slot 6 Column 0 Offset 0x4 Length 4

id = 1540200537

Slot 6 Column 1 Offset 0x34 Length 16

name = PJOURNAL

Slot 6 Column 2 Offset 0x8 Length 4

nsid = 1

Slot 6 Column 3 Offset 0xc Length 1

nsclass = 0

Slot 6 Column 4 Offset 0xd Length 4

status = 917504

Slot 6 Column 5 Offset 0x11 Length 2

type = U

Slot 6 Column 6 Offset 0x13 Length 4

pid = 0

Slot 6 Column 7 Offset 0x17 Length 1

pclass = 1

Slot 6 Column 8 Offset 0x18 Length 4

intprop = 32

Slot 6 Column 9 Offset 0x1c Length 8

created = Mar 2 2006 10:59AM

Slot 6 Column 10 Offset 0x24 Length 8

modified = Dec 29 2006 12:00PM

Peter
http://www.sqlskills.com/blogs/paul/...gory,DBCC.aspx


"Peter" <Peter@discussions.microsoft.com> wrote in message
news:C17FBB2A-43B2-41D3-AE86-436B8AA730B6@microsoft.com...
> We have Team Foundation Server 2005. In our normal maintenance plan, we
> are
> getting the following database consistency error on the database 'TWO':
>
> Command:
> DBCC CHECKDB WITH NO_INFOMSGS
>
> Output:
> Msg 2570, Level 16, State 3, Line 1
> Page (1:18788), slot 6 in object ID 34, index ID 1, partition ID
> 281474978938880, alloc unit ID 281474978938880 (type "In-row data").
> Column
> "modified" value is out of range for data type "datetime". Update column
> to
> a legal value.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'sys.sysschobjs' (object ID 34).
> CHECKDB found 0 allocation errors and 1 consistency errors in database
> 'TWO'.
>
> How would I even begin to troubleshoot/fix this error which appears to be
> in
> a system table??
>
> This is a dump of the slot it's complaining about:
> Slot 6 Offset 0x106 Length 68
>
> Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
> VARIABLE_COLUMNS
>
> Memory Dump @0x6258C106
>
> 00000000: 30002c00 5998cd5b 01000000 0000000e †0.,.Y..[........
> 00000010: 00552000 00000001 20000000 dd2fb500 †.U ..... ..../..
> 00000020: 78970000 00828b01 a6980000 0b0000f8 †x...............
> 00000030: 01004400 50004a00 4f005500 52004e00 †..D.P.J.O.U.R.N.
> 00000040: 41004c00 ††††††††††††††††††††††††††††A.L.
>
> Slot 6 Column 0 Offset 0x4 Length 4
>
> id = 1540200537
>
> Slot 6 Column 1 Offset 0x34 Length 16
>
> name = PJOURNAL
>
> Slot 6 Column 2 Offset 0x8 Length 4
>
> nsid = 1
>
> Slot 6 Column 3 Offset 0xc Length 1
>
> nsclass = 0
>
> Slot 6 Column 4 Offset 0xd Length 4
>
> status = 917504
>
> Slot 6 Column 5 Offset 0x11 Length 2
>
> type = U
>
> Slot 6 Column 6 Offset 0x13 Length 4
>
> pid = 0
>
> Slot 6 Column 7 Offset 0x17 Length 1
>
> pclass = 1
>
> Slot 6 Column 8 Offset 0x18 Length 4
>
> intprop = 32
>
> Slot 6 Column 9 Offset 0x1c Length 8
>
> created = Mar 2 2006 10:59AM
>
> Slot 6 Column 10 Offset 0x24 Length 8
>
> modified = Dec 29 2006 12:00PM
>

I had seen similar information before. However, the error is occurring is a
system table ('sys.sysschobjs') and not one that I can query against let
alone delete/update rows in. I've tried the repair option of DBCC, but it's
not an error that it will repair.

Other ideas?

--Pete

"Uri Dimant" wrote:

> Peter
> http://www.sqlskills.com/blogs/paul/...gory,DBCC.aspx
>
>
> "Peter" <Peter@discussions.microsoft.com> wrote in message
> news:C17FBB2A-43B2-41D3-AE86-436B8AA730B6@microsoft.com...
> > We have Team Foundation Server 2005. In our normal maintenance plan, we
> > are
> > getting the following database consistency error on the database 'TWO':
> >
> > Command:
> > DBCC CHECKDB WITH NO_INFOMSGS
> >
> > Output:
> > Msg 2570, Level 16, State 3, Line 1
> > Page (1:18788), slot 6 in object ID 34, index ID 1, partition ID
> > 281474978938880, alloc unit ID 281474978938880 (type "In-row data").
> > Column
> > "modified" value is out of range for data type "datetime". Update column
> > to
> > a legal value.
> > CHECKDB found 0 allocation errors and 1 consistency errors in table
> > 'sys.sysschobjs' (object ID 34).
> > CHECKDB found 0 allocation errors and 1 consistency errors in database
> > 'TWO'.
> >
> > How would I even begin to troubleshoot/fix this error which appears to be
> > in
> > a system table??
> >
> > This is a dump of the slot it's complaining about:
> > Slot 6 Offset 0x106 Length 68
> >
> > Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
> > VARIABLE_COLUMNS
> >
> > Memory Dump @0x6258C106
> >
> > 00000000: 30002c00 5998cd5b 01000000 0000000e â€0.,.Y..[........
> > 00000010: 00552000 00000001 20000000 dd2fb500 â€.U ..... ..../..
> > 00000020: 78970000 00828b01 a6980000 0b0000f8 â€x...............
> > 00000030: 01004400 50004a00 4f005500 52004e00 â€..D.P.J.O.U.R.N.
> > 00000040: 41004c00 â€â€â€â€â€â€â€â€â€â€â€â€â€â€â€â€â€ â€â€â€â€â€â€â€â€â€â€â€A.L.
> >
> > Slot 6 Column 0 Offset 0x4 Length 4
> >
> > id = 1540200537
> >
> > Slot 6 Column 1 Offset 0x34 Length 16
> >
> > name = PJOURNAL
> >
> > Slot 6 Column 2 Offset 0x8 Length 4
> >
> > nsid = 1
> >
> > Slot 6 Column 3 Offset 0xc Length 1
> >
> > nsclass = 0
> >
> > Slot 6 Column 4 Offset 0xd Length 4
> >
> > status = 917504
> >
> > Slot 6 Column 5 Offset 0x11 Length 2
> >
> > type = U
> >
> > Slot 6 Column 6 Offset 0x13 Length 4
> >
> > pid = 0
> >
> > Slot 6 Column 7 Offset 0x17 Length 1
> >
> > pclass = 1
> >
> > Slot 6 Column 8 Offset 0x18 Length 4
> >
> > intprop = 32
> >
> > Slot 6 Column 9 Offset 0x1c Length 8
> >
> > created = Mar 2 2006 10:59AM
> >
> > Slot 6 Column 10 Offset 0x24 Length 8
> >
> > modified = Dec 29 2006 12:00PM
> >
>
>
>