AnsweredAssumed Answered

Records disappearing unexpectedly, intermittent problem.

Question asked by PhilHanson on Oct 22, 2010
Latest reply on Nov 24, 2010 by TSGal


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.