Microsoft KB Archive/193992

= FIX: Attempt to Delete a Row May Raise Error 631 =

Article ID: 193992

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q193992



BUG #: 17622 (SQLBUG_65)



SYMPTOMS
A DELETE statement that causes a consolidation of index pages may report error 631:

Msg 631, Level 21, State 2 The length of 24 passed to delete row routine for the row at offset 32 is incorrect on the following page: Page pointer = 0x11cf000, pageno = 634, status = 0x0, objectid = 1744009244, indexid = 1 The SQL Server is terminating this process.



WORKAROUND
To work around this problem, do either of the following:


 * Re-create the index with a different fill factor.

-or-
 * Drop and re-create the index.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

For more information, contact your primary support provider.



MORE INFORMATION
When consolidating an index page, under very limited conditions, the length of a row may be incorrectly calculated by the engine.

Keywords: kbbug kbfix kbsqlserv650sp5fix KB193992

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.