How to solve TFS error TF246021 and SQL Server error 500200 while checking in?

Question

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: 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:

Violation of PRIMARY KEY constraint 'PK_tbl_PendingDelta'. Cannot insert duplicate key in object '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?

Answer 1

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.

Answer 2

1.From the File menu, click Source Control, and then click Workspaces.

2.In Manage Workspaces dialog box, under the Name column, highlight the workspace that you want to remove, and then click Remove.

3.In the Confirmation dialog box, click OK.

your work is done.

And map your solution again then you can work properly.