FilterWorkItemsThatAlreadyExistInTarget - not replacing the proj name in the target query

[NormanGarciaV]

Hi,

I successfully use v15.1.7 to migrate work-items using an area path in the query. Now traying a new area path... and the error seems to be back...

it seems when starts the FilterExistingWorkItems, the project name does not get replace in the target query. (Full log file attached below).

[12:47:54 INF] [15.1.7] Found target project as NGScrumTemplateTest
[12:47:54 INF] [15.1.7] [FilterWorkItemsThatAlreadyExistInTarget] is enabled. Searching for work items that have already been migrated to the target...
[12:47:54 DBG] [15.1.7] NodeStructureEnricher.GetNewNodeName(Teck\HRIS Global Support - FRO Hourly, Area)
[12:47:54 DBG] [15.1.7] NodeStructureEnricher.GetNewNodeName::Mappers
[12:47:54 INF] [15.1.7] [FilterWorkItemsThatAlreadyExistInTarget] is enabled. Source project Teck is replaced with target project NGScrumTemplateTest on the WIQLQuery which resulted into this target WIQLQueryBit "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = 'Teck' AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') AND [System.AreaPath] UNDER 'NGScrumTemplateTest\HRIS Global Support - FRO Hourly' ORDER BY [System.ChangedDate] desc" .

The target query still has the source project name above.

[12:47:54 DBG] [15.1.7] FilterExistingWorkItems: START |
[12:47:54 DBG] [15.1.7] FilterByTarget: Query Execute...
[12:47:54 DBG] [15.1.7] WorkItemQuery: ===========GetWorkItems=============
[12:47:54 DBG] [15.1.7] WorkItemQuery: TeamProjectCollection: https://dev.azure.com/elkvalleyresources/
[12:47:54 DBG] [15.1.7] WorkItemQuery: Query: SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = 'Teck' AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') AND [System.AreaPath] UNDER 'NGScrumTemplateTest\HRIS Global Support - FRO Hourly' ORDER BY [System.ChangedDate] desc
[12:47:54 DBG] [15.1.7] WorkItemQuery: Parameters: {"TeamProject": "NGScrumTemplateTest", "ReflectedWorkItemIdFieldName": "Custom.ReflectedWorkItemId"}
[12:47:54 DBG] [15.1.7] WorkItemQuery: TeamProject: NGScrumTemplateTest
[12:47:54 DBG] [15.1.7] WorkItemQuery: ReflectedWorkItemIdFieldName: Custom.ReflectedWorkItemId
[12:47:54 DBG] [15.1.7] Query sent
[12:47:54 ERR] [15.1.7] Error running query
Microsoft.TeamFoundation.WorkItemTracking.Client.ValidationException: The project specified is not found in hierarchy. The error is caused by «'Teck'».
at Microsoft.TeamFoundation.WorkItemTracking.Client.Query.Initialize(WorkItemStore store, String wiql, IDictionary context, Int32[] ids, Int32[] revs, Boolean dayPrecision)
at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore.Query(String wiql, IDictionary context)
at MigrationTools._EngineV1.Clients.TfsWorkItemQuery.GetWorkItemsFromQuery(TfsWorkItemMigrationClient wiClient) in D:\a\azure-devops-migration-tools\azure-devops-migration-tools\src\MigrationTools.Clients.AzureDevops.ObjectModel_EngineV1\Clients\TfsWorkItemQuery.cs:line 53

QueryError_migration-3.log

any help would be appreciated.

Thanks
Norman.

[NormanGarciaV]

I only changed the target project name, and the source project name in the query of the config file.
I wonder if this is happening due that the Org name is the same as the project name in the source.

[MrHinsh]

The project name should not matter... it looks like the name is not replaced in the area path...

[NormanGarciaV]

Hi @MrHinsh

No, I think is the project name that is not being replaced...

The source project name is Teck
The target porject name is NGScrumTemplateTest

in the resulting query, the area is ok.. but the project name is still Teck.

Source project Teck is replaced with target project NGScrumTemplateTest on the WIQLQuery which resulted into this target WIQLQueryBit "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = 'Teck' AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') AND [System.AreaPath] UNDER 'NGScrumTemplateTest\HRIS Global Support - FRO Hourly' ORDER BY [System.ChangedDate] desc

[NormanGarciaV]

Hi @MrHinsh

Very interesting... the only way I could make it work.. I changed my target project name, to the same name as the source and the it worked.

Also.. I run successfully another migration, where the project name is not Teck, and it did worked.

so, I agreed with you, the name of the project should not matter, but for some reason.. it does. Why.. I have no clue.

I do not know if that is a bug, I was able to workaround it.

Thanks.
Norman