Finds on client do NOT work properly on server
Finds performed in calculated fields on FMS 12.0v5 on XServe are not correct. Finds in a calculated number field of >0 return improper results. Download the same file to FMA 12.0v5 and the finds perform correctly. Put it back on the server with nothing else changed and they do not work correctly. A restart of the server seems to fix the issue temporarily.
Attach 1. Find on server (FMS 12.0v5) for Show# and BalDue > 0 with incorrect results
Attach 2. Find on server for Show# and sort BalDue descending
Attach 3. Find on same downloaded file on client (FMA 12.0v5) with correct results for Show# and BalDue > 0.
Attach 4. Forum comment about same issue.
Finds > 0 in calculated number field do not return all records with amounts > 0. Yes all referenced fields are number fields and Do not evaluate if empty is unchecked. All calc fields are unstored. Also tried > .000001 and same incorrect result.
The calculated field is Balance Due which equals Sum(Order Items) less Sum(Payments). Any record that has Payments and still Balance Due, is not included in the find.
Can find all records and sort descending and in those results see the correct list. But this is not a workaround. Have to view all records.
A restart of the server corrected the issue. Why is the server losing it's indexes over time. We have seen this before and need the server engine to be more reliable handling finds.