Results 1 to 2 of 2

Thread: Any Idea's on 605

  1. 11-16-2000, 11:10 AM #1
    Davis Guest

    Any Idea's on 605

    When one of the users log into the database via a thrid party application
    they receive an error message:

    2000/11/16 10:40:13.84 spid51 Error : 605, Severity: 21, State: 1
    2000/11/16 10:40:13.84 spid51 Attempt to fetch logical page 7832 in database 'highview' belongs to object '1241055457', not to object 'application_data'.
    2000/11/16 10:45:07.68 spid46 Getpage: bstat=0x1008/0, sstat=0x80002110, disk
    2000/11/16 10:45:07.68 spid46 pageno is/should be: objid is/should be:
    2000/11/16 10:45:07.68 spid46 0x1e98(7832) 0x49f900e1(1241055457)
    2000/11/16 10:45:07.68 spid46 0x1e98(7832) 0x4810b86f(1209055343)
    2000/11/16 10:45:07.68 spid46 ... extent objid 0, mask 0/0, next/prev=0/0
    2000/11/16 10:45:07.68 spid46 ... retry bufget after purging bp 0x2da7e060


    I tried running DBCC checkdb, newalloc,& checktable to fix the probelm and than droping the table and rebuilding it but not success, any suggestion are
    more than welcome.
    Reply With Quote Reply With Quote
  2. 11-16-2000, 03:10 PM #2
    Megan Ruhl Guest

    Any Idea's on 605 (reply)

    it looks like a permissions problem, a)is object owner dbo b)does spid51's id have permission to hit that object

    Megan


    ------------
    Davis at 11/16/00 11:10:23 AM

    When one of the users log into the database via a thrid party application
    they receive an error message:

    2000/11/16 10:40:13.84 spid51 Error : 605, Severity: 21, State: 1
    2000/11/16 10:40:13.84 spid51 Attempt to fetch logical page 7832 in database 'highview' belongs to object '1241055457', not to object 'application_data'.
    2000/11/16 10:45:07.68 spid46 Getpage: bstat=0x1008/0, sstat=0x80002110, disk
    2000/11/16 10:45:07.68 spid46 pageno is/should be: objid is/should be:
    2000/11/16 10:45:07.68 spid46 0x1e98(7832) 0x49f900e1(1241055457)
    2000/11/16 10:45:07.68 spid46 0x1e98(7832) 0x4810b86f(1209055343)
    2000/11/16 10:45:07.68 spid46 ... extent objid 0, mask 0/0, next/prev=0/0
    2000/11/16 10:45:07.68 spid46 ... retry bufget after purging bp 0x2da7e060


    I tried running DBCC checkdb, newalloc,& checktable to fix the probelm and than droping the table and rebuilding it but not success, any suggestion are
    more than welcome.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules