nkdAgility/azure-devops-migration-tools

Error saving query 'Transition Planning', probably due to invalid area or iteration paths Microsoft.TeamFoundation.WorkItemTracking.Client.InvalidQueryTextException: TF51005: The query references a field that does not exist. The error is caused by «[Custom.ApplicationID]». ---> Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.SyntaxException: TF51005: The query references a field that does not exist. The error is caused by «[Custom.ApplicationID]».

Closed this issue · 0 comments

Version

  • I confirm that I am using the latest version

Source Version

Azure DevOps Server 2022

Target Version

Azure DevOps Server 2022

Relevant configuration

{
  "ChangeSetMappingFile": null,
  "Source": {
    "$type": "TfsTeamProjectConfig",
    "Collection": "https://dev.azure.com/ORG1/",
    "Project": "PROJ1",
    "ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
    "AllowCrossProjectLinking": false,
    "AuthenticationMode": "Prompt",
    "PersonalAccessToken": "XXX",
    "PersonalAccessTokenVariableName": ""
   
  },
  "Target": {
    "$type": "TfsTeamProjectConfig",
    "Collection": "https://dev.azure.com/ORG1/",
    "Project": "PROJ1",
    "ReflectedWorkItemIDFieldName": "ReflectedWorkItemId",
    "AllowCrossProjectLinking": false,
    "AuthenticationMode": "Prompt",
    "PersonalAccessToken": "XXXX",
    "PersonalAccessTokenVariableName": ""
   
  },
  "Processors": [
     {
      "$type": "TfsSharedQueryProcessorOptions",
      "Enabled": true,
      "PrefixProjectToNodes": false,
      "SharedFolderName": "Shared Queries",
      "SourceToTargetFieldMappings": null,
      "ProcessorEnrichers": null,
      "SourceName": "Source",
      "TargetName": "Target"
    }
  ],
  "Version": "12.8",
    "Endpoints": {
      "TfsEndpoints": [
        {
          "name": "Source",
          "$type": "TfsEndpointOptions",
          "Organisation": "https://dev.azure.com/ORG1/",
          "Project": "PROJ1",
          "AuthenticationMode": "AccessToken",
          "AccessToken": "XXX",
          "EndpointEnrichers": null
        },
        {
          "Name": "Target",
          "$type": "TfsEndpointOptions",
          "Organisation": "https://dev.azure.com/ORG1/",
          "Project": "PROJ1",
          "AuthenticationMode": "AccessToken",
          "AccessToken": "XXX",
          "EndpointEnrichers": null
      }
    ]
  }
}

Relevant log output

Error saving query 'Transition Planning', probably due to invalid area or iteration paths
Microsoft.TeamFoundation.WorkItemTracking.Client.InvalidQueryTextException: TF51005: The query references a field that does not exist. The error is caused by «[Custom.ApplicationID]». ---> Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.SyntaxException: TF51005: The query references a field that does not exist. The error is caused by «[Custom.ApplicationID]».

What happened?

When we try to migrate the shared queries from source DevOps organization to Target DevOps organization we are facing the issue: Error saving query 'Transition Planning', probably due to invalid area or iteration paths
Microsoft.TeamFoundation.WorkItemTracking.Client.InvalidQueryTextException: TF51005: The query references a field that does not exist. The error is caused by «[Custom.ApplicationID]». ---> Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.SyntaxException: TF51005: The query references a field that does not exist. The error is caused by «[Custom.ApplicationID]».
We are using the nkdagility tool. We are using Agile process in both source and destination.

Debug in Visual Studio

  • Visual Studio Debug