2 Replies Latest reply on May 11, 2011 11:07 AM by philmodjunk

    chunk of lost data

    MiaWebster

      Summary

      chunk of lost data

      Product

      FileMaker Pro

      Version

      7.0v3

      Description of the issue

      I have recently lost a large chunk of data.  To be precise 641 pages out of the 3600 in our database.  I am using Filemaker along with 2 other people.  One logs on, the other two log on as guests.  For a few weeks now, when the first person logs on a window pops up saying "looking for unused blocks"(rough translation from French "Recherche de blocs inutilisés") and it takes a good 2-3 minutes to open.
      We have now noticed that pages are missing.  When I go to find a page, the page appears but totally blank.  It seems as if the page is masked, or the information hidden.  The page also seems to be blocked, I can't enter any further data onto the blank pages, whereas I can still enter data onto pages showing data.  The data must still exist, otherwise no corresponding page would show up.  Any ideas?

      Exact text of any error message(s) that appear

      "Recherche de blocs inutilisés"

        • 1. Re: chunk of lost data

          Mia Webster:

          Thanks for posting!

          It sounds like it could be a case of corruption. Try creating a new layout based on that table and let us know if the information is available that way. It might also be a good idea to run through some of the common steps for dealing with corruption:

          http://help.filemaker.com/app/answers/detail/a_id/5421

          TSBear
          FileMaker, Inc. 

          • 2. Re: chunk of lost data
            philmodjunk

            TSBear,

            It's a pity that article doesn't include the following info:

            1. Recover does not detect all problems
            2. Recover doesn't always fix all problems correctly
            3. Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.

             

            And (when you try re-indexing fields):

            You can also rebuild all your file's indexes by importing all the data into an empty copy (clone) of your file.

            If you have FileMaker 11, you can use Advanced Recovery options to rebuild your file's indexes:

            1. With the file closed, select Recover from the File Menu.
            2. Select "Use advanced Options"
            3. Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".