Finds quit working until Database Server Restart

[phcranston]

I have an ongoing issue with a FileMaker 11 Server (Mac OS). Every 4-6 weeks searches ( ie Finds ) on the database quit working properly. If you are in a table for data stored in the table it works fine, however if you are searching for data stored in a related table or searching a calculation that uses related data the Find returns bad results. The issue presents itself when running Finds from a client or directly on the FMS using server side scripts.

The temporary fix for this is to close the database, stop the database server and then restart the database server. The issue goes away for awhile but comes back after several weeks. The whole server does not need to be rebooted just the database server itself.

Does anyone have any thoughts as to why this might be happening and how to permanently resolve it.

Thanks

[bcooney]

This could be how you're constucting your Find or a corrupt index. Can you provide more details--for what are you Finding?

[JerrySalem]

I have seen similar issues when we were using FMS10 with a mixture of FMP9 and 10 clients.

Do you have a mixture of clients or is everyone on (presumably) FMP11?

But most likely it is a corrupt index.

Jerry

[phcranston]

We used to have a mix of clients but everyone has been upgraded to FM11 several months ago and the problem still exists. The find is looking for Active Clients ( designated by a 1 in a "flag" field ) and for Past Due Amounts > 0. The Past Due Amount is a calculation that is pulling data from and Invoice and Payment Join Table. The find starts to fail when searching the PastDueAmount calculation field that is looking up the related data. As stated earlier it works fine for a while (several weeks to several months) after a database server restart and then starts to fail again. I rebooted the server about three weeks ago now and it is still finding properly for now.