DBCC DBREINDEX is failing

I am currently perplexed by the following error I receive when running
DBCC DBREINDEX
Msg 605, Sev 21: Attempt to fetch logical page (1:193369) in database
'SNLEDIT' belongs to object 'FinlAvgCalc2', not to object 'Instn'.
[SQLSTATE HY000]
I have many databases that I run a job that reindexes all tables the
command is
DBCC dbreindex(@.name,'', 95)
A couple of weeks ago one of the databases began failing with the above
error msg. The tables effected always varies. I am concerened since I
thought the reindex command was used to prevent the above condition.
Does anyone have any ideas on a workaround for this condition.
Your help is greatly appreciated.
Dan
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi Dan,
Try running DBCC CHECKDB on the affected database and see if that comes up
with any errors. This will probably take quite a long time to run though.
--
Jacco Schalkwijk
SQL Server MVP
"Dan Duncan" <dduncan@.snl.com> wrote in message
news:ezjLgqK8DHA.3420@.TK2MSFTNGP11.phx.gbl...
>
> I am currently perplexed by the following error I receive when running
> DBCC DBREINDEX
> Msg 605, Sev 21: Attempt to fetch logical page (1:193369) in database
> 'SNLEDIT' belongs to object 'FinlAvgCalc2', not to object 'Instn'.
> [SQLSTATE HY000]
> I have many databases that I run a job that reindexes all tables the
> command is
> DBCC dbreindex(@.name,'', 95)
> A couple of weeks ago one of the databases began failing with the above
> error msg. The tables effected always varies. I am concerened since I
> thought the reindex command was used to prevent the above condition.
> Does anyone have any ideas on a workaround for this condition.
> Your help is greatly appreciated.
> Dan
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

DBCC DBREINDEX is failing

I am currently perplexed by the following error I receive when running
DBCC DBREINDEX
Msg 605, Sev 21: Attempt to fetch logical page (1:193369) in database
'SNLEDIT' belongs to object 'FinlAvgCalc2', not to object 'Instn'.
[SQLSTATE HY000]
I have many databases that I run a job that reindexes all tables the
command is
DBCC dbreindex(@.name,'', 95)
A couple of weeks ago one of the databases began failing with the above
error msg. The tables effected always varies. I am concerened since I
thought the reindex command was used to prevent the above condition.
Does anyone have any ideas on a workaround for this condition.
Your help is greatly appreciated.
Dan
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Hi Dan,
Try running DBCC CHECKDB on the affected database and see if that comes up
with any errors. This will probably take quite a long time to run though.
Jacco Schalkwijk
SQL Server MVP
"Dan Duncan" <dduncan@.snl.com> wrote in message
news:ezjLgqK8DHA.3420@.TK2MSFTNGP11.phx.gbl...
>
> I am currently perplexed by the following error I receive when running
> DBCC DBREINDEX
> Msg 605, Sev 21: Attempt to fetch logical page (1:193369) in database
> 'SNLEDIT' belongs to object 'FinlAvgCalc2', not to object 'Instn'.
> [SQLSTATE HY000]
> I have many databases that I run a job that reindexes all tables the
> command is
> DBCC dbreindex(@.name,'', 95)
> A couple of weeks ago one of the databases began failing with the above
> error msg. The tables effected always varies. I am concerened since I
> thought the reindex command was used to prevent the above condition.
> Does anyone have any ideas on a workaround for this condition.
> Your help is greatly appreciated.
> Dan
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Thanks for the response. Once a week I run
DBCC CHECKDB (@.dbname) WITH ALL_ERRORMSGS
and I get the following result
CHECKDB found 0 allocation errors and 0 consistency errors in database
'SNLEDIT'. [SQLSTATE 01000]
When the errors started happening I would run
dbcc checktable
on the two tables in the error msg and always receive the following
DBCC results for 'FinlAvgCalc2'.
There are 400030 rows in 80008 pages for object 'FinlAvgCalc2'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
with no errors reported.
Any additional ideas would be greatly appreciated.
Thanks
Dan
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Thanks for the response. Once a week I run
DBCC CHECKDB (@.dbname) WITH ALL_ERRORMSGS
and I get the following result
CHECKDB found 0 allocation errors and 0 consistency errors in database
'SNLEDIT'. [SQLSTATE 01000]
When the errors started happening I would run
dbcc checktable
on the two tables in the error msg and always receive the following
DBCC results for 'FinlAvgCalc2'.
There are 400030 rows in 80008 pages for object 'FinlAvgCalc2'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
with no errors reported.
Any additional ideas would be greatly appreciated.
Thanks
Dan
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Do the whole db not just those tables. Try running DBCC CHECKDB and DBCC
CHECKCATALOG
Andrew J. Kelly
SQL Server MVP
"Dan Duncan" <dduncan@.snl.com> wrote in message
news:uv3Bc2L8DHA.3008@.TK2MSFTNGP09.phx.gbl...
> Thanks for the response. Once a week I run
> DBCC CHECKDB (@.dbname) WITH ALL_ERRORMSGS
> and I get the following result
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'SNLEDIT'. [SQLSTATE 01000]
> When the errors started happening I would run
> dbcc checktable
> on the two tables in the error msg and always receive the following
> DBCC results for 'FinlAvgCalc2'.
> There are 400030 rows in 80008 pages for object 'FinlAvgCalc2'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> with no errors reported.
> Any additional ideas would be greatly appreciated.
> Thanks
> Dan
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

DBCC CHECKDB Reporting Errors in - SQL Server 2005

HI,
I am getting this ttype of errors in SQL Server 2005, This table have xml
column.
Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
not referenced. [SQLSTATE 42000]
Please give some help on this , what will be the route cause of this problem?
how to resolve it.Hi
You may want to check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_2_0prl.asp
You may also want to check that this has not been re-introduced
http://support.microsoft.com/default.aspx?scid=kb;en-us;281287
Try dropping and re-creating the index. If the error persists then you
should log it with PSS.
John
"Srikanth" wrote:
> HI,
> I am getting this ttype of errors in SQL Server 2005, This table have xml
> column.
> Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
> ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
> LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
> not referenced. [SQLSTATE 42000]
> Please give some help on this , what will be the route cause of this problem?
> how to resolve it.
>
>

DBCC CHECKDB Reporting Errors in - SQL Server 2005

HI,
I am getting this ttype of errors in SQL Server 2005, This table have xml
column.
Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
not referenced. [SQLSTATE 42000]
Please give some help on this , what will be the route cause of this problem?
how to resolve it.
Hi
You may want to check out:
http://msdn.microsoft.com/library/de...err_2_0prl.asp
You may also want to check that this has not been re-introduced
http://support.microsoft.com/default...b;en-us;281287
Try dropping and re-creating the index. If the error persists then you
should log it with PSS.
John
"Srikanth" wrote:

> HI,
> I am getting this ttype of errors in SQL Server 2005, This table have xml
> column.
> Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
> ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
> LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
> not referenced. [SQLSTATE 42000]
> Please give some help on this , what will be the route cause of this problem?
> how to resolve it.
>
>

DBCC CHECKDB Reporting Errors in - SQL Server 2005

HI,
I am getting this ttype of errors in SQL Server 2005, This table have xml
column.
Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
not referenced. [SQLSTATE 42000]
Please give some help on this , what will be the route cause of this problem
?
how to resolve it.Hi
You may want to check out:
http://msdn.microsoft.com/library/d...serr_2_0prl.asp
You may also want to check that this has not been re-introduced
http://support.microsoft.com/defaul...kb;en-us;281287
Try dropping and re-creating the index. If the error persists then you
should log it with PSS.
John
"Srikanth" wrote:

> HI,
> I am getting this ttype of errors in SQL Server 2005, This table have xml
> column.
> Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, inde
x
> ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (typ
e
> LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512
is
> not referenced. [SQLSTATE 42000]
> Please give some help on this , what will be the route cause of this probl
em?
> how to resolve it.
>
>