Data Migration Assistant 5.5 analysis error

Question

When running an Azure Managed Instance analysis, it errors on some of the databases. Rerunning always causes the same error on the same databases: (Side note, MS, you misspelled exception as excreption in the error detail)

dma.exe Information: 0 : Unhandled exception reported, ErrorId '7775280264598791071', ExceptionName 'FailedtoDiscoverSourceFeaturesException', Error '0x858E000F', StackFrame '.', WatsonData 'NotSpecified', OuterExceptionName 'DatabaseAssessmentFailedException', OuterErrorCode '0x86020001', OuterCallSite '.', OuterWatsonData 'NotSpecified'
dma.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Advisor.Common.Contracts.DatabaseAssessmentFailedException
Message:
The assessment of database 'MyDB' on server 'MyServer' failed.
HResult : 0x86020001
FacilityCode : 1538 (602)
ErrorCode : 1 (0001)
Data:
DatabaseName = MyDB
ServerName = MyServer
DpesErrorReportedId = 7775280264598791071
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' and database 'MyDB'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.FeatureCollectors.Database.TSqlCodeAnalysisFeatureCollector' 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' and database 'MyDB'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.FeatureCollectors.Database.TSqlCodeAnalysisFeatureCollector' failed to collect data.
'
dma.exe Information: 0 : The step 'Completed' in activity '07ef12e8-e22a-497a-bc87-92e3088121e9' failed with an unhandled exception with name 'DatabaseAssessmentFailedException'
dma.exe Information: 0 : Assessment Database Info Status Changed: DatabaseId = 'c1cb268b-5902-4395-aa65-3b50ec4692eb', DatabaseStatus = 'Error'.
dma.exe Information: 0 : Finished Assessing Database: ActivityId = '378063cb-4dcc-4770-ac28-dd47ff111dfa', AssessmentId = '07ef12e8-e22a-497a-bc87-92e3088121e9', DatabaseId = 'c1cb268b-5902-4395-aa65-3b50ec4692eb', Status = 'Error'.

Answer 1

Hi @Jason Allen ,

I am from DMA eng team.

I can explain this issue a little bit. It is syntax issue, which means that one of TSQL object (sp, views, etc) in your database MyDB is not compatible with the current sql server verson or database compatibility level. I think the log will indicate which specific object has this syntax error. You also can repro this issue on SSMS (Sql Server Management Studio). Copy this script and run it on MyDB by SSMS.

Thanks,
Siyang