Our FileMaker Pro 16 has shut down on numerous occasions and we lose all data entered from our last back up. Which we do every night. There are about 24 users. Is anyone else having this problem? Are then any suggestions?
What's your full system Setup?
Do you have a time when this happens?
Are there any signs that the shut down is about to happen?
How are you sharing your information and how are users connecting?
If you can give me a bit more to go on, I will see what advice and suggestions I can give you
This is not a solution, but if you did an incremental back up, the amount of data lost would be much less. Of course, you may not be using FileMaker server and this illustrates one of the major advantages to using server to host your solution.
Thank you for your time. I hope this information helps!
We are running FileMaker Server on a mac, and have 30 machines that connect to it. There are only 1000 records in our main database, but the database is wide (5000 fields or so) and we also have a decent number of PDF images in it as layouts. We use this to print forms
Last time was 3 PM in the afternoon. Not sure about other times. I don’t think there is anything special that happens at that time
Not really - possibly the database slows down when doing structural tasks such as creating fields. The database does not shutdown, but just each of the field in every records appears as if it is blank. Though data still seems to be there - since we can do searches.
FMP Server 16 on a Mac is a server. Client use macs also running FMP 16 or FMP Advanced 16 and open the files on the server by way of a script.
All the best!
Since you have Server, please consider an incremental back up as a way to minimize data loss. Even when you get this one resolved, shut downs/restarts can happen and the incremental back should keep data loss to a minimum.
So what I would like to know is, do your users get disconnected when this happens and then everyone can just log back in or do you have to restart the server to get everything back up and running?
I run into this situation sometimes at clients who are running a FileMaker Server with a battery backup and the batteries are going out and start regularly dropping power. Are you using a UPS? What is its condition? Are the batteries old?
When it happens users do not get disconnected. They just all see the records with all fields blank. If they disconnect themselves and reconnect they still see it. When we try to recover the file almost all of the records are removed and there are only 2 records or so left. It seems like there may be some corruption or issues with indexes or something at that point and we have never really found a solution that get us back up and running other than rolling back to the previous night’s backup
Does this mean that you do not have a crash, but the data just disappears on you?
Yes, it is not a crash as such, but the data just disappears
Thanks. The battery back up looks pretty new and does not exhibit signs of failure such as a sound or having its green light go off. Also the database server never looses power and turns off.
I think that most of the suggestions here have you looking in the wrong direction as this was originally described as a "shut down".
Have you considered that some process in your solution is deleting all data from one or more tables? That may have nothing do you with your system design, but could instead be caused by a script that deletes more records than it should or a cascading delete that deletes all records after the user deleted as little as a single record.
I would review all scripts that use the "delete all records" script step for possible issues and examine your relationship graph for any relationships where the "delete" check box is enabled. If you have "delete" specified, you might temporarily clear them and see if this keeps your solution from coming up "empty".
FileMaker requires a persistent connection between the client and server. Is it possible you are having network problems. I would particular suspect network problems if all of them are having the same problem at the same time. If FileMaker drops a connection, it will try to reconnect, but it often fails particularly if the network isn't ready to recover. If all are failing and the server is still running with no crash or power down, then there is a good chance you have a network issue.
Retrieving data ...