SQL Clone
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
Right there with Babe
Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)

Group: General Forum Members
Points: 734 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
Old Hand
Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)

Group: General Forum Members
Points: 322 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
Right there with Babe
Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)Right there with Babe (734 reputation)

Group: General Forum Members
Points: 734 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
Old Hand
Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)

Group: General Forum Members
Points: 322 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
Say Hey Kid
Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)

Group: General Forum Members
Points: 665 Visits: 13
RESTORE from a clean backup
Erik Bitemo
Erik Bitemo
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1184 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 Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 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