Knowledge Base

FIX: Attempt to Delete a Row May Raise Error 631

Article ID: 193992

Article Last Modified on 3/14/2006

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