If ever we face the error Database Out of Sync, then the reason behind this is the Database Version field that’s there on the Field Service Settings form was not updated while installing the latest version.
Between Field Service versions, as schema and feature changes, Field Service ships upgrade scripts to ensure seamless upgrade for customers. The way Field Services knows that the scripts ran successfully during upgrade is by looking at the Field Service Database version.
At times, the upgrade script fails for some reasons and the Database Version is not updated.
And, this results in the Database Out of Sync error.
In order to resolve this issue, we need to undertake either of the below two approaches.
If for some reasons, this approach doesn’t work for you, then Approach 2 is the way to go.
Try following above approaches for a couple of attempts, still unsuccessful at it, you must approach Microsoft support to get proper guidance on this issue.
Hope this helps!