问题描述
从TFS 15 RC2升级到2017年TFS。
升级前数据仓库处理和立方体成功。
现在失败。
完全重建操作完全失败。测试管理仓库同步超时（它说）。
我禁用了所有其他仓库作业和分析作业，并尝试重新运行Test one。仍然
失败。
默认情况下，超时设置是3600秒（1小时）我相信。但是，这个错误发生的时间早于
而不是1小时。
大约10分钟后发生。
从SQL Server完全删除仓库后，通过TFS管理工具重新创建仓库并尝试
来处理Test Managment数据，大约10分钟后仍然会出现相同的超时错误。
这是输出。
应用程序域：TfsJobAgent.exe
程序集：Microsoft.TeamFoundation.Framework.Server，Version = 15.0.0.0，Culture = neutral，PublicKeyToken = b03f5f7f11d50a3a;
v4.0.30319
服务主机：
流程详情：
进程名称：TfsJobAgent
进程ID：5664
线程ID：5524
帐户名称：AMDS \svctfsservice
详细消息：TF221122：运行作业的错误测试管理仓库同步团队项目
集合或Team Foundation服务器DefaultCollection。
异常消息：TF246018：数据库操作超出了超时限制并已被取消。
验证操作的参数是否正确。（类型DatabaseOperationTimeoutException）
异常堆栈跟踪： at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException（Int32
errorNumber，SqlException sqlException，SqlError sqlError）
在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException（SqlException
sqlException）
在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException（SqlException
ex，QueryExecutionState queryState）
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException（Exception
exception）
在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteCommand（ExecuteType
executeType，CommandBehavior behavior，String performanceGroupName）
at Microsoft.VisualStudio.Services.CircuitBreaker.Command。<> c__DisplayClass7_0。< Execute> b__0（）
在Microsoft.VisualStudio.Services.CircuitBreaker.CommandAsync。<执行> d__28.MoveNext（）
---从抛出异常的上一个位置开始的堆栈跟踪结束---
在System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw（）
at Microsoft.VisualStudio.Services.CircuitBreaker.Command.Execute（Action run，Action fallback）
在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteCommandWithBaseCircuitBreaker（ExecuteType
executeType，CommandBehavior behavior，String performanceGroupName）
在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteReader（）
在Microsoft.TeamFoundation.TestManagement.Warehouse.WarehouseResultDatabase.QueryTestResults（SqlBinary
watermark，Int32 limit，ProcessRowCallback resetCallback，ProcessMappingDataCallback dataCallback，ResolveIdentities resolveIdentitiesCallBack）
在Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.QueryForResults（WarehouseResultDatabase
wrd，SqlBinary waterMark，Int32 limit）
在Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter。<> c__DisplayClass116_0。< ProcessIntegratedResults> b__0（）
在Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.ProcessDataWithDiagnosticInfoLogging [T]（Func`1
processBatch，Int32 limit，T& highWaterMark）
在Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.MakeDataChanges（）
在Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.MakeDataChanges（IVssRequestContext requestContext，
TeamFoundationJobDefinition jobDefinition，String& resultMessage）
在Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.RunInternal（IVssRequestContext requestContext，
TeamFoundationJobDefinition jobDefinition，DateTime queueTime，String& resultMessage）
在Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run（IVssRequestContext requestContext，TeamFoundationJobDefinition
jobDefinition，DateTime queueTime，String& resultMessage）
内部异常详细信息：
异常消息：超时已过期。操作完成前经过的超时时间或服务器未响应的
。（类型SqlException）
SQL异常类：11
SQL异常编号：-2
SQL异常程序：
SQL异常行号：0
SQL异常服务器：ENG-CORPSQL
SQL异常状态：0
SQL错误：
异常数据字典：
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 12.00.5000
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = -2
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
Upgraded from TFS 15 RC2 to TFS 2017.
Data warehouse processinga and cube was successful before upgrade.
Fails now.
A complete rebuild operation fails exactly the same. Test Management Warehouse Sync times out (it says).
I disabled all other warehouse jobs and analysis jobs and have tried to rerun just the Test one. Still fails.
The timeout setting is 3600 seconds (1 hr) by default I believe. However, this error is happening sooner than 1 hr.
It occurs after about 10 min.
After completely deleting the warehouse from SQL server, recreating it via the TFS admin tool and trying to process just the Test Managment data, I still have the same timeout error occur after about 10 min.
Here is the output.
Application Domain: TfsJobAgent.exe
Assembly: Microsoft.TeamFoundation.Framework.Server, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v4.0.30319
Service Host:
Process Details:
Process Name: TfsJobAgent
Process Id: 5664
Thread Id: 5524
Account name: AMDS\svctfsservice
Detailed Message: TF221122: An error occurred running job Test Management Warehouse Sync for team project collection or Team Foundation server DefaultCollection.
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(Exception exception)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteCommand(ExecuteType executeType, CommandBehavior behavior, String performanceGroupName)
at Microsoft.VisualStudio.Services.CircuitBreaker.Command.<>c__DisplayClass7_0.<Execute>b__0()
at Microsoft.VisualStudio.Services.CircuitBreaker.CommandAsync.<Execute>d__28.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.VisualStudio.Services.CircuitBreaker.Command.Execute(Action run, Action fallback)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteCommandWithBaseCircuitBreaker(ExecuteType executeType, CommandBehavior behavior, String performanceGroupName)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteReader()
at Microsoft.TeamFoundation.TestManagement.Warehouse.WarehouseResultDatabase.QueryTestResults(SqlBinary watermark, Int32 limit, ProcessRowCallback resetCallback, ProcessMappingDataCallback dataCallback, ResolveIdentities resolveIdentitiesCallBack)
at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.QueryForResults(WarehouseResultDatabase wrd, SqlBinary waterMark, Int32 limit)
at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.<>c__DisplayClass116_0.<ProcessIntegratedResults>b__0()
at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.ProcessDataWithDiagnosticInfoLogging[T](Func`1 processBatch, Int32 limit, T& highWaterMark)
at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.MakeDataChanges()
at Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.MakeDataChanges(IVssRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, String& resultMessage)
at Microsoft.TeamFoundation.Warehouse.WarehouseSyncJobExtension`1.RunInternal(IVssRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage)
at Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(IVssRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage)
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: ENG-CORPSQL
SQL Exception State: 0
SQL Error(s):
Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 12.00.5000
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = -2
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
这篇关于TFS 2017 - 测试管理仓库同步作业始终因超时而失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！