jayivan

Temporary Missing Record in Client that Created Record

Discussion created by jayivan on Dec 9, 2015
Latest reply on Dec 10, 2015 by TSGal

I'm having an issue where a user creates a record in a table, the total record count and doesn't increase, and show all records will exclude this newly created record. Other connected users see the total record count increase.

 

For example, let's say I have a table of Widgets. There are 1,000 records, and the last ID number is 1000. I create a new widget, and see the ID number is 1001. However, the total record count is still 1,000. I press show all records, and record 1001 disappears, and the last record in the system is ID of 1000 according to my client. If I press show omitted only, I don't see my omitted record with ID of 1001. If I do a find for ID 1001, I do find my record. Other connected users see that there are a total of 1,001 records, and do not have this issue. This problem is intermittent, and impacts multiple users. Reconnecting to the database resolves the issue.

 

Obviously this is worrying since it opens up the potential that a client is not fully reading the contents of the hosted database. Is there some kind of aggressive client caching involved that is leading the client to not refresh its information? Is there another possible way to make sure this doesn't happen? Casual users are unlikely to know that a record they just created may get missed in any reports or database actions they run. Requiring a reconnect to a database after adding a new record is not an acceptable workaround.

 

FileMaker Pro 14.0.4 on Mac OS X 10.10.5 connecting via the LAN to FileMaker Server 14.0.2 on Mac OS X 10.10.5.

Outcomes