Update Certain Field in Target with Values from Source

[Musket519]

I have already completed a migration of my project but I wish to update some field values in the target with values from the source. To clarify, one of my work item types has a decimal field that was not updated in the target during the migration, so they are all blank. So can I iterate through all the work items of the source and just move over that specific field in the target without having to do everything else?

[MrHinsh]

Yes you can, but you need to use a different processor that only overwrites values.

https://nkdagility.com/learn/azure-devops-migration-tools/Reference/v1/Processors/WorkItemPostProcessingContext/

[Musket519]

So I am attempting to run this config:

{
      "$type": "WorkItemPostProcessingConfig",
      "Enabled": true,
      "WorkItemIDs": null,
      "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] IN ('Product Backlog Item') AND [Microsoft.VSTS.Common.ClosedDate] = '' AND [System.State] NOT IN ('Closed', 'Removed', 'Done') ORDER BY [System.ChangedDate] desc",
      "FilterWorkItemsThatAlreadyExistInTarget": false,
      "PauseAfterEachWorkItem": false,
      "WorkItemCreateRetryLimit": 0
}

With this field map:

{
      "$type": "FieldtoFieldMapConfig",
      "WorkItemTypeName": "*",
      "sourceField": "EXAMPLE.EXAMPLE.WorkItemPriority",
      "targetField": "Custom.WorkItemPriority",
      "defaultValue": "0"
}

When I run this it will find around 800 or so work items and load them then it will run a whole load of work item queries (I assume querying the loaded work items) then it just ends and nothing seems to happen, it also only seems to be querying from the target and never the source, also none of the values change. I am assuming theres an error somewhere but I am unsure how to see any error codes as the console just ends.

If it makes any difference the source is a collection that was migrated from an On-Prem XML Process Model Collection but it shouldnt affect the refname should it?

[MrHinsh]

The first query for the 800 items are from the Source, and then it will never re-qurey the source.

It should then iterate through each of the 800 items and try to find them in the target. If you have "Debug" enabled then it should list the Query that is run... can you post an example of the query? You should see the ReflectedWorkItemID in the query run.

[Musket519]

2024-03-12 18:09:34.783 -05:00 [DBG] WorkItemQuery: ===========GetWorkItems=============
2024-03-12 18:09:34.783 -05:00 [DBG] WorkItemQuery: TeamProjectCollection: https://dev.azure.com/collection
2024-03-12 18:09:34.783 -05:00 [DBG] WorkItemQuery: Query: SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject]='project' AND [Custom.ReflectedWorkItemId] = 'https://dev.azure.com/collection/project/_workitems/edit/110045'
2024-03-12 18:09:34.786 -05:00 [DBG] WorkItemQuery: Parameters: {"TeamProject":"project","idToFind":"https://dev.azure.com/collection/project/_workitems/edit/110045"}
2024-03-12 18:09:34.786 -05:00 [DBG] WorkItemQuery: TeamProject: project
2024-03-12 18:09:34.786 -05:00 [DBG] WorkItemQuery: idToFind: https://dev.azure.com/collection/project/_workitems/edit/110045
2024-03-12 18:09:34.786 -05:00 [DBG] Query sent

This is one of the queries I pulled from the logs, the target collection and project are correct and link after the ReflectWorkItemID is valid and goes to a work item, but the WorkItemPriorityField never updates, it just stays empty

[Musket519]

Im going to add my full config in case it helps. I made a second discussion as to not overload this one but I am also having an issue where the program is crashing at the TestPlanAndSuite migration process. Im assuming something is wrong with my config but I dont know what.

{
  "ChangeSetMappingFile": null,
  "Source": {
    "$type": "TfsTeamProjectConfig",
    "Collection": "https://dev.azure.com/Source/",
    "Project": "sourceProject",
    "ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
    "AllowCrossProjectLinking": false,
    "AuthenticationMode": "AccessToken",
    "PersonalAccessToken": "token",
    "PersonalAccessTokenVariableName": "",
    "LanguageMaps": {
      "AreaPath": "Area",
      "IterationPath": "Iteration"
    },
    "CollectionName": "https://dev.azure.com/Source/"
  },
  "Target": {
    "$type": "TfsTeamProjectConfig",
    "Collection": "https://dev.azure.com/Target/",
    "Project": "targetProject",
    "ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
    "AllowCrossProjectLinking": false,
    "AuthenticationMode": "AccessToken",
    "PersonalAccessToken": "token",
    "PersonalAccessTokenVariableName": "",
    "LanguageMaps": {
      "AreaPath": "Area",
      "IterationPath": "Iteration"
    },
    "CollectionName": "https://dev.azure.com/target/"
  },
  "FieldMaps": [

    {
      "$type": "FieldtoFieldMapConfig",
      "WorkItemTypeName": "*",
      "sourceField": "EXAMPLE.EXAMPLE.WorkItemPriority",
      "targetField": "Custom.WorkItemPriority",
      "defaultValue": "0"
    }

  ],
  "GitRepoMapping": null,
  "LogLevel": "Debug",
  "CommonEnrichersConfig": [],
  "Processors": [

    {
      "$type": "WorkItemPostProcessingConfig",
      "Enabled": true,
      "WorkItemIDs": null,
      "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] IN ('Product Backlog Item') AND [Microsoft.VSTS.Common.ClosedDate] = '' AND [System.State] NOT IN ('Closed', 'Removed', 'Done') ORDER BY [System.ChangedDate] desc",
      "FilterWorkItemsThatAlreadyExistInTarget": false,
      "PauseAfterEachWorkItem": false,
      "WorkItemCreateRetryLimit": 0
    },

    {
      "$type": "WorkItemQueryMigrationConfig",
      "Enabled": true,
      "PrefixProjectToNodes": false,
      "SharedFolderName": "Shared Queries",
      "SourceToTargetFieldMappings": null
    },

    {
      "$type": "TestVariablesMigrationConfig",
      "Enabled": true
    },

    {
      "$type": "TestConfigurationsMigrationConfig",
      "Enabled": true
    },

    {
      "$type": "TestPlansAndSuitesMigrationConfig",
      "Enabled": true,
      "PrefixProjectToNodes": false,
      "OnlyElementsWithTag": null,
      "TestPlanQueryBit": null,
      "RemoveAllLinks": false,
      "MigrationDelay": 0,
      "UseCommonNodeStructureEnricherConfig": false,
      "NodeBasePaths": null,
      "AreaMaps": null,
      "IterationMaps": null,
      "RemoveInvalidTestSuiteLinks": false,
      "FilterCompleted": true
    },

    {
      "$type": "WorkItemMigrationConfig",
      "Enabled": false,
      "UpdateCreatedDate": true,
      "UpdateCreatedBy": true,
      "WIQLQuery": "SELECT [System.Id] 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",
      "AttachmentMigration": true,
      "AttachmentWorkingPath": "c:\\temp\\WorkItemAttachmentWorkingFolder\\",
      "FixHtmlAttachmentLinks": false,
      "SkipToFinalRevisedWorkItemType": false,
      "WorkItemCreateRetryLimit": 5,
      "FilterWorkItemsThatAlreadyExistInTarget": false,
      "PauseAfterEachWorkItem": false,
      "AttachmentMaxSize": 480000000,
      "AttachRevisionHistory": false,
      "LinkMigrationSaveEachAsAdded": false,
      "GenerateMigrationComment": true,
      "WorkItemIDs": null,
      "MaxGracefulFailures": 0,
      "SkipRevisionWithInvalidIterationPath": false,
      "SkipRevisionWithInvalidAreaPath": false
    }

  ],
  "Version": "15.0",
  "workaroundForQuerySOAPBugEnabled": false,
  "WorkItemTypeDefinition": {
    "sourceWorkItemTypeName": "targetWorkItemTypeName"
  },
  "Endpoints": {
    "InMemoryWorkItemEndpoints": [
      {
        "Name": "Source",
        "EndpointEnrichers": null
      },
      {
        "Name": "Target",
        "EndpointEnrichers": null
      }
    ]
  }
}