Upgrading TFS WSS 2.0 to 3.0 Process
As you already know, one of the TFS 2010 prerequisites is WSS 3.0.
Besides that, if you upgrade TFS 2005 to 2008, you should also upgrade WSS to 3.0. From a huge amount of posts over the internet, WSS upgrade is the most difficult thing when you upgrade TFS. I wanted to help you a little and provide some details with an upgrade I made a few days ago.
Basic Infoformation:
· TFS 2008 with SP1
· 70 something Team Projects
· WSS 2.0
· 2 application tiers
· 2 data tiers with cluster
Goal:
To Upgrade WSS 2.0 to 3.0
How:
That's the catch, because of my luck of knowledge in WSS I've decided to create WSS 2.0 server in a testing environment. I got 2 servers one for the data and one for the application (similar to the real TFS environemnt) I restored the STS_Content_TFS database in the data server, install WSS 2.0 in the application server and configure it to work with the restored STS_Content_TFS.
(The testing WSS 2.0 automatically creates STS_Config_TFS database for its inner configurations).
After 15 minutes or so, I had WSS 2.0 working in testing environment with all sits from the production. Believe it or not – this was the easy part.
You can read the post of the WSS upgrade process in Neno Loje site: http://msmvps.com/blogs/vstsblog/archive/2008/05/11/screen-gallery-upgrading-wss-2-0-to-wss-3-0.aspx
Basically the steps I needed to do were:
- Run prescan.exe /all
- Install .Net 3.5 + SP1 (WSS 2.0 does not need .Net 3.5 but WSS 30 does)
- Install WSS 3.0 (chose in place upgrade + web front end)
- Configure WSS Central Administration port (I chose 17013 + NTLM)
Seems easy well, NOT!
Prescan.exe /all tool must run before you install WSS 3.0.But it kept on failing with this weird error in the log:Error: The following site has not been scanned. Id = GUIDE and Url = / Checking if any list has not yet been scrubbed in Server="DATATIERNAME";Database="STS_Content_TFS";Trusted_Connection=yes;App="prescan.exe". Prescan has encountered sites or lists that were not updated because they cannot be accessed using the SharePoint Products and Technologies object model
Look at that URL: / - what's that…?!?
After digging Bing (and Google…) I've decided to delete 2 rows in Sites table and Webs table in STS_Content_TFS database. Yes! With SQL Server Management Studio I deleted 2 rows in Sites and Webs with Id=GUIDE:
SELECT *FROM Sites
WHERE Id = GUIDE
SELECT *FROM Webs
WHERE SiteId = GUIDE
I did not know what those rows were – the FullUrl was http://localhost which is not a site.
After that the prescan.exe /all passed with no errors and the upgrade succeeded…almost J
It fail while upgrading – mean I came as far as ever – to the UpgradeStatus.aspx – this page refreshed every 1 minute and tells you the upgrade status.
After 20 minute I saw a red line with a path to upgrade.log file.
I skim the file and get this error:
CanUpgrade [SPContentDatabase Name=... Parent=SPDatabaseServiceInstance] failed.[SPManager] [ERROR]: The pre-upgrade scan tool has not yet been run on this database SPContentDatabase Name=.... Parent=SPDatabaseServiceInstance. You must run the pre-upgrade scan tool before you can continue with the upgrade process. Run the tool from the following path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\prescan.exe.
But I did! L What is the problem??– Sure I did something bad – deleting rows from the database – what did I expect…
Trying with Microsoft support and nothing – I roll back the testing environment (data\WSS) 10 times trying to upgrade the damn thing with nothing.
Than I remembered I have a production environment, let's try prescan.exe /all there… it updates the database but does nothing to the data.
Guess what, it went with no errors at all in the first time. I need not delete rows at all. That left me with some more question marks…
Than I got it!!!
Entering the STS_Config_TFS database in the production environment I saw that Sites table (yes, also Site table in STS_Config_TFS) contains a row with url - / (!!!)
To confirm it – I open the browser and navigated to http://TFS site – there is a WSS site there!!!
When I try to go to http://TESTING_WSS site it gave me 404 page not found!
All this time I thought the problem was the TFS-WSS special configuration or prescan.exe or upgrade process when all the time the problem was the Config database – that somehow not created a / site in Sites table…
Again, with SQL Server management I open the STS_Config_TFS.Sites table, and add new row with the same GUIDE (I mentioned earlier) and than the upgrade process went smooth!
After 3 weeks TFS WSS 2.0 upgrade to 3.0 in the production environment J