如何在签入时解决 TFS 错误 TF246021 和 SQL Server 错误 500200? [英] How to solve TFS error TF246021 and SQL Server error 500200 while checking in?

问题描述

我正在尝试签入一个文件，一个文件(一个且只有一个)在被签入时出现问题.此文件已被多次删除且未删除(由于架构和设计冲突)现在 TFS 抛出这个错误:

I'm trying to check in a file, and one file (one and only one file) has a problem while being checked in. This file has been deleted many times and undeleted (due to a conflict in architecture and design) and now TFS throws this error:

TF246021:处理您的请求时出错.技术的信息(对于管理员):SQL Server 错误:500200

TF246021: An error occurred while processing your request. Technical information (for administrator): SQL Server Error: 500200

正如我们看到的事件查看器的日志文件，问题是:

As we saw the log file of the Event Viewer, the problem is:

违反 PRIMARY KEY 约束PK_tbl_PendingDelta".不能在对象 'dbo.tbl_PendingDelta' 中插入重复键.

Violation of PRIMARY KEY constraint 'PK_tbl_PendingDelta'. Cannot insert duplicate key in object 'dbo.tbl_PendingDelta'.

但是，dbo.tbl_PendingDelta 中没有待处理的更改.事实上，这张表是完全空的.这里有什么问题?我该如何解决这个问题?

However, there is no pending changes in dbo.tbl_PendingDelta. In fact, this table is completely empty. What's wrong here? How can I solve this problem?

推荐答案

这似乎与工作区有关.我在一个工作区遇到了这个问题，但能够在不同的工作区中执行触发错误的源代码控制操作(回滚之前的回滚)，没有任何问题.

This seems to be related to the workspace. I had this problem on one workspace but was able to perform the source control operation that triggered the error (rollback a previous rollback) in a different workspace without any problems.

重新创建您的工作区可能是一个解决方案.

Recreating your workspace might be a solution.

这篇关于如何在签入时解决 TFS 错误 TF246021 和 SQL Server 错误 500200?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！