Post reply

Fetch logical page error during DTS package execution

  • August 25, 2006 at 2:29 am

    #97425

    Hi, I have a Data Transformation Package running every night that failed this morning with the error message: -

     

    “Attempt to fetch logical page (1:110797) in database ‘OLAP_DW’ belongs to object ‘624721278’, not to object ‘rep_FactsAll’”

     

    Allthough new, this package has now run, successfully, every night for the last two weeks.

     

    On discovering the failure I immediatley re-ran the package which completed successfully.

     

    I have never come across this error before. Can anyone shed some light on what might have happenned and what may have cused the failure please? And, should I be worried?

     

    Thanks for any help you can provide.

    All the best,

    Duncan

  • August 28, 2006 at 3:45 am

    #657034

    Hi, from what you posted I believe that you might have some kind of corruption in your db. I would run DBCC CHECKDB against your db as soon as possible. Meanwhile see "Error 605" topic in Books Online and these MS articles

    http://support.microsoft.com/default.aspx?scid=kb;en-us;826433

    http://support.microsoft.com/?kbid=897284

    mainly concepts of lost write, stale read and transient errors

    We encountered similar problem about 2 years ago. It turned out to be a faulty RAID driver. Firmware upgrade resolved the problem and we never saw this message again. 

    Hope this helps.

Viewing 2 posts - 1 through 1 (of 1 total)

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