Tuesday, March 27, 2012

Error Recieved While Reindexing

Folk
i recieved an error message while doing a reindex
The error Message is
[dbo].[XX_TL_WRK109TBL
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Serve
Connection Broke
The Command i used to reindex 'ALL' Tables is
EXEC sp_MSforeachtable @.command1="print '?' DBCC DBREINDEX ('?')
We are still at Service pack 2 cos PeopleSoft has not certified Service Pack 3a yet
We are running a Peoplesoft Application[posted and mailed, please reply in news]
=?Utf-8?B?R2lyaXNo?= (gwadhwani@.econsult.us) writes:
> Folks
> i recieved an error message while doing a reindex.
> The error Message is
> [dbo].[XX_TL_WRK109TBL]
> [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
> Connection Broken
That doesn't bode well.
While that error occasionally may indicate a true protocol error, it
most often means that SQL Server slammed the door in the face on
you and cut the connection. Not without reason: there was a fatal
error in the execution on the SQL Server side. If you check the SQL Server
errorlog you will probably find a stack dump there.
These kinds of errors are basically always bugs in SQL Server; you should
always get a decent error message back. But if you get this during
DBREINDEX, I'm getting nervous that you have corruption in your database.
So a DBCC CHECKDB would be in place.
Before you open a case with Microsoft, you may want try something
like:
SELECT 'DBCC DBREINDEX(' + name + ')' FROM sysobjects WHERE xtype = 'U'
to factor out sp_MSforeachdb which is undocumented and usage of
it is unsupported.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

No comments:

Post a Comment