The workspace version table contains an unknown schema version

Question

Just started up Visual Studio 2012 and opened my solution which is in source control with Team Foundation Server 2012 Express and encountered this, any ideas? Can't get latest, can't check in, everything appears checked out :( Basically my workspace is unusable right now.

TF400018: The local version table for the local workspace MY-PC;My User could not be opened. The workspace version table contains an unknown schema version.

There is only one post I could find on the net, and the answers are pretty vague.

Answer 1

I had the same issue, and I just fixed it on mine.
If you don't mind re-map all your projects, you can try follow:

• Click the box in "Workspace".
• Click on "Workspaces".
• Delete the workspace profile you're currently using
• Re-connect to TFS open "Source Control"

Be aware that you may lose all your TFS mappings, you may need to re-map all your projects from TFS. Backup your changes that not checked in yet.

Answer 2

cycle6 is correct, but it isn't clear that you will not lose your pending check-in list if you follow some additional steps.

1. Click the box labelled "Workspace".
2. Click on "Workspaces".
3. Delete the corrupt workspace profile, accepting the warning.
4. Re-connect to TFS and open "Source Control Explorer"
5. Create a new workspace
6. One by one, map your projects to the same folder as before
7. You will be presented with a list of conflicts, where you have matching writable files in the folder already.
8. Choose "Keep local copy" for each file you had checked out before, and "Take Server Version" for any files changed by other members of the team that you didn't have the latest version for. This might take a while depending on the length of the list, but it is worth comparing versions for any file you are unsure of.

You will be left with your solution and all pending items marked as checked out, with your work preserved.

Answer 3

I did the following steps and it solved the issue:

1. deleted the hidden folder named $tfs and then
2. in the Visual Studio, Solution Explorer: Right click on the solution node > the Source Control > Get Specific version > latest version