Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot retrieve row from page (1:2108289) by RID


Cannot retrieve row from page (1:2108289) by RID

Author
Message
Nido786
Nido786
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 324

MigrationData is my production database last few days i got the error message when i execute a procedure on this database, although i have installed new service pack 4 for sql server 2000.also i have recreated a new database By script but issue is same could any one help me in this regards

Error "

Server: Msg 625, Level 20, State 3, Procedure sp_TransformAccountAverageBalances, Line 27

Cannot retrieve row from page (1:2108289) by RID because the slotid (1) is not valid.

Connection Broken "

Regadrs

Syed Naveed


DeirdreBachman
DeirdreBachman
SSC-Enthusiastic
SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)

Group: General Forum Members
Points: 140 Visits: 194
Since no-one else is answering, I'll take a stab - try running dbcc checkdb (or dbcc checktable with ALL_ERRORMSGS, if you know the specific table that it's complaining about) If you come up with errors, you might even be able to fix them with this command, depending on the severity/type of error (basically, the RID is the internal ID SQL uses to "point" to rows, and I think it's telling you that you've got a RID pointing someplace invalid, the db may just need to clean that pointer up)

-- http://dbachman.blogspot.com
Nido786
Nido786
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 324

i have done it to execute DBCC for database and DBCC for table as per your instruction but there is no change i am facing a same problem what should i do should i reinstall the sql server ???????/????


DeirdreBachman
DeirdreBachman
SSC-Enthusiastic
SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)

Group: General Forum Members
Points: 140 Visits: 194
It seems like maybe you have a "lost write" - toward the end of the article it shows your error and gives a small explanation of what happened:
http://support.microsoft.com/kb/826433

Having said that, I can't find any advice on how to deal with an existing "lost write" that you haven't already tried (everyone says just to SP4 the machine, which you've done) However, (and this is just me thinking out loud) if it is a problem with data pointing to unallocated space, you might try dbcc checkalloc and see if this reveals any errors which were not turned up by the checktable and checkdb.

-- http://dbachman.blogspot.com
Paul Rubel
Paul Rubel
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 13
RESTORE from a clean backup
Erik Bitemo
Erik Bitemo
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 173
Hi,

Just a quick question to avoid a pitfall: Do you use uncommitted read in your query? I yes, this error message can be quite normal (if not pointing to the same page and slot always ).

-- Erik http://blog.rollback.hu
mahesh.dasoni
mahesh.dasoni
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 1025
run the dbcc checktable with repair and rebuild option and with error msg.
this can done the page repare in database.

this will retrive all the data without data loss. i get exact output.

in case you are not identifiable the exact table run dbcc checkdb.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search