Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot retrieve row from page (1:2108289) by RID Expand / Collapse
Author
Message
Posted Monday, July 30, 2007 6:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:08 AM
Points: 58, 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

Post #386278
Posted Tuesday, July 31, 2007 12:39 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 6, 2014 10:07 AM
Points: 140, Visits: 142
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
Post #386772
Posted Tuesday, July 31, 2007 11:15 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:08 AM
Points: 58, 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 ???????/????

Post #386879
Posted Wednesday, August 1, 2007 7:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 6, 2014 10:07 AM
Points: 140, Visits: 142
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
Post #386988
Posted Thursday, August 2, 2007 9:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 3:06 PM
Points: 53, Visits: 13
RESTORE from a clean backup
Post #387461
Posted Friday, September 7, 2007 2:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 1, 2013 2:14 AM
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
Post #397168
Posted Wednesday, October 3, 2012 4:46 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:20 AM
Points: 81, Visits: 929
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.
Post #1367542
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse