We have TFS 2017.3 On-Premise, with XAML builds.
We are faced with builds issues when build freezes on “Associate Changesets and Work Items” sequence with next error “TF246018: The database operation exceeded the timeout limit and has been canceled. Verify that the parameters of the operation are correct.”
Builds with such issues aren`t stopped after the timeout, so they lock agents and build restart process.
If we re-run the build it can be passed successfully.
The issue can occur in different build definitions with different agents.
Update: we are facing the same issue again. the build stack on Associate Changesets and Work Items” sequence. the build machine is reverted every build so i guess clean cache is not a solution. any suggestions, please?
It seems that we finally get RC why the build stuck.
We've looked through the history of builds, check-ins and found a specific WI from which build became stackable contains ASCII control EXT (We've just copied one by one all fields of WI to notepad++ and found that symbol (VS doesn`t show such symbols)).
After we removed this WI and created a new WI and linked the changeset to it the build passed.
So we guess the reason is the TFS don't know to handle this ASCII symbols and during the build he can't save the work item and the build stuck.