Data Migration Assistant, assessment upload fails

Question

We're about to migrate a few databases to Azure SQL Databases.

Steps taken:

• created an azure migrate resource in our subscription (running with a private endpoint in one of our vnets, accessible over a vpn tunnel)
• updated the dma.exe.config, enabling EnableAssessmentUploadToAzureMigrate
• ran an assessment on an onprem database
• clicked "Upload to Azure Migrate"
• selected the subscription and azure migrate project
• hit upload

After a few seconds I'm presented with an error, saying "The attempt to upload assessment report to Azure Migrate Hub failed.
Operation is blocked for the solution 'Databases-Assessment-DataMigrationAssistant'."

Attaching the dma.log file. The DmaError.log file is empty, but there's a couple of exception in the dma.log file, namely:

Dma.exe Information: 0 : Uploading assessment to Azure Migrate failed: AssessmentId = '1245466c-cf54-4e04-aee4-6f2e60ea189d', ErrorType = 'Microsoft.Rest.Azure.CloudException', ErrorMessage = 'Operation is blocked for the solution 'Databases-Assessment-DataMigrationAssistant'.'.  
Dma.exe Information: 0 : 'Exception type: Microsoft.Rest.Azure.CloudException  
    Message:   
        Operation is blocked for the solution 'Databases-Assessment-DataMigrationAssistant'.  
    AdditionalMessage:   
        GetConfigRequestBlockedForSolution - Operation is blocked for the solution 'Databases-Assessment-DataMigrationAssistant'.  
    HResult : 0x80131500  
        FacilityCode : 19 (013)  
        ErrorCode : 5376 (1500)  
    Stack:   
        at Microsoft.Azure.AmhClient.SolutionsOperations.<GetConfigWithHttpMessagesAsync>d__10.MoveNext()  
        --- End of stack trace from previous location where exception was thrown ---  
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)  
        at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()  
        at Microsoft.Azure.AmhClient.SolutionsOperationsExtensions.<GetConfigAsync>d__11.MoveNext()  
        --- End of stack trace from previous location where exception was thrown ---  
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)  
        at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.AzureMigrateHub.AzureMigrateHubManagement.<UploadAssessmentToAzureMigrateHubAsync>d__c.MoveNext()  
        --- End of stack trace from previous location where exception was thrown ---  
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
        at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.AzureMigrateHub.Helpers.UploadHelper.<UploadAssessmentToAzureMigrateAsync>d__6.MoveNext()  
        --- End of stack trace from previous location where exception was thrown ---  
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)  
        at Microsoft.SqlServer.Advisor.UX.Actions.Assessments.UploadToAmhAction.<ExecuteAsync>d__2.MoveNext()  
'  
Dma.exe Information: 0 : The step 'Completed' in activity '1245466c-cf54-4e04-aee4-6f2e60ea189d' reported an error but the activity was possibly already completed or was not started  
Dma.exe Information: 0 : Unhandled exception reported, ErrorId '715213242723233220', ExceptionName 'CloudException', Error '0x80131500', StackFrame 'Microsoft.Azure.AmhClient.SolutionsOperations.<GetConfigWithHttpMessagesAsync>d__10.MoveNext', WatsonData 'BadRequest@GetConfigRequestBlockedForSolution', OuterExceptionName 'FailedToUploadAssessmentReportToAzureMigrateHub', OuterErrorCode '0x858E000A', OuterCallSite '.', OuterWatsonData 'NotSpecified'  
Dma.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Advisor.Workflows.Contracts.FailedToUploadAssessmentReportToAzureMigrateHub  
    Message:   
        The attempt to upload assessment report to Azure Migrate Hub failed.  
    HResult : 0x858E000A  
        FacilityCode : 1422 (58e)  
        ErrorCode : 10 (000a)  
    Data:   
        UploadActivityId = ErrorsLinkedToAssessmentUploadBinding_1245466c-cf54-4e04-aee4-6f2e60ea189d  
        DpesErrorReportedId = 715213242723233220  
    Inner exception type: Microsoft.Rest.Azure.CloudException  
        Message:   
            Operation is blocked for the solution 'Databases-Assessment-DataMigrationAssistant'.  
        AdditionalMessage:   
            GetConfigRequestBlockedForSolution - Operation is blocked for the solution 'Databases-Assessment-DataMigrationAssistant'.  
        HResult : 0x80131500  
            FacilityCode : 19 (013)  
            ErrorCode : 5376 (1500)  
        Stack:   
            at Microsoft.Azure.AmhClient.SolutionsOperations.<GetConfigWithHttpMessagesAsync>d__10.MoveNext()  
            --- End of stack trace from previous location where exception was thrown ---  
            at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
            at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)  
            at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()  
            at Microsoft.Azure.AmhClient.SolutionsOperationsExtensions.<GetConfigAsync>d__11.MoveNext()  
            --- End of stack trace from previous location where exception was thrown ---  
            at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
            at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)  
            at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.AzureMigrateHub.AzureMigrateHubManagement.<UploadAssessmentToAzureMigrateHubAsync>d__c.MoveNext()  
            --- End of stack trace from previous location where exception was thrown ---  
            at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
            at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.AzureMigrateHub.Helpers.UploadHelper.<UploadAssessmentToAzureMigrateAsync>d__6.MoveNext()  
            --- End of stack trace from previous location where exception was thrown ---  
            at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()  
            at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)  
            at Microsoft.SqlServer.Advisor.UX.Actions.Assessments.UploadToAmhAction.<ExecuteAsync>d__2.MoveNext()  
'  
Dma.exe Information: 0 : The step 'Completed' in activity '1245466c-cf54-4e04-aee4-6f2e60ea189d' failed with an unhandled exception with name 'FailedToUploadAssessmentReportToAzureMigrateHub'  

Running v5.4.5184.4 of the Data Migration Assistant.

I couldn't find any documentation on what ports are required for this to work, so if this could be the case, please advice which ports needs to be opened for this to work.

134996-dma.log

Answer 1

HI Tobias,

Thanks for posting.

Have you gone through this tutorial approach to ensure all the foundation requirement is taken care ?

https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql

Please go though the Prerequisites section for Port details.

"Open your Windows Firewall to allow the Azure Database Migration Service to access the source SQL Server, which by default is TCP port 1433. If you’re running multiple named SQL Server instances using dynamic ports, you may wish to enable the SQL Browser Service and allow access to UDP port 1434 through your firewalls so that the Azure Database Migration Service can connect to a named instance on your source server. Lastly, if you’re using a firewall appliance in front of your source databases, you may need to add firewall rules to allow the Azure Database Migration Service to access the source database(s) for migration, as well as files via SMB port 445"

https://bakingclouds.com/how-to-migrate-a-sql-database-to-a-azure-sql-database-managed-instance-using-the-azure-database-migration-service/
.

Answer 2

I've not come to the migration part yet, this is only for the assessment upload.
I'm running the Migration Assistant on my own computer, against the on-prem database server.

The connection to the SQL server and the assessment is fine, it's the upload of the report to the Azure Migration resource in Azure that's the problem.