Re: Msg 624 Could not retrieve row from page by RID...

From: Steve Kass (skass_at_drew.edu)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 08:50:35 -0400

Product support might be the next place to do, unfortunately.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp

The only other thing I might try first is ANSI syntax for the update:

update #working set
  LinkID = (
    select OwnerOID
    from EventDetail d
    where d.EventDetailID = #working.EventDetailID
    and #working.OwnerTypeCode = 4
    and EventDetail.TextBuffer1 like '%internalrx=False%'
  )
where exists (
  select *
  from EventDetail d
  where d.EventDetailID = #working.EventDetailID
  and #working.OwnerTypeCode = 4
  and EventDetail.TextBuffer1 like '%internalrx=False%'
 )

Steve Kass
Drew University

Scott wrote:

>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>
>I have a stored procedure that is returning the following error:
>
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>
>Line 170 of the sp is running the following update:
>
>Update f set
> LinkID = OwnerOID
>>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>
>Any idea where I should go from here?
>
>TIA,
>
>Scott
>
>
>
>