Jump to content

Finds quit working until Database Server Restart


phcranston
 Share

This topic is 4319 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

This topic is 4319 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.