Error in Querying items to be migrated

[elarief92]

I'm using this 'migration-config.json' file and uses
.\devopsmigration.exe execute --config migration-config.json

{
  "$schema": "https://devopsmigration.io/schema/configuration.schema.son",
  "Serilog": { "MinimumLevel": "Information" },
  "MigrationTools": {
    "Version": "16.3",
    "Endpoints": {
      "Source": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "http://tfs:5678/XMLCollection",
        "Project": "xml-ccmi-old",
        "Authentication": { "AuthenticationMode": "Prompt" },
        "ReflectedWorkItemIdField": "System.Id"
      },
      "Target": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "http://tfs:5678/DefaultCollection",
        "Project": "xml02-cmmi-migrated",
        "Authentication": { "AuthenticationMode": "Prompt" },
        "ReflectedWorkItemIdField": "System.Id"
      }
    },
    "Processors": [
      {
        "ProcessorType": "TfsWorkItemMigrationProcessor",
        "Enabled": true,
        "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] <> '' ",
        "SourceName": "Source",
        "TargetName": "Target",
        "ResultFileName": "workitem-migration-results.json",
        "FilterWorkItemsThatAlreadyExistInTarget": false,
        "UpdateCreatedDate": true,
        "UpdateCreatedBy": true,
        "FixHtmlAttachmentLinks": true,
        "NodeBasePaths": [
          {
            "Enabled": false,
            "ObjectType": "TfsWorkItemTypeValidatorTool"
          }
        ]
      }
    ]
  }
}

but I faces an issue \

[16:01:55 INF] [16.3.1] Migrating all Teams before the Processor run.
[16:01:55 INF] [16.3.1] TfsTeamSettingsProcessor::InternalExecute: Found 1 teams in Source?
[16:01:55 INF] [16.3.1] -> Settings found for team 'xml-ccmi-old Team'..
[16:01:55 INF] [16.3.1] Migrating team capacities..
[16:01:55 INF] [16.3.1] Team capacities migration done..
[16:01:55 INF] [16.3.1] Querying items to be migrated: SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] <> ''  ...
[16:01:55 INF] [16.3.1] 1 Work items received, verifying
[16:01:56 INF] [16.3.1] Loading 1 Work Items
[16:01:57 INF] [16.3.1] Replay all revisions of 1 work items?
[16:01:57 INF] [16.3.1] Validating::Check that all Area & Iteration paths from Source have a valid mapping on Target
[16:01:57 INF] [16.3.1] Validating::Check that all users in the source exist in the target or are mapped!
[16:01:57 WRN] [16.3.1] TfsUserMappingTool is disabled in settings. You may have users in the source that are not mapped to the target.
[16:01:57 INF] [16.3.1] Found target project as xml02-cmmi-migrated
[16:01:57 ERR] [16.3.1]  Error running query
Microsoft.TeamFoundation.WorkItemTracking.Client.ValidationException: TF212023: You cannot compare fields with different data types in the WHERE clause of a work item query. The error is caused by «[System.Id] = 'http://tfs:5678/XMLCollection/xml-ccmi-old/_workitems/edit/24'».
   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.Clients.TfsWorkItemQuery.GetWorkItemsFromQuery(TfsWorkItemMigrationClient wiClient) in D:\a\azure-devops-migration-tools\azure-devops-migration-tools\src\MigrationTools.Clients.TfsObjectModel\Clients\TfsWorkItemQuery.cs:line 71

currently, I'm using version"azure-devops-migration-tools-16.3.1"
what is the issue here as I already tried many times?

[MrHinsh]

You generated the config with AI, which did an abysmal job. Can you run that config through the upgrade command to filter out the hallucinations?

Also... if your TFS name is http://tfs:5678/XMLCollection, then we may have an edge case around detecting the URL... was not aware we worked with non https

[elarief92]

so what is the default json file that can be used as a template for this migration and also what are steps to follow?

I searched a lot but didn't get any results.

Thanks

[MrHinsh]

https://devopsmigration.io

[elarief92]

Hi Mr. Hinsh

Now, It's working fine with me only for one Work Item "Requirements" (As I already created the new field for this Work Item). But I create a Task, I get the following error\

[14:19:44 WRN] [v14.2.0] ValidatingRequiredField: Task does not contain Custom.ReflectedWorkItemId
[14:19:44 ERR] [v14.2.0] 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!
[14:19:44 INF] [v14.2.0] DONE in 00:00:03.4887321
[14:19:44 FTL] [v14.2.0] Error while running WorkItemMigration

So what to do next to solve this issue as I'm not able to create a new field on Task Work Item with the same name 'ReflectedWorkItemId'.