Thank you for your post.
With the information I have, it is difficult to determine where and what is causing the issue. Also, since you mentioned that you have seen it 'repair' itself, this may be even more difficult to track down the cause. Are you able to reproduce the issue following specific steps?
Does anything in the FileMaker Server logs provide any hint of an issue? Have you rebooted FileMaker Server?
Try connecting directly to the MySQL database by placing the database file on your local machine along with the ESS driver. Perform the same steps as you normally would to see if the issue occurs. I realize the issue is not easily reproducible.
Keep me updated with any progress and observations.
Re: FMS 15v3 huge issue : Client-Server Cache gets corrupt / out of sync, SQL Queries unreliable - anything in here similar... could the "repair" be when the cache is deleted or expires or have you tried this and no relevance?
I am not sure why this has not been given priority, there are enough reports of people being really aversly affected by this. Filemaker have confirmed it as an issue but have not provided enough details in my opinion apart from saying they know it is an issue and that they can't say it has been fixed! We are talking about the credibility of the solutions we are providing and some massive repercuassions if financial and health data is not updating or displaying as it should be. I am sorry but as a long time user of filemaker this one is upsetting.
1 of 1 people found this helpful
Looks like 16.0.2 has solved this! I assume it was fixing the following point that did the trick:
- Under certain conditions, ESS-based tables displayed incorrect records.
Thanks for the efforts of all involved!