Migration tool is not picking up any workitem neither throwing an error.

[madhuripawar2212]

While running the migration tool to migrate the workitems, its just finishing the migration with out recognizing any workitems and its not even throwing any errors. I am using the latest version

Configuration:
{
"Version": "15.0",
"Endpoints": {
"AzureDevOpsEndpoints": [
{
"name": "Target",
"$type": "AzureDevOpsEndpointOptions",
"Organisation": "https://dev.azure.com//",
"Project": "",
"AuthenticationMode": "AccessToken",
"AccessToken": "",
"EndpointEnrichers": null
},
{
"Name": "Source",
"$type": "AzureDevOpsEndpointOptions",
"Organisation": "https://dev.azure.com//",
"Project": "",
"AuthenticationMode": "AccessToken",
"AccessToken": "",
"EndpointEnrichers": null
}
],
"TfsEndpoints": [
{
"Name": "MyTarget",
"Organisation": "https://dev.azure.com//",
"Project": "",
"AuthenticationMode": "AccessToken",
"AccessToken": ""
},
{
"Name": "MySource",
"Organisation": "https://dev.azure.com//",
"Project": "",
"AuthenticationMode": "AccessToken",
"AccessToken": ""
}
]
},
"ChangeSetMappingFile": null,
"Target": {
"$type": "TfsTeamProjectConfig",
"Collection": "https://dev.azure.com//",
"Project": "",
"ReflectedWorkItemIDFieldName": "ReflectedWorkItemId",
"AllowCrossProjectLinking": false,
"AuthenticationMode": "AccessToken",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
}
},
"Source": {
"$type": "TfsTeamProjectConfig",
"Collection": "https://dev.azure.com//",
"Project": "",
"ReflectedWorkItemIDFieldName": "ReflectedWorkItemId",
"AllowCrossProjectLinking": false,
"AuthenticationMode": "AccessToken",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
}
},
"GitRepoMapping": null,
"LogLevel": "Debug",
"CommonEnrichersConfig": [],
"Processors": [
{
"$type": "WorkItemMigrationConfig",
"Enabled": true,
"UpdateCreatedDate": true,
"UpdateCreatedBy": true,
"WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @teamproject AND [System.WorkItemType] IN ('Program', 'Portfolio', 'Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] DESC",
"FixHtmlAttachmentLinks": true,
"WorkItemCreateRetryLimit": 5,
"FilterWorkItemsThatAlreadyExistInTarget": false,
"PauseAfterEachWorkItem": false,
"AttachRevisionHistory": false,
"GenerateMigrationComment": true,
"WorkItemIDs": null,
"MaxGracefulFailures": 0,
"SkipRevisionWithInvalidIterationPath": false,
"SkipRevisionWithInvalidAreaPath": false
},
{
"$type": "TestVariablesMigrationConfig",
"Enabled": false
},
{
"$type": "TestConfigurationsMigrationConfig",
"Enabled": false
},
{
"$type": "TestPlansAndSuitesMigrationConfig",
"Enabled": false,
"PrefixProjectToNodes": false,
"OnlyElementsWithTag": null,
"TestPlanQueryBit": null,
"RemoveAllLinks": false,
"MigrationDelay": 0,
"UseCommonNodeStructureEnricherConfig": false,
"NodeBasePaths": [],
"AreaMaps": null,
"IterationMaps": null,
"RemoveInvalidTestSuiteLinks": false,
"FilterCompleted": false
},
{
"$type": "AzureDevOpsPipelineProcessorOptions",
"Enabled": false,
"MigrateBuildPipelines": true,
"MigrateReleasePipelines": true,
"MigrateTaskGroups": true,
"MigrateVariableGroups": true,
"MigrateServiceConnections": true,
"BuildPipelines": null,
"ReleasePipelines": null,
"RefName": null,
"SourceName": "Source",
"TargetName": "Target",
"RepositoryNameMaps": {}
},
{
"$type": "TfsSharedQueryProcessorOptions",
"Enabled": false,
"PrefixProjectToNodes": false,
"SharedFolderName": "Shared Queries",
"SourceToTargetFieldMappings": null,
"ProcessorEnrichers": null,
"SourceName": "MySource",
"TargetName": "MyTarget"
}
]
}

[MrHinsh]

I can see in the log screenshot that you provided that you query is returning 0 work items to Migrate!

Try changing "IN" to "NOT IN"

[MrHinsh]

TeamProject is case Sensitive, however GitHub uses @ for special features and auto lowercases it.

[madhuripawar2212]

I have tried SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @teamproject AND [System.WorkItemType] NOT IN ('Program', 'Portfolio', 'Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] DESC - Getting the same error as above screenshot.

When I use - SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = Teamproject AND [System.WorkItemType] NOT IN ('Program', 'Portfolio', 'Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] DESC, I am gettng the below error

[madhuripawar2212]

@MrHinsh - I want to migrate only one workitem and I am using the workitem id. I am using the below query. Is this correct?

"SELECT [System.Id] = 853 FROM WorkItems WHERE [System.TeamProject] = @teamproject AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] desc",

[MrHinsh]

No, this is not a valid query.

Clauses come after the where.

https://learn.microsoft.com/en-us/azure/devops/boards/queries/wiql-syntax?view=azure-devops

[madhuripawar2212]

Thank you! We can mark this as answered