Geeks With Blogs
Tim Huffam Dotting the I and crossing the T of I.T.

Turns out you can't just move a TFS warehouse/cube from SQL Server 2005 to 2008...  

Once performed we got the following error on the TFS app server tier  - when we tried to update/process the cube (both manually and via the TFS scheduler service):
Detailed Message: Failed to load adapter Microsoft.TeamFoundation.Warehouse.CommonStructureAdapter. Exception Info: \n Microsoft.TeamFoundation.Server.AnalysisServiceConnectionException: Error encountered when creating connection to Analysis Services. Contact your Team Foundation Server administrator. ---> Microsoft.AnalysisServices.ConnectionException: Cannot connect to Analysis Services version '10.0.1600.22'.

The point worth noting here is the version number (10.0.1600.22) - this is the version of the updated Analysis Services server (on the SQL Server 2008 platform).  The problem was that our TFS app server did not have the client access software of the correct version.

Assuming you've moved your cube already (using this article) - The following steps should fix the problem (all done on the TFS app server tier):

  1. Install the correct version of the Microsoft.AnalysisServices.dll assembly.   Download and install "Microsoft Analysis  Management Objects" from here.
  2. Update the following config files so that this line
    <bindingRedirect oldVersion="9.0.242.0" newVersion="9.0.242.0"/>
    looks like this:
    <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0"/>
    Files to update:
    <programfiles>\Microsoft Visual Studio 2008 Team Foundation Server\Web Services\Warehouse\web.config
    <programfiles>\Microsoft Visual Studio 2008 Team Foundation Server\TFSServerSchedluer\TFSServerScheduler.exe.config
  3. Process the cube (this updates both the TFSWarehouse relational db and then the cube:
    - Log on to the TFS app server, then navigate your browser to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx, then click Run, then Invoke.
    - go back to the main warehousecontroller.asmx page and run GetWarehouseStatus - to monitor it's progress.
    - when it's complete (status of idle) check the event log for errors - should be none.
  4. Run a report (via  http://tfsappserver/reports url) to see if it contains updated data.
  5. Restart the TFS Scheduler service.

Note that if you're having problems - ie you're not seeing updated data in the reports, yet you're not seeing errors in the event log, then turn on verbose error logging (I think that's what this is/does) but updating the web.config file in this dir: <programfiles>\Microsoft Visual Studio 2008 Team Foundation Server\Web Services - changing this line<add name="General" value="1" />  to value="4"

Here's some useful links I found while trying to do all this work:

 I have to say, TFS really is a b*tch to manage. 

HTH
Tim

Posted on Thursday, November 4, 2010 10:42 PM C# .NET , Dev Env, TFS, MSBuild etc | Back to top


Comments on this post: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Managing TFS can really test your patience some days :)

It looks like this post is specifically for TFS 2008. There's actually a much easier way to do this. Be sure to have SP1 for TFS 2008 installed and then go to the Add/Remove programs control panel and then choose "Repair" for TFS 2008. This will automatically update everything you mentioned in a supported way. Microsoft doesn't support making manually updates to files that it installs or reading from/making changes to the TFS databases. :( Just make sure you don't get yourself into an unsupported scenario.
Left by Ed Blankenship on Jan 07, 2011 8:45 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
nice article and great post i really like this post a lot
Left by bollywood lyrics on May 29, 2011 12:14 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Well, I had to take some time to find the answer to this problem, and a friend suggested looking for here. A great answer, thank you for letting me know this.
Left by Cheap Vietnam Flights on Jul 18, 2011 10:40 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I learned a lot from this post, I will follow the article. Thank you for sharing
Left by phuong hoang on Aug 21, 2011 2:44 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
i am sure now after reading this i will be able what i want to do. Thanks for sharing
i too
Left by Sieu Thi Dien May on Aug 21, 2011 2:45 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Very good with the explanation. I'll try to follow your instruction. Thanks
Left by Stuff on Aug 21, 2011 5:43 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Useful advice on SQL. Thank a lot.
Left by Google page rank, Alexa rank on Aug 21, 2011 5:45 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
The post is great, thank for sharing
Left by Tran thach cao on Aug 23, 2011 10:22 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thanks for good post, it's easy to understand
Left by nguyen on Aug 27, 2011 2:42 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thanks, for share
Left by nha dat ha noi on Oct 28, 2011 1:36 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
nice article.Thanks for share
Left by web statistic on Nov 15, 2011 3:04 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thanks, for share
Left by Dien dan rao vat on Nov 21, 2011 10:08 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thankx for this post! now problem solved:)
All about technology
Left by AShish on Dec 01, 2011 10:12 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Nice job, keep it up
Left by social Media Sports on Dec 02, 2011 8:25 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I have been searching for the decision on how to move all TFS warehouse data from old version of SQL server to the new one. I was afraid of disappearing of data. Thanks for the answers. I will try your method, but I will create a reserve copy before.
Left by Florida Piano Dealer on Dec 12, 2011 3:23 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which I need, thanks for all the enthusiasm to offer such helpful information here.
Left by Vietnam Train Ticket on Dec 17, 2011 4:13 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I’d would like to thank you for visiting my vapor cigarette information site.I know that you’ll benefit from all the information on the vapor cigarette
Left by hoc tieng anh on Dec 19, 2011 2:55 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thankx for this post! now problem solved:)
Left by gamesbox.com on Jan 06, 2012 3:23 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
very like
Left by gamesbox on Jan 10, 2012 1:18 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
i like SQL 2005 than 2008
Left by noi that on Jan 16, 2012 2:01 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Its more complicated with MYsql
Left by Free WhoIs on Jan 19, 2012 12:45 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I couldn't solve My sql problem .but now i did :).thanx for sharing informative tips:)
Left by Ashish on Feb 08, 2012 1:05 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I love these types of hardware. Cheers mainly for indicating software program.
Left by Instagram Android on Apr 10, 2012 12:51 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
i like SQL 2005 than 2008
Left by tui xach nu on May 22, 2012 11:53 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I’d would like to thank you for visiting my vapor cigarette information site
Left by EVIVA on Jul 10, 2012 11:37 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thanks..........
Left by KHoahocmaytinh.org on Jul 14, 2012 7:44 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I have saved this web page and I truly intend on visiting the site in the upcoming days.
Left by rao vat on Aug 07, 2012 10:22 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I think this is the information for a long time but I still found it interesting. From cheap Vietnam flights
Left by Justin on Aug 22, 2012 2:09 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Hello. Very cool site!! Man .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds also…I’m happy to find so much useful information right here in the post. Thanks for sharing…
Left by ftth viettel on Sep 17, 2012 8:55 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Thanks you, nice post
Left by Tai facebook on Oct 27, 2012 1:29 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Cam on bai viet rat hay
Left by Tin nhan chuc ngu ngon on Oct 27, 2012 1:31 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I like this website
Left by Dang nhap facebook on Oct 29, 2012 11:01 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
good site, thanks for share
Left by tai facebook on Nov 20, 2012 2:17 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Thanks your sharing. Have a nice day!
Left by tai opera mini on Nov 30, 2012 3:04 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
Thank you for sharing this wonderful idea. Honestly, I learned new things from your post
Left by dang nhap facebook on Nov 30, 2012 3:05 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
This sharing is really useful for me.
Hope to have your next post again.
Left by tai uc browser on Nov 30, 2012 3:06 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
I’m happy to find so much useful information right here in the post. Thanks for sharing…
Left by giầy nam on Dec 13, 2012 8:34 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thanks you......
Left by rao vat mien phi on Jan 17, 2013 9:54 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
thanks for sharing useful information for me
Left by MINH QUAN on Feb 28, 2013 7:39 PM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
nice article.Thanks for share
Left by may lanh gia re on Apr 30, 2013 8:29 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
This sharing is really useful for me.
Left by máy lạnh sharp on Apr 30, 2013 8:30 AM

# re: Moving TFS warehouse from SQL Server Analysis Services 2005 to SQL Server 2008
Requesting Gravatar...
The contents of this article is very interesting, I am willing to read it, thank you it brings me happiness.
Left by cham soc da on Apr 30, 2013 8:31 AM

Your comment:
 (will show your gravatar)


Copyright © Tim Huffam | Powered by: GeeksWithBlogs.net