Custom.ReflectedWorkItemId not found even though it's there

[rosendaldk]

If you look at the log you can see this query:

SELECT [System.Id], [Custom.ReflectedWorkItemId] FROM WorkItems WHERE [System.TeamProject] = 'arotest' AND System.WorkItemType = 'Impediment' AND Custom.ReflectedWorkItemId < '9999' ORDER BY [System.ChangedDate] desc

I reference Custom.ReflectedWorkItemId, so obviously it's present.
Is this a bug in the tool?

My config
"Source": {
"$type": "TfsTeamProjectConfig",
"Collection": "https://dev.azure.com/2342345/",
"Project": "test2",
"ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
"AuthenticationMode": "AccessToken",
"AllowCrossProjectLinking": false,
"PersonalAccessToken": "fgfghfghfgh",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
}

[12:42:12 DBG] WorkItemQuery: TeamProjectCollection: https://dev.azure.com/345345345/
[12:42:12 DBG] WorkItemQuery: Query: SELECT [System.Id], [Custom.ReflectedWorkItemId] FROM WorkItems WHERE [System.TeamProject] = 'arotest' AND System.WorkItemType = 'Impediment' AND Custom.ReflectedWorkItemId < '9999' ORDER BY [System.ChangedDate] desc
[12:42:12 DBG] WorkItemQuery: Parameters: {"TeamProject": "arotest"}
[12:42:12 DBG] WorkItemQuery: TeamProject: arotest
[12:42:12 DBG] Query sent
[12:42:15 DBG] FilterByTarget: ... query complete.
[12:42:15 DBG] FilterByTarget: Found 0 based on the WIQLQueryBit in the target system.
[12:42:15 DBG] FilterByTarget: After removing all found work items there are 3 remaining to be migrated.
[12:42:15 DBG] FilterByTarget: END
[12:42:15 INF] !! After removing all found work items there are 3 remaining to be migrated.
[12:42:15 WRN] ValidatingRequiredField: Impediment does not contain Custom.ReflectedWorkItemId
[12:42:15 ERR] Not all work items in scope contain a valid ReflectedWorkItemId Field!
Microsoft.TeamFoundation.WorkItemTracking.Client.InvalidFieldValueException: Not all work items in scope contain a valid ReflectedWorkItemId Field!
[12:42:15 INF] DONE in 00:00:04.8551582
[12:42:15 FTL] Error while running WorkItemMigration
Microsoft.TeamFoundation.WorkItemTracking.Client.InvalidFieldValueException: Not all work items in scope contain a valid ReflectedWorkItemId Field!
at VstsSyncMigrator.Engine.WorkItemMigrationContext.InternalExecute() in D:\a\1\s\src\VstsSyncMigrator.Core\Execution\MigrationContext\WorkItemMigrationContext.cs:line 123
at MigrationTools._EngineV1.Processors.MigrationProcessorBase.Execute() in D:\a\1\s\src\MigrationTools_EngineV1\Processors\MigrationProcessorBase.cs:line 47

[alainbryden]

The key log here is "Impediment does not contain Custom.ReflectedWorkItemId"

So on your new ("Target") DevOps system, the "Impediment" work item type is missing that field.

My guess is that, if anything, you added this field to the "Source" DevOps, which isn't even required. Only the "Target" system needs this field added to all ticket types you are migrating.

[sonicadv27]

Only the "Target" system needs this field added to all ticket types you are migrating.

The documentation on https://nkdagility.github.io/azure-devops-migration-tools/getting-started.html clearly states the ReflectedWorkItemId is needed on both the Source and Target. It's not the first time i see people saying it's not needed on Source so if that's true it's probably best to update the documentation, which quite frankly is due for an update anyway.