Closed Date is the date of migration rather than original closed date

[rpalbrecht]

When Migrating Closed Work Items the closed date is changing to the date of migration when we need the original closed date. Out of 219 user stories that were closed in 2021 only 11 of them keep the original closed date. Tried adding closed date to the PopulateIgnoreList in the code and that did not work. The log output is of one User Story that did not keep the closed date as original.

In researching different options I have tried all of them but nothing has worked I amusing the latest of the migration tool.
Any Suggestions?

the json used for the migration
{
"ChangeSetMappingFile": null,
"Source": {
"$type": "TfsTeamProjectConfig",
"Collection": "",
"Project": "TotalView",
"ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
"AllowCrossProjectLinking": true,
"AuthenticationMode": "Prompt",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "",
"LanguageMaps": {
"$type": "TfsLanguageMapOptions",
"AreaPath": "Area",
"IterationPath": "Iteration"
}
},
"Target": {
"$type": "TfsTeamProjectConfig",
"Collection": "",
"Project": "TotalView",
"ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
"AllowCrossProjectLinking": true,
"AuthenticationMode": "AccessToken",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "",
"LanguageMaps": {
"$type": "TfsLanguageMapOptions",
"AreaPath": "Area",
"IterationPath": "Iteration"
}
},
"FieldMaps": [
{
"$type": "FieldtoFieldMapConfig",
"WorkItemTypeName": "",
"sourceField": "Custom.Activity",
"targetField": "Custom.MerchantsActivity",
"defaultValue": null
},
{
"$type": "FieldValueMapConfig",
"WorkItemTypeName": "Bug",
"sourceField": "System.State",
"targetField": "System.State",
"defaultValue": "New",
"valueMapping": {
"Active": "Dev",
"Refinement": "Refinement",
"New": "New",
"QA": "QA",
"Resolved": "UAT",
"Closed": "Closed"
}
},
{
"$type": "FieldValueMapConfig",
"WorkItemTypeName": "User Story",
"sourceField": "System.State",
"targetField": "System.State",
"defaultValue": "New",
"valueMapping": {
"Active": "Dev",
"Refinement": "Refinement",
"New": "New",
"QA": "QA",
"Resolved": "UAT",
"Removed": "Removed",
"Closed": "Closed"
}
},
{
"$type": "FieldValueMapConfig",
"WorkItemTypeName": "Epic",
"sourceField": "System.State",
"targetField": "System.State",
"defaultValue": "New",
"valueMapping": {
"Active": "Active",
"New": "New",
"QA": "QA",
"UAT": "Resolved",
"Closed": "Closed"
}
},
{
"$type": "FieldValueMapConfig",
"WorkItemTypeName": "Feature",
"sourceField": "System.State",
"targetField": "System.State",
"defaultValue": "New",
"valueMapping": {
"Active": "Active",
"New": "New",
"QA": "QA",
"UAT": "Resolved",
"Closed": "Closed"
}
}
],
"GitRepoMapping": null,
"LogLevel": "Verbose",
"CommonEnrichersConfig": null,
"Processors": [
{
"$type": "WorkItemMigrationConfig",
"Enabled": true,
"ReplayRevisions": true,
"PrefixProjectToNodes": false,
"UpdateCreatedDate": true,
"UpdateCreatedBy": true,
"WIQLQueryBit": "AND [Microsoft.VSTS.Common.ClosedDate] >= '01-01-2021' AND [Microsoft.VSTS.Common.ClosedDate] < '01-01-2022' AND [System.State] IN ('Closed') AND [System.WorkItemType] IN ('User Story')",
"WIQLOrderBit": "[System.ChangedDate] desc",
"LinkMigration": true,
"AttachmentMigration": true,
"AttachmentWorkingPath": "d:\temp\WorkItemAttachmentWorkingFolder\",
"FixHtmlAttachmentLinks": true,
"SkipToFinalRevisedWorkItemType": false,
"WorkItemCreateRetryLimit": 5,
"FilterWorkItemsThatAlreadyExistInTarget": true,
"PauseAfterEachWorkItem": false,
"AttachmentMaxSize": 480000000,
"AttachRevisionHistory": true,
"LinkMigrationSaveEachAsAdded": true,
"GenerateMigrationComment": true,
"WorkItemIDs": null,
"MaxRevisions": 0,
"UseCommonNodeStructureEnricherConfig": false,
"StopMigrationOnMissingAreaIterationNodes": false,
"NodeBasePaths": [],
"AreaMaps": {
"StrategicPod\\(.)$": "TotalView\TotalView",
"BusinessSystems\\(.)$": "TotalView\TotalView",
"FuelProcessApi\\(.)$": "TotalView\TotalView",
"EnterpriseDatabases\\(.)$": "TotalView\TotalView",
"OrderManagement\\(.)$": "TotalView\TotalView",
"ConnectedVehicle\\(.)$": "TotalView\TotalView",
"ServiceMaster\\(.)$": "TotalView\TotalView",
"Quote2Cap\\(.)$": "TotalView\TotalView",
"DevOps\\(.)$": "TotalView\TotalView",
"Auto_Integrate\\(.)$": "TotalView\TotalView",
"Da_Vinci_UI-UX_Redesign\\(.)$": "TotalView\TotalView",
"TotalView_Tech_Debt_Remediation\\(.)$": "TotalView\TotalView",
"StrategicPod$": "TotalView\TotalView",
"BusinessSystems$": "TotalView\TotalView",
"FuelProcessApi$": "TotalView\TotalView",
"EnterpriseDatabases$": "TotalView\TotalView",
"OrderManagement$": "TotalView\TotalView",
"ConnectedVehicle$": "TotalView\TotalView",
"ServiceMaster$": "TotalView\TotalView",
"Auto_Integrate$": "TotalView\TotalView",
"Quote2Cap$": "TotalView\TotalView",
"DevOps$": "TotalView\TotalView",
"Da_Vinci_UI-UX_Redesign$": "TotalView\TotalView",
"TotalView_Tech_Debt_Remediation$": "TotalView\TotalView"
},
"IterationMaps": {
"StrategicPod\\(.)$": "TotalView\TotalView",
"BusinessSystems\\(.)$": "TotalView\TotalView",
"FuelProcessApi\\(.)$": "TotalView\TotalView",
"EnterpriseDatabases\\(.)$": "TotalView\TotalView",
"OrderManagement\\(.)$": "TotalView\TotalView",
"ConnectedVehicle\\(.)$": "TotalView\TotalView",
"ServiceMaster\\(.)$": "TotalView\TotalView",
"Quote2Cap\\(.)$": "TotalView\TotalView",
"DevOps\\(.)$": "TotalView\TotalView",
"Auto_Integrate\\(.)$": "TotalView\TotalView",
"Da_Vinci_UI-UX_Redesign\\(.)$": "TotalView\TotalView",
"TotalView_Tech_Debt_Remediation\\(.*)$": "TotalView\TotalView",
"StrategicPod$": "TotalView\TotalView",
"BusinessSystems$": "TotalView\TotalView",
"FuelProcessApi$": "TotalView\TotalView",
"EnterpriseDatabases$": "TotalView\TotalView",
"OrderManagement$": "TotalView\TotalView",
"ConnectedVehicle$": "TotalView\TotalView",
"ServiceMaster$": "TotalView\TotalView",
"Auto_Integrate$": "TotalView\TotalView",
"Quote2Cap$": "TotalView\TotalView",
"DevOps$": "TotalView\TotalView",
"Da_Vinci_UI-UX_Redesign$": "TotalView\TotalView",
"TotalView_Tech_Debt_Remediation$": "TotalView\TotalView"
},
"MaxGracefulFailures": 0,
"ShouldCreateMissingRevisionPaths": false,
"SkipRevisionWithInvalidIterationPath": true,
"SkipRevisionWithInvalidAreaPath": true
},
{
"$type": "ImportProfilePictureConfig",
"Enabled": false
},
{
"$type": "ExportProfilePictureFromADConfig",
"Enabled": false,
"Domain": null,
"Username": null,
"Password": null,
"PictureEmpIDFormat": null
},
{
"$type": "FixGitCommitLinksConfig",
"Enabled": false,
"TargetRepository": "targetProjectName",
"QueryBit": null,
"OrderBit": null
}
],
"Version": "0.0",
"workaroundForQuerySOAPBugEnabled": false,
"WorkItemTypeDefinition": {
"sourceWorkItemTypeName": "targetWorkItemTypeName"
},
"Endpoints": {
"InMemoryWorkItemEndpoints": [
{
"Name": "InMemSource",
"EndpointEnrichers": null
},
{
"Name": "InMemTarget",
"EndpointEnrichers": null
}
],
"TfsEndpoints": [
{
"Name": "MySource",
"Organisation": "",
"Project": "TotalView",
"AuthenticationMode": "Prompt",
"ReflectedWorkItemIdField": "Common.ReflectedWorkItemId",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "Custom.ReflectedWorkItemId",
"LanguageMaps": {
"$type": "TfsLanguageMapOptions",
"AreaPath": "Area",
"IterationPath": "Iteration"
}
},
{
"Name": "MyTarget",
"Direction": "Target",
"Organisation": "",
"Project": "TotalView",
"AuthenticationMode": "AccessToken",
"ReflectedWorkItemIdField": "Common.ReflectedWorkItemId",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "",
"LanguageMaps": {
"$type": "TfsLanguageMapOptions",
"AreaPath": "Area",
"IterationPath": "Iteration"
}
}
],
"TfsTeamSettingsEndpoints": [
{
"$type": "TfsTeamSettingsEndpointOptions",
"Name": "TeamSettingsSource",
"Direction": "Source",
"Organisation": "",
"Project": "TotalView",
"AuthenticationMode": "Prompt",
"ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "",
"LanguageMaps": {
"$type": "TfsLanguageMapOptions",
"AreaPath": "Area",
"IterationPath": "Iteration"
},
"EndpointEnrichers": null
},
{
"$type": "TfsTeamSettingsEndpointOptions",
"Name": "TeamSettingsTarget",
"Direction": "Target",
"Organisation": "",
"Project": "TotalView",
"AuthenticationMode": "AccessToken",
"ReflectedWorkItemIdField": "Common.ReflectedWorkItemId",
"PersonalAccessToken": "",
"PersonalAccessTokenVariableName": "",
"LanguageMaps": {
"$type": "TfsLanguageMapOptions",
"AreaPath": "Area",
"IterationPath": "Iteration"
},
"EndpointEnrichers": null
}
]
}
}

[MrHinsh]

I recommend that you run in debug for just that work item in Visual Studio debugger and see where the value is changed?