TFS has lost connection to the database for the SharePoint integration

Question

We have been using the TFS SharePoint integration for some time now. Recently, there is a disconnect between Team Explorer and the Documents directory. I can still see that the information about the files are in the database, but we are getting errors when trying to connect via Team explorer. 

I saw a posting about fixing this via the database, but the table spoken of, tfsIntegration, is not in our databases. 

Doing a repair connection via the TFS Admin Console yielded that permissions were reset for some collections, but other collections error out. 

What steps do I take to reconnect the documents back to TFS? We are on the TFS Server 2012 version Product Version number 11.0.50727.1.

Thanks

Answer 1

Is there anyone who can help with this? We are needing out Release Notes and can not get to them...

Answer 2

Hi Retzcat, 

Thanks for your post. 

What’s the error you received when trying to open Documents using Team Explorer?

Can you open the documents from team project portal?

You can see that information about the files in which database?

After you clicked the Repair Connection in TFS Admin Console, repair completely? Does there have any error in repair log?

If you not install TFS 2012 Update 1, I suggest you install TFS 2012 Update 1 on your TFS 2012 Server, and then install this KB for TFS 2012 Update 1 server.

This issue requires more troubleshooting. If it is urgent issue, I suggest you to contact a Professional Support Service at http://support.microsoft.com/common/international.aspx?RDPATH=gp;en-us;offerprophone to gain more support on this case.   

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

What’s the error you received when trying to open Documents using Team Explorer?

Please contact your administrator. There was an error contacting the server.Technical information (for administrator):  HTTP code 500: Internal Server Error

Can you open the documents from team project portal?

No, we get the Server error in '/' Applicaiton (yellow screen if death)

You can see that information about the files in which database?

If I query through SQL Server
SELECT [Id]
      ,[SiteId]
      ,[DirName]
      ,[LeafName]
      ,[Version]
      ,[TimeCreated]
      ,[TimeLastModified]
      ,[SetupPathVersion]
 
  FROM [WSS_Content].[dbo].[AllDocs]

After you clicked the Repair Connection in TFS Admin Console, repair completely? Does there have any error in repair log?

It seems to repair 1 collection (yet we still can't access it) and then we get errors

Connecting project portal site at http://tfshost/sites/Core/Structured Document (1 of 118)
[Error] Connection failed for project portal site at http://tfshost/sites/Core/Structured Document: Please contact your administrator. There was an error contacting the server.
Technical information (for administrator):
  HTTP code 500: Internal Server Error

If you not install TFS 2012 Update 1, I suggest you installTFS 2012 Update 1 on your TFS 2012 Server, and then install thisKB for TFS 2012 Update 1 server.

Ok- is this a known problem?
Thanks

Answer 4

Hi Retzcat, 

Thanks for your reply.

As we know that SharePoint Product work as a component in our deployment of TFS, and SharePoint Product has its owner databases. If you can’t open the documents from team project portal, I think this issue relate to your SharePoint Product, it seems that your SharePoint product has a connect issue with its database. I suggest you contact SharePoint experts for the better response.   

You can ask SharePoint experts how to resolve this issue(can’t open documents) in general SharePoint site, then you can use the same way to resolve the issue in your team project portal.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 5

Thanks for the response... I will repost this under sharepoint..

Answer 6

hi Retzcat

could access the sharepoint site "Core" using Sharepoint Central Administration or did you get an error there as well ?

Could you check if the web site is still running - IIS management console ?

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 7

I can get into the Sharepoint Administration site, and do anything I need to do. The web site is running... 

Currently we are trying to bring up a testing instance so I can apply the upgrade/patch to see if this will correct the problem.  And I haven't heard from anyone under the Sharepoint forum yet... I feel I'm swimming in the dark here on this! 
Thanks

Answer 8

I was able to get the update to install along with the patch on our test server and this has not corrected the problem. Could it be a corrupt database?

Answer 9

Hi Retzcat, 

Thanks for your reply.

Yes, I think there’s some issue with your SharePoint database.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 10

I am needing to get this resolved and am finding NOTHING except that our instance is not the first to experience this.

Please can I get a step by step of how to correct this? Most posts are very vague.

Thanks

Answer 11

FYI-

Our DBA just ran DBCC CHECKDB on all the databases for the TFS instance and we found no problems with any of them..... 

Answer 12

Hi Retzcat, 

Thanks for your reply.

There’s no responses from your SharePoint forum post?

This issue requires more troubleshooting. If it is urgent issue, I suggest you to contact a Professional Support Service at http://support.microsoft.com/ to gain more support on this case.   

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.