Field type change problem
We have changed a few fields from type calculation to type text with auto calculated value box checked and encountered the problem with one of the fields, which seem not to be updated correctly and caused the commit (save) process to hang. We had to force quit the application, verified the database file through FM Server console, and there seemed to be no errors.
However, there is something wrong, I will try to describe the problem. When we tried to do the search through another field from the same file, it was running too long, without result and only by some values. By some other values, the search run quickly. Also, we opened manage database and hit ok, without any actual changes, and the database hanged. Now, the fmserverd process on the server is eating all the CPU on the server.
It seems like there is problem with indexes, or that they are being rebuilt.
Hope it's clear enough. Any ideas, please?