question

TobiasLolax-9478 avatar image
0 Votes"
TobiasLolax-9478 asked DuncanMcIntyre-2466 published

Data Migration Assistant, assessment upload fails

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



azure-database-migrationsql-server-migration-assistant
dma.log (107.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Dev073 avatar image
0 Votes"
Dev073 answered

HI Tobias,

Thanks for posting.

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

https://docs.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/
.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TobiasLolax-9478 avatar image
0 Votes"
TobiasLolax-9478 answered DuncanMcIntyre-2466 published

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Good day,

Have you been able to resolve this?

I have the same issue.

0 Votes 0 ·