FieldValueMap seems to be ignored by validation

[dnyhbavarian]

Hi, thank you for a very comprehensive product

I am trying to migrate several azure devops cloud projects into one, but so far i can't get past validation of the first project.
The projects are using different processes so i have to map all fields and many values to the target process.

When executing the migration i get this error:

[14:03:56 INF] [16.3.2]     Missing values are: 'Active', 'Resolved'
[14:03:56 WRN] [16.3.2]     Source field 'System.State' and target field 'System.State' have different allowed values.
[14:03:56 INF] [16.3.2]       Source allowed values: 'Active', 'Closed', 'New', 'Resolved'
[14:03:56 INF] [16.3.2]       Target allowed values: 'Closed', 'In Progress', 'New'
[14:03:56 INF] [16.3.2]       Missing values in target are: 'Active', 'Resolved' 

....

[14:03:56 ERR] [16.3.2] Some work item types or their fields are not valid in the target system (see previous logs).
[14:03:56 ERR] [16.3.2] Validation of work item types failed.

I have tried to disable validation entirely and for the specific work items and currently to map the system.state for Bug and Tasks, but neither makes any difference.

How can i get the validation to respect the mappings, so it does not fail?
or is there a better way to do this type of migration?

Full config for reference:

{
  "$schema": "https://devopsmigration.io/schema/configuration.schema.json",
  "Serilog": {
    "MinimumLevel": "Warning"
  },
  "MigrationTools": {
    "Version": "16.3",
    "Endpoints": {
      "IT Projects": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://dev.azure.com/***/",
        "Project": "IT Projects",
        "Authentication": {
          "AuthenticationMode": "AccessToken",
          "AccessToken": "***"
        },
        "ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        },
        "ProductVersion": "Cloud"
      },
      "TEST Global IT": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "https://dev.azure.com/***/",
        "Project": "TEST Global IT",
        "ReflectedWorkItemId": "Custom.ReflectedWorkItemId",
        "Authentication": {
          "AuthenticationMode": "AccessToken",
          "AccessToken": "***"
        },
        "ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        },
        "ProductVersion": "Cloud"
      }
    },
    "Processors": [
      {
        "ProcessorType": "TfsWorkItemMigrationProcessor",
        "Enabled": 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 limit 1",
        "FixHtmlAttachmentLinks": true,
        "WorkItemCreateRetryLimit": 5,
        "FilterWorkItemsThatAlreadyExistInTarget": true,
        "GenerateMigrationComment": true,
        "ReplayRevisions": true,
        "AttachmentMigration": true,
        "LinkMigration": true,
        "SourceName": "IT Projects",
        "TargetName": "TEST Global IT"
      }
    ],
    "CommonTools": {
      "IncludeWorkItemTypes": [
        "Epic",
        "Feature",
        "User Story",
        "Task", 
        "Bug"
      ],
      "FieldMappingTool": {
        "Enabled": true,
        "FieldMaps": [
          { "FieldMapType": "FieldValueMap", "sourceName": "IT Project Portfolio", "targetField": "System.State", "FieldValuePairs": [
            { "sourceValue": "New", "targetValue": "New" }, 
            { "sourceValue": "Active", "targetValue": "In Progress" }, 
            { "sourceValue": "Test", "targetValue": "In Progress" },
            { "sourceValue": "Closed", "targetValue": "Closed" },
            { "sourceValue": "Resolved", "targetValue": "Closed" }
          ], "ApplyTo": [ "Task", "Bug" ] },
          { "FieldMapType": "FieldValueMap", "sourceName": "IT Project Portfolio", "targetField": "System.WorkItemType", "FieldValuePairs": [ { "sourceValue": "Epic", "targetValue": "Project" } ], "ApplyTo": [ "Epic,Project" ] }
        ]
      },

      "WorkItemTypeValidatorTool": {
        "Enabled": true,
        "ExcludeDefaultWorkItemTypes": true
        }
      }
    }
  }

Thank you very much in advance.

[MrHinsh]

I take it that config is AI-generated? I guess this as its a complete mess and does not conform to the documenation.

Please see https://devopsmigration.io/docs/get-started/getting-started/

[dnyrop]

Thank you for getting back to be @MrHinsh, I see that the auto complete feature in vscode is a little too creative :)

I've been trying to get thte json schema to validate my config file to catch any errors in the editor, but since most the properties are optional and "additionalProperties" is not set to false everything passes validation.
Do you have a recommendded way to use the json schema for in editor validation?

[MrHinsh]

No, don't use it in editor validation.

Use the docs.