The add or subtract operators can only be used with dates or numerical constants. The error is caused by «@currentIteration + 1

[Lakshminarayana316]

Hi,

How to add @currentiteration + 1 or @currentiteration -1 or any itteration with different value .

i want to migrate the shared quires,it contains above iteration starts with @currentiteration + 1 and so on .However when i am doing migration it is getting failed due to below error .
Error :
probably due to invalid area or iteration paths
2024-11-27T15:39:55.0626196Z Microsoft.TeamFoundation.WorkItemTracking.Client.InvalidQueryTextException: TF51015: The add or subtract operators can only be used with dates or numerical constants. The error is caused by «@currentiteration + 1». ---> Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.SyntaxException: TF51015: The add or subtract operators can only be used with dates or numerical constants. The error is caused by «@currentiteration + 1».

configuration file:

"Processors": [
{
"ProcessorType": "TfsSharedQueryProcessor",
"Enabled": true,
"PrefixProjectToNodes": false,
"SharedFolderName": "Shared Queries",
"SourceToTargetFieldMappings": null,
"SourceName": "Source",
"TargetName": "Target",
}
]
}

Where i can add @currentiteration + 1 itteration path to my configuration file?

[MrHinsh]

That looks like it may be a bug!

1. What versions are your Source and Target...
2. Provide a full log file attached to your issue

[Lakshminarayana316]

Yes it might be a bug ,i already raised a bug in issues section.Could you please check #2536

#2536

Re sending the complete details here

Sending again here also

Source Version
Azure DevOps Server 2022

Target Version
Azure DevOps Service

{
"Serilog": {
"MinimumLevel": "Debug"
},
"MigrationTools": {
"Version": "16.0.4",
"Endpoints": {
"Source": {
"EndpointType": "TfsEndpoint",
"AllowCrossProjectLinking": "False",
"Authentication": {
"AccessToken": "Removed",
"AuthenticationMode": "AccessToken",
"NetworkCredentials": {
"Domain": "",
"Password": "",
"UserName": ""
}
},
"Collection": "https://scom/NordicCollection/",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
},
"Project": "SRP",
"ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId"
},
"Target": {
"EndpointType": "TfsEndpoint",
"AllowCrossProjectLinking": "False",
"Authentication": {
"AccessToken": "Removed",
"AuthenticationMode": "AccessToken",
"NetworkCredentials": {
"Domain": "",
"Password": "",
"UserName": ""
}
},
"Collection": "https://dev.azure.com/Cloud/",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
},
"Project": "SRPcloud",
"ReflectedWorkItemIdField": "Custom.ReflectedWorkItemId"
}
},
"Processors": [
{
"ProcessorType": "TfsSharedQueryProcessor",
"Enabled": true,
"PrefixProjectToNodes": false,
"SharedFolderName": "Shared Queries",
"SourceToTargetFieldMappings": null,
"SourceName": "Source",
"TargetName": "Target",
}
]
}
}