Error during install of Azure Database Migration Service worker

Question

Hello community,

I'm trying to use Azure Database Migration Service for MySQL (Hybrid mode), to migrate Onprem MySQL database to Azure Flexible MySQL Server.

I carry out the following procedure:

https://download.microsoft.com/download/e/c/c/ecc45361-0426-48f6-8c7d-af3c0af7339b/Step-by-Step%20Guide%20to%20Install%20Hybrid%20DMS.pdf

But I got an issue during the installation of DMSWorkerBootstrap.exe to register my hybrid worker:

Inner exception type: System.IO.FileNotFoundException
    Message: 
        Impossible de charger le fichier ou l'assembly 'Microsoft.ApplicationInsights, Version=2.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ou une de ses dépendances. Le fichier spécifié est introuvable.
    HResult : 2
        FacilityCode : 7 (007)
        ErrorCode : 2 (0002)
Inner exception type: System.IO.FileNotFoundException
    Message: 
        Impossible de charger le fichier ou l'assembly 'Microsoft.ApplicationInsights, Version=2.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ou une de ses dépendances. Le fichier spécifié est introuvable.
    HResult : 2
        FacilityCode : 7 (007)
        ErrorCode : 2 (0002)
DateTime=2025-01-29T09:01:56.4940591Z

2025-01-29 10:01:56.509 +01:00 [ERR] Setup failed to run the workflow. 2025-01-29 10:01:56.530 +01:00 [ERR] DMSWorkerBootstrap.Exceptions.AgentExitedWithFailureException: Hybrid worker service failed with: '-2146232830' and parameters '/install'. at DMSWorkerBootstrap.WorkflowActions.ActionRunAgentProcess.ExecuteAsync(String installPath, String arguments) at DMSWorkerBootstrap.Workflows.InstallWorkflow.RunAsync(SetupArgs setupArgs, ConfigSettings settings, CancellationToken cancellationToken) at DMSWorkerBootstrap.Services.SetupService.RunWorkflowAsync(ISetupWorkflow workflow, ConfigSettings settings, CancellationToken cancellationToken)

Does someone already used this service for doing that kind of migration ? Does this service still maintained/updated by Azure ?

Answer 1

It looks like you're having trouble installing the Azure Database Migration Service (DMS) Worker due to a missing file, specifically the 'Microsoft.ApplicationInsights' assembly. Here are a few steps you can take to resolve this issue:

Check Dependencies: Make sure that all required dependencies for the DMSWorkerBootstrap.exe are installed. This includes the correct version of the .NET Framework.

Install Application Insights: Try to manually install the Microsoft.ApplicationInsights package. You can do this through NuGet in your development environment or download it directly if available.

Run as Administrator: Make sure you are running the installation as an administrator. Right-click on the installer and select "Run as administrator."

Check for Updates: Ensure that you have the latest version of the Azure Database Migration Service and any related tools. Microsoft regularly updates its services, so it’s good to have the latest version.

Consult Documentation: Revisit the installation guide you are following to ensure you haven't missed any steps. Sometimes, small details can be overlooked.

Seek Support: If the issue persists, consider reaching out to Microsoft support or checking their forums. Other users may have faced similar issues and can offer solutions.