Project Portals stop working after restoring TFS from backups  
Author Message
toforo





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

Synopsis of Problem:
After restoring TFS from backups, the Project Portals cease working. When I try to load one I get the error message "The virtual server that is referenced here is not in the config database.".

Full Story:
In my evaluation of Team Foundation Server I decided to see how smoothly a backup and restore would go. The backup was easy enough. I backed up all the TFS databases (per this article) and the reporting services encryption key (per this article).

With backups safely stored on a separate machine I wiped the server running TFS, reinstalled Server 2003, applied all available updates, and started the TFS install by following the instructions found in the installation guide for a single server configuration. I used the .ini file provided for the SQL server installation and the command suggested for the non-interactive install for SharePoint Services (I installed everything the same way I installed it the first time). Once Team Foundation Server was installed, I used this document to guide the restore.

All the steps from the restore seemed to go exactly as they should and by the time I finished everything looked great. That is, everything except the Project Portals. After completing the restore, Team Foundation Server has all work items, source code, supporting documents, etc. except the Project Portals don't work. When trying to access the project portals I get the error: "The virtual server that is referenced here is not in the config database."

So far I haven't be able to fix it. One of the first things I did to try to fix it is go into SharePoint Central Administration -> Set configuration database server and confirmed that the database server name was correct and that it was pointing to the correct database (both were true). Just to be sure, I committed the already correct set of information. After committing the settings, the project portals still don't work.

I also checked that the default web site is running (it is) and that the application pool it uses has access to the database (it does). At this point I'm not sure where to go. I've tried searching MSDN, Google, Experts Exchange, and anything else I could think of to find a solution, but to no avail. From the reading I've done it seems that if the TFS databases were imported correctly (which they seem to have been) then the Project Portals should work.

Any help would be greatly appreciated. If you need any further information about the problem, please let me know and I'll see what I can do to give it.
Thanks,
-toforo


Visual Studio Team System12  
 
 
kayers





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

Several things can go wrong with the Sharepoint portion of TFS after a restore.

Did the name of the server change after the restore

Did you keep a backup of the Sharepoint databases after installation but before restoring



 
 
toforo





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

The name of the server did not change after the restore. I did not keep a backup of the SharePoint databases after installation but before restoring, should I have
-toforo

 
 
kayers





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

My own experiences have gine me the impression that sharepoint is very fragile. The only way I have been successful in restoring sharepoint with TFS was by not restoring the config database, just the content database. This was a restore onto a machine with a different server name however, but I got the same sorts of errors as what you first posted.

Check out this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=505756&SiteID=1



 
 
toforo





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

I've attempted to following the procedure you've listed in your post. For step 4 you said "Add in the STS_Content_TFS database through Sharepoint Administration" which I'm not sure how to do. The only option in the SharePoint Administration that I see that resembles that is "Set default content database server" which doesn't seem to allow me to select the database, just the server. What am I missing
Thanks,
-toforo

 
 
kayers





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

From the Sharepoint Administration site:

Configure virtual server settings
Default Web Site
Manage Content Databases

From here you should see the list of content database and be able to add and remove them.

It is hard to find some of these things in sharepoint, I always have to look around a little before I find anything.



 
 
toforo





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

Thank you kayers, that worked great. I'm now facing a "Cannot complete this action" error, but I have a few things to try to see if I can't get it work. Thank you again for your help.
-toforo

 
 
AK-47





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

I was able to fix this issue even after I had the problem with the STS Content and Config DBs being restored. The issue, I think most face, that are mentioned, is the references the config and content DB have to the old server name and DB, you are restoring from. I looked exhaustively through SQL at both databases and most references point at the new server, if using the new MS docs for moving to another hardware config during restoration. The Portal portion is a problem. I noticed that the TFS virtual server actually works when getting this error. Did you try http://localhost:8080 I saw that the TFS sites were available but the default website is supposed to point over to the Virtual Server link for TFS. I first removed the default website virtual server link to any content databases. TFS still remains working and no need to change. I also removed the content Database from the sharepoint Server Farm. I then went back to the default website virtual server and mapped to an exisiting content database. Pointed to STS_apptierservername_1, 9000 and 15000. It then remapped to the new server name and content database fine. I checked by going to http://localhost, and BAM! Worked! Not sure if this is the same issue people are having but I stepped through this a few times and seems to be the same results with the documented restoration, and fix that I mentioned.
 
 
cchandru1974





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

Hi ..

I am facing peculiar problem with the restoration of TFS backup. Right now we have TFS running in production environ. We were looking to restore the backups taken from the production environ. to another server. The restoration is done as per your instructions listed on these pages.

The problem we face is that after the restore .. When we open the Report services page it says that the Database is not initialised but while going to the Reporting Services Config. of Sql Server and trying to initialise the DB an error occurs

"ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)"

and the DB is not getting initialised.

The other error is we could not connect to the TFS thru Team Explorer. It keeps on asking the username & pwd even if we give the correct name & pwd.

Prior to the backup restore on the Test Server .. we were able to connect to the Test Server TFS thru Team explorer.

The error which comes is TF30291 there was a problem on the server of unknown cause. The event log error shows as follows (there are FOUR error).. Could you enlighten me .. on what could be the problem ..

*************************************************************************************

First event

*********************************************************************

An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 10/7/2006 9:25:30 AM
Machine: OTBPDC
Application Domain: /LM/W3SVC/3/Root/services-1-128046860992343750
Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 2652
Thread Id: 2852
Account name: ODESSAPDC01\tfsservice

Detailed Message: A crash report for this problem was recently created; a new crash report for this occurrence of the problem is not being created. This problem has occurred 3 times.
Web Request Details
Url: http://otbpdc:8080/Services/v1.0/ServerStatus.asmx [method: POST]
User Agent: Team Foundation (devenv.exe, 8.0.50727.43)
Headers: Connection=Keep-Alive&Content-Length=354&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip&Accept-Language=en-US&Expect=100-continue&Host=otbpdc%3a8080&User-Agent=Team+Foundation+(devenv.exe%2c+8.0.50727.43)&X-TFS-Version=1.0.0.0&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fServerStatus%2f02%2fCheckAuthentication%22
Path: /Services/v1.0/ServerStatus.asmx
Local Request: True
Host Address: 192.168.0.50
User: ODESSAPDC01\IUSR_OTBPDC [authentication type: ]

Exception Message: Object reference not set to an instance of an object. (type NullReferenceException)

Exception Stack Trace: at Microsoft.TeamFoundation.Server.SecurityManager.IPrincipalToSidString(IPrincipal user)
at Microsoft.TeamFoundation.Server.ServerStatus.CheckAuthentication()

*******************************************************

Second event

*********************************************************

An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 10/7/2006 9:25:17 AM
Machine: OTBPDC
Application Domain: TFSServerScheduler.exe
Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: TFSServerScheduler
Process Id: 2284
Thread Id: 2360
Account name: ODESSAPDC01\tfsservice

Detailed Message: Microsoft.TeamFoundation.TeamFoundationServerUnauthorizedException: TF30063: You are not authorized to access TF50309: You do not have sufficient permissions to perform this operation.. ---> System.Security.SecurityException: TF50309: You do not have sufficient permissions to perform this operation.
at Microsoft.TeamFoundation.Client.CheckAuthenticationProxy.CheckAuthentication()
at Microsoft.TeamFoundation.Client.TeamFoundationServer.Authenticate(Boolean useProvider, ICredentialsProvider provider)
The Zone of the assembly that failed was:
MyComputer
--- End of inner exception stack trace ---
at Microsoft.TeamFoundation.Client.TeamFoundationServer.Authenticate(Boolean useProvider, ICredentialsProvider provider)
at Microsoft.TeamFoundation.Client.TeamFoundationServer.EnsureAuthenticated()
at Microsoft.TeamFoundation.Server.Scheduler.TaskScheduler.GetRegistrationProxy(String serverName)
at Microsoft.TeamFoundation.Server.Scheduler.TaskScheduler.LazyInit()

For more information, see Help and Support Center at

*****************************************************

Third event

**************************************************

An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 10/7/2006 9:25:17 AM
Machine: OTBPDC
Application Domain: TFSServerScheduler.exe
Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: TFSServerScheduler
Process Id: 2284
Thread Id: 2360
Account name: ODESSAPDC01\tfsservice

Detailed Message: Microsoft.TeamFoundation.TeamFoundationServerUnauthorizedException: TF30063: You are not authorized to access TF50309: You do not have sufficient permissions to perform this operation.. ---> System.Security.SecurityException: TF50309: You do not have sufficient permissions to perform this operation.
at Microsoft.TeamFoundation.Client.CheckAuthenticationProxy.CheckAuthentication()
at Microsoft.TeamFoundation.Client.TeamFoundationServer.Authenticate(Boolean useProvider, ICredentialsProvider provider)
The Zone of the assembly that failed was:
MyComputer
--- End of inner exception stack trace ---
at Microsoft.TeamFoundation.Client.TeamFoundationServer.Authenticate(Boolean useProvider, ICredentialsProvider provider)
at Microsoft.TeamFoundation.Client.TeamFoundationServer.EnsureAuthenticated()
at Microsoft.TeamFoundation.Server.Scheduler.TaskScheduler.GetRegistrationProxy(String serverName)
at Microsoft.TeamFoundation.Server.Scheduler.TaskScheduler.LazyInit()

For more information, see Help and Support Center at

An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 10/7/2006 9:25:07 AM
Machine: OTBPDC
Application Domain: TFSServerScheduler.exe
Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: TFSServerScheduler
Process Id: 2284
Thread Id: 2360
Account name: ODESSAPDC01\tfsservice

Detailed Message: TF50801: The initialization did not complete because there was no task list registered with the TFS Registration service, or an error prevented the TFS Registration service from providing the task list. Attempting to load the system task list from the latest log file.

For more information, see Help and Support Center at

****************************************************

Fourth Event

*******************************************************
An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 10/7/2006 9:25:07 AM
Machine: OTBPDC
Application Domain: TFSServerScheduler.exe
Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: TFSServerScheduler
Process Id: 2284
Thread Id: 2360
Account name: ODESSAPDC01\tfsservice

Detailed Message: Microsoft.TeamFoundation.TeamFoundationServerUnauthorizedException: TF30063: You are not authorized to access TF50309: You do not have sufficient permissions to perform this operation.. ---> System.Security.SecurityException: TF50309: You do not have sufficient permissions to perform this operation.
at Microsoft.TeamFoundation.Client.CheckAuthenticationProxy.CheckAuthentication()
at Microsoft.TeamFoundation.Client.TeamFoundationServer.Authenticate(Boolean useProvider, ICredentialsProvider provider)
The Zone of the assembly that failed was:
MyComputer
--- End of inner exception stack trace ---
at Microsoft.TeamFoundation.Client.TeamFoundationServer.Authenticate(Boolean useProvider, ICredentialsProvider provider)
at Microsoft.TeamFoundation.Client.TeamFoundationServer.EnsureAuthenticated()
at Microsoft.TeamFoundation.Server.Scheduler.TaskScheduler.GetRegistrationProxy(String serverName)
at Microsoft.TeamFoundation.Server.Scheduler.TaskScheduler.LazyInit()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



 
 
kayers





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

It sounds like there are probably multiple problems with your restore. I'm not sure if I can resolve all of them, but heres a couple of questions.

1. Did you add TFS's Service and Reporting account to the new server's groups I am assuming they are on the same domain and you have access to the same account (same name on a different domain is not the same)

2. Did you read through and follow the Report Server instructions very carefully when you went through the procedures Did you remember the encryption key http://msdn2.microsoft.com/en-us/library/ms400729.aspx I remember going through and seeing a few gotchas that if you missed might explain the 1st problem you were having. Reread the steps on reconfiguring your report server and see if there might be something you missed http://msdn2.microsoft.com/en-us/library/ms252516.aspx



 
 
Sarim Ghani





PostPosted: Team Foundation Server - Administration, Project Portals stop working after restoring TFS from backups Top

I have the Same Problem, When i reintall my Team server, i don't have an encryption that's why i can't restore the old key, now problem is that when i try to create a new project it gives me an error, "The Project Creation Wizard encountered an error while uploading documents to the Windows SharePoint Services server on srv-data". Please Help me, also i can't run project protals also, source safe and other features are working fine.

Also i the solution that is giving on that threat, by this my report section is start working but i can't access document section any more.

Thank you,

Shekhani