We did a server move a while back and ever since then we have been having a weird “error” happen repeatedly. In a nutshell, when you first request connection (via VS.NET, TFS Admin Console or Web Site) it fails with a DB timeout. Then, just hit refresh and everything is working fine. I looked in the Service logs and found this:
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 7/22/2010 10:54:21 PM
Application Domain: /LM/W3SVC/8080/ROOT/tfs-1-129243128405943147
Assembly: Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Name: w3wp
Process Id: 2068
Thread Id: 3556
Account name: NT AUTHORITYNETWORK SERVICE
Detailed Message: Application Request Processing Started
Server Version = Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Service Account = NT AUTHORITYNETWORK SERVICE
Machine Name = WEB2
Exception Message: TF246018: The database operation exceeded the timeout limit and has been cancelled. Verify that the parameters of the operation are correct. (type DatabaseOperationTimeoutException)
It is driving me nuts and I am wondering if anyone else has run into this behavior. I’ve checked everything I would normally check and nothing is fixing this behavior. Any ideas?
NOTE: I am in trying to add a new team project collection in the TFS Admin Console -> [MachineName]/Application Teir/Team Project Collections. Nothing is listing in the Admin Console and it is perpetually in “Loading…” mode. WTF?
After spending a couple days on the phone with MS Product Support on this we finally have it working.
- Reinstall TFS on the App Server
- Go through IIS and found app pools were not set right, changed back to f/x 2.0 classic
- Database machine’s firewall was not allowing TCP connections on the correct port to SQL Server (hence the not connecting first time, then it went to named pipes and connected – but TFS wants TCP connections)
These were the main culprits. We even went through all the security accounts and those ended up having the right permissions so were more of a red herring to chase.
There is a tool for moving TFS – use it!
- New installation of TFS: TFS Administration Console shows NO options – only Logs
- Add a user to the “Team Foundation Service Accounts” group in TFS
- TFS 2010 – Adding users to a Team Project
- How can I hide projects in TFS source control from an Active Directory group?
- Can TFS 2010 be installed onto a single server and in a Workgroup (not AD)