AnsweredAssumed Answered

Incorrect find behavior when using FileMaker Server 13

Question asked by scottworld on Oct 31, 2014
Latest reply on Nov 4, 2015 by ChrisVanBuren

Summary

Incorrect find behavior when using FileMaker Server 13

Product

FileMaker Server

Version

13.0v2

Operating system version

OS X 10.9.5

Description of the issue

I have a FMP13 database. It has a tiny script that simply performs a find on an unstored calculation field. When the file is not hosted (i.e. it is sitting locally on the server hard drive), the script runs just fine. It finds all the records that it is supposed to find.

However, as soon as I host the file with FMS 13.0v2 on OS X 10.9.5, and I open the file remotely via the FMP 13.0v3 client, the script returns a smaller set of records. It's yielding a WRONG number of records as a result of the find. The unstored calculation field is just a simple math calculation whose result does not depend on whether the file is a hosted file or a local file. The calculation field is just the total of some related line items' dollar amounts.

I ran a consistency check on the file, and FMP 13.0v3 said that it was okay.

I even recovered the file using FileMaker's "Recover" command, and it said that no problems were found.

However, even the recovered file still returns the CORRECT NUMBER OF RECORDS when the file is LOCAL, but it returns an INCORRECT NUMBER OF RECORDS when the file is HOSTED.

This makes no sense, and I have never seen anything like this before. Any ideas on how to solve this?

Outcomes