Azure DevOps Migration - Import Error

Question

Hi All,

We are in the process of migrating from Azure DevOps (ADO) Server 2022 with SQL Server 2019 Standard (running on Windows Server 2019) to Azure DevOps Services using the ADO Migration Tool for high-fidelity migration.

Our largest table size is 45 GB, which exceeds the 30 GB limit for the DACPAC import method. As a result, we are following the Azure SQL Method as outlined in the documentation: Migrate Large Collections.

When running the import command, we are getting the following error. Azure SQL VM has been created according to instructions from Microsoft and approprate IP rules were added based on IPs returned by "Migrator iplist" commands

https://learn.microsoft.com/en-us/azure/devops/migrate/migration-prepare-test-run?view=azure-devops#configure-ip-firewall-exceptions-for-sql-azure

Error: [Error] The HTTP request timed out after 00:01:40.

Description in the Log:

[Info @14:51:30.388] [Info] Data migration tool for Azure DevOps version 19.235.34928.5

                   [Info] Copyright (C) Microsoft Corporation. All rights reserved.

                   [Info] Executing at 2024-12-11T20:51:30.3725968Z:

                   [Info] Migrator  import /importFile:C:\DataMigrationToolFiles\import.json

[Info @14:51:30.388] -------------------------------------

                     Validating Import File

                   -------------------------------------

                   Validating import specification file...

[Info @14:51:30.669] Validation completed successfully.

[Info @14:51:30.669] Validating import source and target regions...

[Info @14:53:14.394]

                      at Microsoft.TeamFoundation.Common.RetryManager.InvokeFunc[TResult](Func`1 func)

                      at Microsoft.VisualStudio.Services.DataImport.Extensions.AzureRegionIpAddressService.GetServiceTags(ITFLogger logger)

                      at Microsoft.VisualStudio.Services.DataImport.Extensions.AzureRegionIpAddressService.GetRegions()

                      at Microsoft.VisualStudio.Services.DataImport.Extensions.AzureRegionIpAddressService.TryGetRegion(IPAddress ipAddress, String& region)

                      at Microsoft.VisualStudio.Services.DataImport.Extensions.AzureRegionIpAddressService.TryGetRegion(String nameOrAddress, String& region)

                      at Microsoft.VisualStudio.Services.DataImport.Extensions.DataImportPackageExtensions.CheckPackageRegions(DataImportPackage package, ITFLogger logger)

                      at TfsMigrator.TfsMigratorCommandImport.RunImpl()

[Info @14:53:14.410] -------------------------------------

                     Importing Collection

                   -------------------------------------

[Info @14:53:14.410] Please confirm that you wish to continue with moving your data to Azure DevOps Services.

[Info @14:54:12.523] Starting the Import ...

[Info @14:54:12.538] Connecting to https://dataimport.dev.azure.com/?account=False, Check for the authentication dialog.

[Info @14:56:16.497] Import couldn't be started due to an error!

[Error @14:56:16.497] + [Error] The HTTP request timed out after 00:01:40.

[Info @14:56:16.497] See our documentation for assistance: https://aka.ms/AzureDevOpsImportTroubleshooting

[Error @14:56:16.497] System.TimeoutException: The HTTP request timed out after 00:01:40. ---> System.Threading.Tasks.TaskCanceledException: A task was canceled.

                      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

                      at Microsoft.VisualStudio.Services.Common.VssHttpMessageHandler.

Answer 1

Hi Adnan Khan •

Welcome to the MS Q&A platform.

The query posted by you is not supported in the Q&A forum. I would request you post your query in the Azure DevOps forum

This will assist you with a faster reply to your query.

Hope this will help.

Thanks