Post reply

Error 605

  • July 5, 2005 at 10:17 am

    #152455

    Good morning!  Can you tell me what I do about this error????

     

    " Error: 605, Severity: 21, State: 1 Attempt to fetch logical page (1:269940) in database 'ReportAnalysis' belongs to object '0', not to object 'RA_PATIENT_GLUCOSE_RESULTS'. "

    Thanks!!

    Thank you!!,

    Angelindiego

  • July 5, 2005 at 10:58 am

    #570937

    I have done some things with this error.  First I ran DBCC CHECKDB and found nothing.  Then I ran DBCC CHECKTABLE using the second object (as was told by troublshooting info) and the results say 0 errors found, 0 errors fixed.  Tried re-running the job (optimizations for this db) and it failed again with the same error.  I am at a loss!!  Anybody??????

    Thank you!!,

    Angelindiego

  • July 6, 2005 at 10:49 am

    #571389

    What is the code that you are running that generates this error message?

  • July 6, 2005 at 11:05 am

    #571401

    What is the code that you are running that generates this error message?

  • July 6, 2005 at 11:28 am

    #571411

    Any accompanying messages in SQl Server Error Log?

    It could be a damaged page chain, a corrupt Index Allocation Map (IAM), or an invalid entry in the sysobjects system table for that object.

    If the error reports the first object ID as 0, an unallocated page was probably encountered.(There is no object ID equal to 0.)

    There is a good chance that one of the indexes got corrupted( happened to me) and you must run REPAIR_REBUILD.

    my 2cents

     

     

  • July 6, 2005 at 1:40 pm

    #571477

    Wahoo, Barsuk!!  That is the message in the SQL log!  I looked in the event viewer and got no more than what I stated above.  I have done everything from dbcc checkdb, dbcc checktable, rebuild indexes on that referenced table, cleared cache....reran the job again...still get the error.  I will go do some research on the repair_rebuild and try that next.  Thanks a ton!!!

    Thank you!!,

    Angelindiego

  • July 6, 2005 at 2:59 pm

    #571565

    ok, question...repair_rebuild should be done if you get errors on the dbcc checkdb command correct??  I get no errors...0 errors found, 0 errors repaired...and that goes for the dbcc checktable as well.  Do you think it could be a disk problem?????????? 

    Thank you!!,

    Angelindiego

  • July 14, 2005 at 3:38 am

    #574288

    This message came once for a particular database. DBCC Checkdb did not find any error. I reckon it may just be a temporary i/o issue.

    Oke

     

  • July 25, 2005 at 2:01 pm

    #576953

    Turns out I have a bad disk.  Replaced it and dropped and recreated the indexes and now we are running fine!!  Thanks everybody!!

    Thank you!!,

    Angelindiego

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply