Troubleshooting Service Update Issues in a Cloud-Hosted D365 F&O with Global Update Script

Dynamics 365 for Finance and Operations is a powerful platform that provides extensive capabilities for managing business operations. 

However, sometimes deploying changes to environments can be challenging, particularly when errors occur during the process. 

One common issue that can arise is a database sync error, which can prevent changes from being properly deployed.

Thankfully, there are measures that can be taken to address and resolve this particular problem

In this blog post, we'll walk you through the process of resolving a database sync error in Dynamics 365 for Finance and Operations.

 Database Sync error.

To resolve the issue, follow these steps:

Step 1: Locate DBSync in VM

To resolve a database sync error, you'll first need to locate DBSync. 

The executable file syncEngine.exe, which belongs to DBSync, is commonly found in the directory \AosService\PackagesLocalDirectory\bin on the service volume.

Step 2: Run Command in Administrator Mode

Executing a Command in Administrator Mode Using CMD

[ServiceDriveLetter]:\AOSService\PackagesLocalDirectory\bin\syncengine.exe -syncmode="fullall" -metadatabinaries="[ServiceDriveLetter]:\AOSService\PackagesLocalDirectory" -connect="Data Source=[Servername];Initial Catalog=[DatabaseName];Integrated Security=False;User ID=[];Password=[]" -verbosity="Diagnostic" > DbSync.log 2> DbSync.err

Replaced with below details:

[ServiceDriveLetter] = G

[ServerName] = customerServer

[DatabaseName] = customerAxDb

[UserName] = ________            // Typically: axdbadmin

[Password] = ________

Once you have executed this command, navigate to the path specified :

Step 3: Check the Output of the DBSync

Once you've run the command, navigate to the DBSync file and check the output. If the sync is successful, you'll be able to proceed with your deployment without any issues.

Step 4: Retry Deployment

Once the sync is complete, retry your deployment. With the database synced, you should now be able to deploy your changes without any errors.

In summary, resolving a database sync error in Dynamics 365 for Finance and Operations is a relatively straightforward process. 

By following these steps, you can quickly get your environment up and running again and get back to managing your business operations.