Ravendra's Blog

April 29, 2010

TFS Warehouse controller service

Filed under: Team foundation server 2010,TFS — Ravendra Mishra @ 11:10 am

Team foundation server 2010 warehouse controller services can be accessed from following link on TFS App server

http://<TFS App Server>:8080/tfs/teamfoundation/administration/v3.0/warehousecontrolservice.asmx

It gives following services in the list. Highlighted ones are specially useful to synchronize warehouse and olap databases.


April 23, 2010

Incorrect TFS 2010 work item url from email

Filed under: TFS — Ravendra Mishra @ 4:15 pm

Recently I installed TFS 2010 (RC) and write my custom web service to send email based on various business rules. Email send by the service had incorrect URL and I got following error




Windows cannot find ‘:8090/wi.aspx’. Make sure you typed the name correctly, and then try again. To search for a file, click the Start button, and then click Search.





Later I realized that this issue is because I haven’t turned email alerting on. Once email is enabled and proper smtp server setting is configured from TFS Administrator console, url’s are automatically correct even for custom web service. Email can be configured as below.

Do following setting on TFS App server.


  1. Launch “Team foundation server administration console” from the TFS App server.
  2. Select Application Tier node
  3. Go to Email Alert settings group
  4. Click change Alert settings and specify correct settings


  1. Click ok
  2. Iisreset or recycle tfs specific application pool and job done.

Team foundation server 2010 Beta 2 expiry date

Filed under: TFS — Ravendra Mishra @ 3:02 pm
Tags: ,

Team foundation server 2010 Beta 2 expires on 30/06/2010. You can check this from your Team foundation server administration console.

February 2, 2010

SSRS Report on TFS 2010 Portal

Sometimes default reports which comes out of the box with process templates are not enough and custom reports are required. These reports can be put together on SharePoint team portal to create a dashboard or part of existing pages/ dashboards. If using SSRS on SharePoint integrated mode than rdl files of these reports can be copied directly on document libraries. Sometimes SSRS is not running on SharePoint integrated mode specially when SSRS is deployed in different box then SharePoint box. In such cases using Web page view web part can be quite useful.

Let’s say there is project collection called “PCollection” contains a project called “PProject” contains a report called “PReport” then URL for this report on page viewer web part will be something like


If report is located within folders let’s say “Dashboards” then URL will be


If report name of folder name contains multiple words then space between these words should be replaced by ‘+’ symbol. For example in above examples folder name is “Project dashboards” and report name is “Burn up report” then URL will be something like


January 29, 2010

SSRS not able execute dataset

Filed under: SSRS,TFS — Ravendra Mishra @ 3:53 pm
Tags: , , ,

Recently I have created few reports for Team foundation server. Dataset for these reports were calling stroed procedures and functions. These reports worked well in dev envionrment but not in prod. I have asked deployment team to run stored procedures on TFS warehouse database. Later I found that its because the SSRS service account was not able to execute these reports so for all the stored procedures and functions I provided execute/ select permission for service account and it worked.

Execute permission for stored procedures and Scalar functions

grant exec on dbo.prc_Report_GetCurrentIteration to TfsWarehouseDataReader

grant exec on dbo.prc_Report_ProjectBurnUp to TfsWarehouseDataReader

Select permission for Table valued function

grant select on dbo.GetIterationDates to TfsWarehouseDataReader

grant select on dbo.SplitString to TfsWarehouseDataReader

Create a free website or blog at WordPress.com.