Product and version: FileMaker Pro Advanced 16.0.1
OS and version: Mac OS 10.11.6
Hardware: MacBook Pro
We have a system that uses ESS to pull data from a customer web portal with a MySQL backend. This works fine with FM Pro 15 clients, but testing with FM Pro 16 (including Advanced, Win & Mac) has shown some problems.
These screen shots show fields from a base table and a portal to a related table, both ESS tables. The relationship is just the two id fields being equal.
Here it is in FM Pro Advance 15:
And here it is in FM Pro Advanced 16:
When I do a find on the related table layout (a layout with the related table as the base table) for the id, it finds the record with id 60. If I show all records, id 60 is the first record (despite these being auto-entered serial by MySQL, and all other records are in order when unsorted). Cycling through the records, id 171 is missing.
The record count in the related table is 868 in FM 16, 869 in FM 15.
Note that this is just two clients (FMPA 15 & 16) running on one machine, both looking at the same data on the same server.
Server is FMS 14.0.4 – is this likely to be the issue? Was the ESS engine changed between server versions, and 16 now assumes a more recent one?
How to replicate
This is going to be difficult. Only one record is currently out of sync, and I have seen it 'repair' itself: looking for the missing record on the related base layout was successful; looking back at the layout with the portal, the incorrect id changed to the correct one. Looking later found another record with a mismatched related record.
Workaround: None known.