1 Reply Latest reply on Jul 15, 2010 4:48 PM by philmodjunk

    Data Missing from Database

    AthenaDraper

      Title

      Data Missing from Database

      Your post

      I recently upgraded from FM Sever 9 to FMServer 11. Now there are records missing from the data base.  Any one had this issue?

        • 1. Re: Data Missing from Database
          philmodjunk

          It seems unlikely that the upgrade had anything to do with the missing records as the file format from filemaker 7 to 11 is unchanged.

          I suggest investigating other possible causes.

          Perhaps the records were already missing and you only now spotted their absence?

          Any scripts that delete record that might go awry?

          Any cascading deletes defined in your relationships?

          Are your field indexes OK? (a corrupted index can keep finds and sorts from working correctly and this can make records appear to be missing because they couldn't be found.)