在 TFS 中映射本地目录时发生数据库错误(SQL 错误 18054) [英] Database error occurred (SQL error 18054) when mapping local directory in TFS

问题描述

我使用 VS2010 作为 TFS 实例的客户端.我创建了一个工作区，需要将一个 TFS 目录映射到一个本地目录 - 我们将本地目录称为D:aaabbcccddd".当我导航到管理工作区"并单击编辑"以将本地目录更改为此路径时，出现以下错误:1

I'm using VS2010 as a client for a TFS instance. I created a workspace, and need to map a TFS directory to a local directory - let's call the local directory "D:aaabbcccddd". When I navigate to "Manage Workspaces" and click "edit" to change the local directory to this path, I am presented with the following error: 1

当我尝试映射时发生此错误:D:aaa"、D:aaabb"、D:aaabbccc".

This error occurs when I try to map: "D:aaa", "D:aaabb", "D:aaabbccc".

现在，如果我创建一个名为:D:aaabbccc1ddd"的文件夹，映射有效，并且我没有收到此错误.

Now, if I create a folder called: "D:aaabbccc1ddd", the mapping works, and I do not receive this error.

有人可以帮忙吗?我已经为此拔了大约一天的头发.

Can anyone help? I've been pulling my hair out for about a day over this.

谢谢.

推荐答案

SQL 错误

首先，您不应收到来自 TFS 的 SQL 错误 18054(或任何 SQL 错误).

First of all, you should not be receiving SQL Error 18054 (or any SQL errors) from TFS.

您应该让您的 TFS 管理员连接到为您的 TFS 服务器托管 master 数据库的 SQL 服务器并运行以下查询:

You should have your TFS administrator connect to the SQL server that hosts the master DB for your TFS server and run the following query:

select * from master.dbo.sysmessages where error > 50000

如果这是 TFS2010 服务器，您的 TFS 管理员可能能够使用 TFSConfigPrepSql 重新安装错误信息.

If this is a TFS2010 server, your TFS administrator may be able to use TFSConfig PrepSql to re-install the error messages.

如果这是 TFS2008 服务器，您的 TFS 管理员将需要打开添加/删除程序并在 TFS 上运行修复.

If this is a TFS2008 server, your TFS administrator will need to open Add/Remove programs and run a repair on TFS.

你的实际问题

这听起来很明显，两个本地路径不能指向相同的放置在相同的存储库中工作区.然而，那个抓住了很多人不知道的是你不能有两个存储库路径映射到一个本地路径同一台电脑.

This sounds obvious at first, two local paths cannot point to the same place in the repository for the same workspace. However, the one that catches a lot of folks un-aware is that you cannot have two repository paths mapped to one local path on the same computer.

在 TFS 中，您不能有两个具有重叠映射的文件夹.由于D:aaabbcccddd是D:aaa的子文件夹，所以不能添加.

In TFS, you cannot have two folders with overlapping mappings. Since D:aaabbcccddd is a sub-folder of D:aaa, then you cannot add it.

不过，您可以做的一件事是隐藏文件夹，这样它们就不是工作区映射的一部分.在您的情况下，您可能希望映射 D:aaa 并为该目录中的所有其他子文件夹添加一个 cloak，D:aaabb 除外.

One thing you can do though, is cloak folders so that they aren't part of the workspace mappings. In your case, you might want to map D:aaa and add a cloak for all the other subfolders in that directory, except for D:aaabb.

这篇关于在 TFS 中映射本地目录时发生数据库错误(SQL 错误 18054)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！