Collector error on Data Migration Assistant when running assessment

Ben C 1 Reputation point
2022-09-06T11:23:36.47+00:00

Hi,
I am running DMA on my local dev machine (as an admin), connecting to a locally installed SQL2019 instance, where I am also an SA. When I run an assessment on any database I receive the following error: 

The server instance-level assessment of server 'MyServer' failed.  
Feature discovery error message: 'There was an unexpected exception when discovering features for server 'MyServer'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.Collectors.ServerPropertiesFeatureCollector' failed to collect data.'.

I'm using the latest DMA tool, running as admin, with admin rights on machine and on SQL instance as mentioned. The localhost machine is a Windows 10 1909 system.

Looking at the DMA logs I can see: 

Dma.exe Information: 0 : Completed Action: DiscoverFeaturesAssessmentAdvisor  
Dma.exe Information: 0 : Completed Action: If  
Dma.exe Information: 0 : Running Action: If  
Dma.exe Information: 0 : Completed Action: If  
Dma.exe Information: 0 : Running Action: UpdateAssessmentServerInstanceModels  
Dma.exe Information: 0 : Unhandled exception reported, ErrorId '9521917315241486963', ExceptionName 'FailedtoDiscoverSourceFeaturesException', Error '0x858E000F', StackFrame '.', WatsonData 'NotSpecified', OuterExceptionName 'ServerAssessmentFailedException', OuterErrorCode '0x86040001', OuterCallSite '.', OuterWatsonData 'NotSpecified'  
Dma.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Advisor.Common.Contracts.ServerAssessmentFailedException  
    Message:   
        The server instance-level assessment of server 'MyServer' failed.  
    HResult : 0x86040001  
        FacilityCode : 1540 (604)  
        ErrorCode : 1 (0001)  
    Data:   
        ServerName = MyServer  
        DpesErrorReportedId = 9521917315241486963  
    Inner exception type: Microsoft.SqlServer.Advisor.Workflows.Contracts.FailedtoDiscoverSourceFeaturesException  
        Message:   
            Feature discovery error message: 'There was an unexpected exception when discovering features for server 'MyServer'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.Collectors.ServerPropertiesFeatureCollector' failed to collect data.'.  
        HResult : 0x858E000F  
            FacilityCode : 1422 (58e)  
            ErrorCode : 15 (000f)  
        Data:   
            ErrorMessage = There was an unexpected exception when discovering features for server 'MyServer'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.Collectors.ServerPropertiesFeatureCollector' failed to collect data.  
'  
Dma.exe Information: 0 : The step 'Completed' in activity '45f343d9-9875-4088-a8f1-d8b38ae69211' failed with an unhandled exception with name 'ServerAssessmentFailedException'  
Dma.exe Information: 0 : The step 'Completed' in activity '45f343d9-9875-4088-a8f1-d8b38ae69211' had a final outcome of 'Failed'

As this is all running locally, with admin rights everywhere, I'm not sure what could be causing the issue so wondered if anyone from MSFT could advise?
Thanks,
Ben C

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,027 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 26,016 Reputation points MVP
    2022-09-06T11:58:24.073+00:00

    My suggestion is to disable any security software (antivirus, etc) that is preventing a Web Browser to pop up. A browser window is supposed to kick off at first, and some security extensions block that kind of activity.

  2. Seeya Xi-MSFT 14,806 Reputation points Microsoft Vendor
    2022-09-07T09:30:33.233+00:00

    Hi @Ben C ,

    Please read this document first to check if there are any non-compliance.
    https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.