Error TFS Services (TF53010 and TF246018)

Question

Hi Friends i have a question:

I've a TFS 2010 with SQL Server Standard 2008 and one day the developers report me that they cannot access.  So i tried to logon me to database and it wasn´t possible, also i tried to access to this machine and the SQL Service doesn´t respond (i couldnt to restart the SQL Service).

So, my next action was to check the TFS logs and i found the following error:

Date  7/26/2012 2:35:05 PM
Log  Windows NT (Application)

Source  TFS Services
Category  (0)
Event  3008
Computer  SERVER01

Message
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 7/26/2012 7:35:05 PM
Machine: SERVER01
Application Domain: TfsJobAgent.exe
Assembly: Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Service Host:
Process Details:
  Process Name: TFSJobAgent
  Process Id: 3040
  Thread Id: 3860
  Account name: DDP\UserTFS

Detailed Message: There was an error during job agent execution. The operation will be retried. Similar errors in the next five minutes may not be logged.
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)

Exception Stack Trace:    at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(Int32 errorNumber, SqlException sqlException, SqlError sqlError)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(SqlException sqlException)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(SqlException ex)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
   at Microsoft.TeamFoundation.Framework.Server.BackgroundJobComponent.QueryQueuedJobs(Boolean allowDeferJobs, Int32 dormancyInterval, Int32 maxJobs)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationJobService.QueryQueuedJobs(Int32 maxJobs, Int32& nextScheduledJob)
   at Microsoft.TeamFoundation.Framework.Server.JobApplication.CheckJobQueue()
   at Microsoft.TeamFoundation.Framework.Server.JobApplication.ProcessJobQueueInternal()
   at Microsoft.TeamFoundation.Framework.Server.JobServiceUtil.RetryOperationsUntilSuccessful(RetryOperations operations)

Inner Exception Details:

Exception Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. (type SqlException)
SQL Exception Class: 11
SQL Exception Number: -2
SQL Exception Procedure:
SQL Exception Line Number: 0
SQL Exception Server: SRV01129
SQL Exception State: 0
SQL Error(s):

Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = -2
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476

Exception Stack Trace:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)

I don´t know exactly what means this error, so, i searched in Internet and the people says that this error is because TFS executed a query too long. Is that truth? 

Please help me with this!

Greetings

Aleds

Answer 1

Hi Aleds,

Seems there problem casued by SQL. Would you go SQL machine to check any error there?

Answer 2

Hi Aleds,

Thank you for your post.

According to your description of the issue, here are some situations i want to clarify from you:
1. By "that they cannot access", what opeation do the users do, use team explorer connect to TFS, or access other function?
2. Do you change account or password for tfs service or SQL service?
3. Would you please go to the machine that database locate in, open event log to search is there any errors?
4. What's the message show out when try to open database via SQL management studio?

Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi Mini Jacson and Lily for your help

Lyly, for your questions:

1. By "that they cannot access", what opeation do the users do, use team explorer connect to TFS, or access other function?

I talked with the developers and the only symptom was, when they tried to connect to Team Explorer it stayed frozen (The Team Explorer screen dialog and the VS 2010 IDE)

2. Do you change account or password for tfs service or SQL service?

No, definitely nop.

3. Would you please go to the machine that database locate in, open event log to search is there any errors?

Ok, it was my fault, because the log that i published in the past post it was from Windows Event Logs.  In the database log only it was reported a Report Server problem:

"Report Server (MSSQLSERVER) cannot connect to the report server database". 

I don´t understand this, because the functionality is enable in the TFS but anyone used it. I don´t know if this error provocate this incident.

4. What's the message show out when try to open database via SQL management studio?

I didn't capture the message this day but i remember that appeared the error "time out expired" or something like that.

One thousand  Thanks for your help.

Greetings

Aleds

PD:  Sorry for question this again, but Is it possible this problem was caused for a query too long execute by TFS 2010 internally?

Answer 4

Hi Aleds,

Thank you for your response.

From the information, seems you cannot connect SQL database now, the issue may casue by SQL problem. Would you please go to SQL forum to fix the SQL problem, then see if the TFS has problem too.

Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us