TeamFoundation

TeamFoundation

关注
发信
关注(28)粉丝(399)

TFS 2015.3 - 无法将值NULL插入“Build”列，表'tempdb.dbo

本文介绍了TFS 2015.3 - 无法将值NULL插入“Build”列，表'tempdb.dbo的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我注意到我们的TFS应用程序层自几周以来每小时多次登录一些错误。 无法将值NULL插入"Build"列，表'tempdb.dbo。 我如何排除故障？我们有一个或多个现在无法销毁的testResults吗？ 希望你能提供建议。 Nico TF53010：Team Foundation组件或扩展中发生以下错误：日期（UTC）：12/04/2017 14:09:34 计算机：servername 应用程序域：TfsJobAgent.exe 程序集：Microsoft.TeamFoundation.Framework.Server，Version = 14.0.0.0，Culture = neutral，PublicKeyToken = b03f5f7f11d50a3a; v4.0.30319 服务主机：流程详细信息：流程名称：TfsJobAgent 流程ID：4472 线程ID：23528 帐户名称：domain \\ \\ ttfs-service 详细消息：TF221122：为团队项目集合或Team Foundation服务器CollectionName运行作业测试管理仓库同步时发生错误。 异常消息：无法将值NULL插入"Build"列，表'tempdb.dbo。＃resultsWithBuildCompensation _______________________________________________________________________________________ 0000004F86E5';列不允许空值。 INSERT失败。 （类型SqlException） SQL异常类：16 SQL异常编号：515 SQL异常过程：prc_DestroyResults SQL异常行号：220 SQL异常服务器：数据.tfs.domain SQL异常状态：2 SQL错误： 异常数据字典： HelpLink.ProdName = Microsoft SQL Server HelpLink.ProdVer = 12.00.5000 HelpLink.EvtSrc = MSSQLServer HelpLink.EvtID = 515 HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink HelpLink。 LinkId = 20476 {421AC3F1-A306-4C9B-B3F6-5812F9121FC8} = True 异常堆栈跟踪：在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 e xecuteType，CommandBehavior行为） at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteCommandWithBaseCircuitBreaker（ExecuteType executeType，CommandBehavior behavior） at Microsoft.TeamFoundation.Warehouse.WarehouseBatchedDataAccessComponent.ExecuteScalar（） at Microsoft .TeamFoundation.Warehouse.WarehouseDataAccessComponent.DestroyResults（String projectId，String data，ResultDeletionFormat format，Int32 limit） at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.ProcessRunDeletes（IWarehouseDataAccessComponent dac，ObjectTypes objectType） at Microsoft .TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.DeleteTcmObject（IWarehouseDataAccessComponent dac，ObjectTypes objectType，Boolean deleteResults） at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.DeleteTcmObjects（IWarehouseDataAccessComponent dac，Boolean deleteResults） at Micros oft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.DeleteTcmObjects（Boolean deleteResults） at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.ProcessDeletes（） 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） 解决方案 您好nsijtsma， 感谢您发布此处。 根据错误消息，仓库数据库发生此错误。因此，我建议您尝试从SQL Server中删除TFS仓库和分析数据库，然后使用TFS管理控制台重新创建它们： 1.连接到 Analysis Service 使用 Microsoft SQL Server Management Studio ，展开 数据库节点，然后删除Tfs_Analysis数据库。并使用相同的方法从SQL Server中删除Tfs_Warehouse数据库。   2.使用TFS管理控制台重新创建Tfs_Warehouse和Tfs_Analysis数据库： 启动TFS管理控制台>>应用程序层>>报告，在右侧面板中，单击 编辑以打开报告窗口。 在仓库标签下，在数据库文本框下键入Tfs_Warehouse。  在 Analysis Services 标签下，在 数据库文本框下输入Tfs_Analysis，然后重新提供 帐户访问数据源下的所需帐户。 在报告标签下，提供报告服务器网址并重新提供所需帐户 访问数据源的帐户。 点击确定，在SQL Server中生成新的Tfs_Warehouse和Tfs_Analysis数据库。    点击开始工作并开始重建重建仓库和Analysis Services数据库。 最好的问候 Limitxiao高 Hi,I noticed that our TFS Application tier has been loggin some errors multiple times per hour since a few weeks.Cannot insert the value NULL into column 'Build', table 'tempdb.dbo.How do i troubleshoot this ? do we have one or more testResults that now cannot be destroyed ?Hope you can advise.NicoTF53010: The following error has occurred in a Team Foundation component or extension:Date (UTC): 12/04/2017 14:09:34Machine: servernameApplication Domain: TfsJobAgent.exeAssembly: Microsoft.TeamFoundation.Framework.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v4.0.30319Service Host: Process Details: Process Name: TfsJobAgent Process Id: 4472 Thread Id: 23528 Account name: domain\tfs-serviceDetailed Message: TF221122: An error occurred running job Test Management Warehouse Sync for team project collection or Team Foundation server CollectionName.Exception Message: Cannot insert the value NULL into column 'Build', table 'tempdb.dbo.#resultsWithBuildCompensation_______________________________________________________________________________________0000004F86E5'; column does not allow nulls. INSERT fails. (type SqlException)SQL Exception Class: 16SQL Exception Number: 515SQL Exception Procedure: prc_DestroyResultsSQL Exception Line Number: 220SQL Exception Server: data.tfs.domainSQL Exception State: 2SQL Error(s):Exception Data Dictionary:HelpLink.ProdName = Microsoft SQL ServerHelpLink.ProdVer = 12.00.5000HelpLink.EvtSrc = MSSQLServerHelpLink.EvtID = 515HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlinkHelpLink.LinkId = 20476{421AC3F1-A306-4C9B-B3F6-5812F9121FC8} = TrueException Stack Trace: 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) at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteCommandWithBaseCircuitBreaker(ExecuteType executeType, CommandBehavior behavior) at Microsoft.TeamFoundation.Warehouse.WarehouseBatchedDataAccessComponent.ExecuteScalar() at Microsoft.TeamFoundation.Warehouse.WarehouseDataAccessComponent.DestroyResults(String projectId, String data, ResultDeletionFormat format, Int32 limit) at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.ProcessRunDeletes(IWarehouseDataAccessComponent dac, ObjectTypes objectType) at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.DeleteTcmObject(IWarehouseDataAccessComponent dac, ObjectTypes objectType, Boolean deleteResults) at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.DeleteTcmObjects(IWarehouseDataAccessComponent dac, Boolean deleteResults) at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.DeleteTcmObjects(Boolean deleteResults) at Microsoft.TeamFoundation.TestManagement.Warehouse.TeamTestWarehouseAdapter.ProcessDeletes() 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) 解决方案 Hi nsijtsma,Thank you for posting here.According to the error message, this error happens to the warehouse database. So I suggest that you could try to delete TFS warehouse and analysis database from SQL Server, then recreate them using TFS Admin Console:1.Connect to Analysis Service using Microsoft SQL Server Management Studio, expand theDatabases node, and delete the Tfs_Analysis database. And use the same way to delete Tfs_Warehouse database from SQL Server.  2.To recreate the Tfs_Warehouse and Tfs_Analysis database using TFS Admin Console:Launch TFS Admin Console>>Application Tier>>Reporting, in the right panel, clickEdit to open the Reporting windows.Under Warehouse tab, type Tfs_Warehouse under Database textbox. Under the Analysis Services tab, input the Tfs_Analysis underDatabase textbox, and re-provide the required account under Account for accessing data source.Under Reports tab, provide report server URLs and re-provide required account underAccount for accessing data source.Click Ok to generate the new Tfs_Warehouse and Tfs_Analysis database in SQL Server.  Click Start Jobs and Start Rebuild to rebuild warehouse and the Analysis Services database.Best RegardsLimitxiao Gao 这篇关于TFS 2015.3 - 无法将值NULL插入“Build”列，表'tempdb.dbo的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！
09-15 20:16
Powered by LMLPHP ©2024 TeamFoundation 0.004557