Unable to migrate Test plan and Test Suite

[sonal1625]

Scenario 1: While Migrating the test plans and test suite, we are receiving below error, Wanted to confirm if the below query is correct?

"TestPlanQuery": "PlanName = 'testplan name'"

Log file attached.

Error log:

[19:45:17 INF] [16.1.0] TestPlansAndSuitesMigrationContext:  DONE in 00:00:17.1844933
[19:45:17 DBG] [16.1.0] Query sent
[19:45:17 INF] [16.1.0] == Plan[1/1] Suite[0/0] Cases[0/0]  - suiteid[10735 ] | Test Suite <<Invalid>> from source cannot be found in target. Has it been migrated?

below is the Config file:

{
  "Serilog": {
    "MinimumLevel": "Debug"
  },
  "MigrationTools": {
    "Version": "16.0",
    "Endpoints": {
      "Source": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "",
        "Project": "",
        
        "ReflectedWorkItemIdField": "ReflectedWorkItemId",
        "AllowCrossProjectLinking": false,
        "Authentication": {
            "AccessToken": "",
            "AuthenticationMode": "AccessToken"
            
          },
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        },
        "EndpointEnrichers": null
      },
      "Target": {
        "EndpointType": "TfsTeamProjectEndpoint",
        "Collection": "",
        "Project": "",
        
        "ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
        "AllowCrossProjectLinking": false,
        "Authentication": {
            "AccessToken": "",
            "AuthenticationMode": "AccessToken"
          },
        "LanguageMaps": {
          "AreaPath": "Area",
          "IterationPath": "Iteration"
        },
        "EndpointEnrichers": null
      }
    },
    "Processors": [
      {
       "ProcessorType": "TfsWorkItemMigrationProcessor",
        "Enabled": false,
        "UpdateCreatedDate": true,
        "UpdateCreatedBy": false, 
        "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] = 'Test Suite' AND [System.Id] IN (10737) ORDER BY [System.Id]",
        "GenerateMigrationComment": true,
        "FixHtmlAttachmentLinks": true,
        "WorkItemCreateRetryLimit": 5,
        "FilterWorkItemsThatAlreadyExistInTarget": false,
        "PauseAfterEachWorkItem": false,
        "AttachRevisionHistory": false,
        "WorkItemIDs": null,
        "MaxGracefulFailures": 0,
        "SkipRevisionWithInvalidIterationPath": false,
        "SkipRevisionWithInvalidAreaPath": false,
        "Enrichers": null,
        "SourceName": "Source",
        "TargetName": "Target",
        "RefName": null
      },
      {
        "ProcessorType": "TfsTestVariablesMigrationProcessor",
        "Enabled": true,
        "Processor": "TestVariablesMigrationContext",
        "SourceName": "Source",
        "TargetName": "Target"
      },
      {
        "ProcessorType": "TfsTestConfigurationsMigrationProcessor",
        "Enabled": true,
        "SourceName": "Source",
        "TargetName": "Target"
      },
      {
        "ProcessorType": "TfsTestPlansAndSuitesMigrationProcessor",
        "Enabled": true,
        "OnlyElementsWithTag": "",
        **"TestPlanQuery": "PlanName = 'testplan'",**
        "RemoveAllLinks": false,
        "MigrationDelay": 0,
        "RemoveInvalidTestSuiteLinks": true,
        "FilterCompleted": false,
        "SourceName": "Source",
        "TargetName": "Target",
        "RefName": null
      },
      {
        "ProcessorType": "AzureDevOpsPipelineProcessor",
        "Enabled": false,
        "MigrateBuildPipelines": true,
        "MigrateReleasePipelines": true,
        "MigrateTaskGroups": true,
        "MigrateVariableGroups": true,
        "MigrateServiceConnections": true,
        "BuildPipelines": null,
        "ReleasePipelines": null,
        "RepositoryNameMaps": null,
        "Enrichers": null,
        "SourceName": "Source",
        "TargetName": "Target",
        "RefName": ""
      },
      {
        "ProcessorType": "TfsSharedQueryProcessor",
        "Enabled": false,
        "PrefixProjectToNodes": false,
        "SharedFolderName": "Shared Queries",
        "SourceToTargetFieldMappings": null,
        "Enrichers": null,
        "SourceName": "MySource",
        "TargetName": "MyTarget",
        "RefName": null
      }
    ],
    "CommonTools": {
      "TfsChangeSetMappingTool": {
        "Enabled": true,
        "ChangeSetMappingFile": ""
      },
      "TfsGitRepositoryTool": {
        "Enabled": true,
        "Mappings": null
      },
      "FieldMappingTool": {
        "Enabled": true,
        "FieldMaps": [
        ]
      },
      "WorkItemTypeMappingTool": {
        "Enabled": false,
        "Mappings": {
        }
      },
      "StringManipulatorTool": {
        "Enabled": true,
        "MaxStringLength": 1000000,
        "Manipulators": [
          {
            "Enabled": true,
            "Pattern": "[^( -~)\n\r\t]+",
            "Replacement": "",
            "Description": "Remove invalid characters from the end of the string"
          }
        ]
      },
      "TfsNodeStructureTool": {
        "Enabled": true,
        "Areas": {
          "Filters": [],
          "Mappings": {}
        },
        "Iterations": {
          "Filters": [],
          "Mappings": {}
        },
        "ShouldCreateMissingRevisionPaths": true,
        "ReplicateAllExistingNodes": true
      }
    }
  }
}

=========================================================================================
Scenario 2: Also, if we set "TestPlanQuery" to null, we are receiving below error

Error log:

[20:19:02 DBG] [16.1.0] TfsWorkItemMigrationClient::GetWorkItem(2119)
[20:19:02 INF] [16.1.0] == Plan[ 2/42] Suite[1/1] Cases[0/0]  - suiteid[2119  ] |     Processing StaticTestSuite : 2119 - 31 : Enable validation rules to automatically limit timezone value(s) to the event geography
[20:19:02 DBG] [16.1.0] TestPlansAndSuitesMigrationContext::FindSuiteEntry
[20:19:03 FTL] [16.1.0] Error while running TfsTestPlansAndSuitesMigrationProcessor 
Microsoft.TeamFoundation.TeamFoundationServerUnauthorizedException: TF30063: You are not authorized to access https://oooo.visualstudio.com/. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.

Config file:

   {
        "ProcessorType": "TfsTestPlansAndSuitesMigrationProcessor",
        "Enabled": true,
        "OnlyElementsWithTag": "",
        **"TestPlanQuery": null,**
        "RemoveAllLinks": false,
        "MigrationDelay": 0,
        "RemoveInvalidTestSuiteLinks": true,
        "FilterCompleted": false,
        "SourceName": "Source",
        "TargetName": "Target",
        "RefName": null
      },

Note: As checked the permission, i have Early Adopter Access level. PAT token is generated today and has full access.

[MrHinsh]

Seanrio 1

Odd, you will need to run your config in visual studio debug to see what the issue is here.

Senario 2

TF30063: You are not authorized to access https://onegdc.visualstudio.com/. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.

You don't have the appropriate permissions or the Project that you are trying to connect to does not exist.

[sonal1625]

I do have access on the source and target org. We migrated test cases and other work items. there was no issue while migrating. However, when we tried migrating Test plans and test suite we received this 401 error.

What are the permission required for migrating Test plans and Test Suite?

[MrHinsh]

You need a Test licence.

[sonal1625]

Okayy , Can you please help me with the Test license name ?

[nkdagility-actions-bot[bot]]

Hi there,
ACTION REQUIRED

This looks to be a complex issue that you will need to debug locally to figure out what is going on.

Debug in Visual Studio

Steps:

1. Fork this repository
2. Open this project in Visual Studio
3. Edit the Launch Profile to point to your config.
   
4. Craft a WIQL query to only load the work item with the issue.
5. Then set some break points and debug the issue.
6. Comment here with the results.

Your assistance is greatly appreciated!

Thanks, Azure DevOps Migration Tools team