Recover command giving false positive results

Discussion created by AllegroDataSolutions on Dec 14, 2016
Latest reply on Dec 14, 2016 by AllegroDataSolutions

I have found at least one instance where the Recover command in FileMaker 15 was run on a file and reported no problems, only to find that a subsequent Recover on the same file (not a copy, and not the recovered file) reported two unspecified errors that were severe enough to warrant a warning not to use the second recovered file.


I was having issues prior to running Recover the second time. Specifically, I found that finding duplicate records and updating records with an import using match fields were producing unpredictable results and then ceased working entirely. I ran Recover on the file and when it reported errors, I went back and re-Recovered the original (which it previously determined was uncorrupted). At that point, it found the same issues with the original file (which had been behaving normally when I worked on it.)


The client had worked on this file in layout mode while it was hosted on a shared WAN server, adding and modifying fields, layouts, and scripts. So there were opportunities for corruption to occur before the file reached me. That was what prompted me to Recover the file to determine whether to modify the original or rebuild it from scratch.


FileMaker 15 has not been updated since the first and second scans of the original file, so I have to conclude that the first Recovery (which reported no problems) was a false positive. In this case, that false result rendered all my subsequent work on the file to date useless (at a cost of over $4,000 to my client). A very frustrating and costly expense for all concerned.