3 Replies Latest reply on Mar 4, 2013 5:26 PM by MartinPerschler

    file corruption due to non-Filemaker activity on CPU

    MartinPerschler

      Summary

      file corruption due to non-Filemaker activity on CPU

      Product

      FileMaker Pro

      Version

      12v3

      Operating system version

      Windows XP

      Description of the issue

      Twice now, files (different files)have become corrupted overnight after both files and Filemaker have been closed. All relationships are rendered invalid even though they were working the night before. They are not recoverable afterwards.

      Steps to reproduce the problem

      Reproduced itself on its own. Didn't have to do a thing.

      Expected result

      Wanted to be able to recover the file.

      Actual result

      File not recoverable.

      Exact text of any error message(s) that appear

      "This operation cannot be performed because one or more of the relationships between these tables are invalid."

      Workaround

      None. File totally useless.

        • 1. Re: file corruption due to non-Filemaker activity on CPU
          philmodjunk

               What do you mean by "non-Filemaker activity on CPU"? You don't descirbe any Non-FilMaker activity here, just closing the files.

               Do you have backup copies of these files?

               If you perform a recover operation on these back up copies are any issues reported by the recover?

               This is a test to see if the files may already be damaged before ever closing the files and FileMaker.

               Have you run any diagniostics such as checkDsk on your computer? That can rule out issues with your hard drive that may be damaging your file when it is saved back to disk when you close the file.

          • 2. Re: file corruption due to non-Filemaker activity on CPU
            MartinPerschler

                 By that I meant something outside the application. I had this happen many years ago and traced it to a Service Pack issue; now I suspect it has something to do with antivirus software trying to scan an open FMP file and corrupting it in the process. Crazy things like sending a message about an "invalid relationship" when all I am trying to do is delete a record. Article in the FMP Knowledge Base, plus a call to live tech support, led me to Answer ID 4807 which indicates the FMP files can be corrupted by antivirus software if a scan is run on the file while open.

                 Why this continues to be a problem since FM version 7 boggles my mind, quite frankly. Why hasn't Filemaker fixed this over the last FIVE versions??

            • 3. Re: file corruption due to non-Filemaker activity on CPU
              MartinPerschler

                   Correct that: Answer 5807. 

                   So, I have blocked my DB folder from the antivirus scan (which seems risky but whatever). Have been using FileMaker since version 3 and so stunned that the company has let this issue continue for so long.