TL;DR; 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?
Each classification [Concepts, Categories, & Tags] was assigned using AI-powered semantic analysis and scored across relevance, depth, and alignment. Final decisions? Still human. Always traceable. Hover to see how it applies.
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.
Slicedbread
Qualco
Sage
Hubtel Ghana
ALS Life Sciences
Brandes Investment Partners L.P.
NIT A/S
Ericson
Schlumberger
Akaditi
Alignment Healthcare
MacDonald Humfrey (Automation) Ltd.
Microsoft
Boeing
Emerson Process Management
Lean SA
Bistech
YearUp.org
Nottingham County Council
Department of Work and Pensions (UK)
Washington Department of Transport
Royal Air Force
New Hampshire Supreme Court
Washington Department of Enterprise Services
New Signature
Higher Education Statistics Agency
Hubtel Ghana
Philips
YearUp.org
Akaditi
