Explains how to resolve the TF237165 error in TFS Integration Tools, caused by validation or mapping issues when updating work items during data migration.
While running an integration platform import you get a “TF237165: The Team Foundation Server could not update the work item because of a validation error on the server. This may happen because the work item has been modified or destroyed, or that you do not have permission to update that work item.”
Figure: TF237165: The Team Foundation Server could not update the work item
Unfortunately it does not tell you what it was trying to save.
This was a Configuration error that was not really presented effectively. I found it by reducing the dataset to a few known failing items and commenting out all of the field before re-running the migration. I then added each field in one at a time until the error occurred.
I had a missing field migration to map a data value into reason:
And I had an incorrect mapping in the ValueMap:
Figure: Value mapping for Reason field
You can see on lines 2 and 3 of the code above I had incorrectly specified the mapping as having a left value for the field that I was mapping as a @@MISSINGFIELD@@.
The mentioned field either needs removed from the mapping or added to the work item. In this case I will be removing it from the mapping as I don’t need that field on the Task WIT.
Did this solve your problem?
No related videos found.
If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.
We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.
Epic Games
Deliotte
Higher Education Statistics Agency
Workday
Brandes Investment Partners L.P.
Big Data for Humans
Boeing
Emerson Process Management
ALS Life Sciences
Slicedbread
Akaditi
Teleplan
Qualco
Sage
DFDS
Cognizant Microsoft Business Group (MBG)
Trayport
Xceptor - Process and Data Automation
Nottingham County Council
Washington Department of Transport
Washington Department of Enterprise Services
Royal Air Force
New Hampshire Supreme Court
Ghana Police Service
Brandes Investment Partners L.P.
Boeing
NIT A/S
Sage
Teleplan
YearUp.org