1 Reply Latest reply on Nov 24, 2010 3:01 PM by TSGal

    Records disappearing unexpectedly, intermittent problem.



      Records disappearing unexpectedly, intermittent problem.


      FileMaker Server



      Operating system version

      Windows 7

      Description of the issue

      Occasional intermittent problem with records disappearing permanently, and taking related records with them.

      Set up
      FMS11 on Windows 7 Professional
      Clients on Macs and PC's running FMP11

      Steps to reproduce the problem

      Operator generates a new record in table 1, or uses an existing record in table 1.
      Operator Creates a record in a join table (2) to relate the record to one in a third table (3).

      Expected result

      Operator goes to a table 3 layout to see the related record from table 1 in a portal,

      Actual result

      The record is not in the portal. Search in table 1 reveals no trace of the record. Search for records in the join table (2) also no sign of any JT records.

      Exact text of any error message(s) that appear

      No error messages or indications that anything went wrong.

      Using the recover command on a copy of the file gives a result that the database is not damaged.

      Configuration information

      The relationship is set to automatically delete records in table 2 (the join table) when deleting a record in table 1. Not vice-versa.

      A version of the same database in a similar server environment (copied two years ago) appears to be experiencing the same problem, although neither had this problem ever before.

      Seems to occur only once in about every 500 times.

        • 1. Re: Records disappearing unexpectedly, intermittent problem.

          Phil Hanson:

          Thank you for your post.

          These intermittent problems are difficult to diagnose.

          Check to make sure you don't have a script that deletes a record in table 1 (as this would delete records in table 2).  Also, check your relationship graph to see if there are any other relationships to table 1 that might include automatically deleting related records.  Also, make sure none of the clients delete a record in table 1.

          Any other information you can provide may be helpful.

          FileMaker, Inc.