Reporting URL not recognized

May 12, 2011 at 11:38 PM

We've just moved our reporting services to another server with the TFSReports folder moved down into a folder structure on the new server.  After the move the TFS Admin Tool is not recognizing the full path to the TFSReports folder.

Old reporting server has the TFSReports under the root of reporting services, accessible via http://oldserver/reports.  The new reporting server is accessible via http://newserver/reports, but the TFSrports  folder is under root > DEVM > TFS.  When the TFS admin tool attempts to read SSRS the following error is produced:

5/12/2011 4:30:41 PM: Exception occurred
                       Type: System.Web.Services.Protocols.SoapException
                       Message: The item '/DEVM/TFS/projectName' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/DEVM/TFS/projectName' cannot be found.
                       InnerException: -
                       Source: System.Web.Services
                       Target: System.Object[] ReadResponse(System.Web.Services.Protocols.SoapClientMessage, System.Net.WebResponse, System.IO.Stream, Boolean)
                       Stacktrace:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at TFSAdministrationTool.Proxy.ReportServer.ReportingService2005.GetPolicies(String Item, Boolean& InheritParent) in D:\Work\TFSAdmin\Main\src\TFSAdministrationTool.Proxy\Web References\ReportServer\Reference.cs:line 3358
   at TFSAdministrationTool.Proxy.ReportServiceProxy.GetSecuritySettings(String name) in D:\Work\TFSAdmin\Main\src\TFSAdministrationTool.Proxy\ReportServiceProxy.cs:line 177
5/12/2011 4:30:41 PM: ReportingService.Url: http://newserver/ReportServer/ReportService2005.asmx
5/12/2011 4:30:41 PM: Reporting Services site status: Unavailable
5/12/2011 4:30:41 PM: ReportWebServiceUrl: http://newserver/ReportServer/ReportService2005.asmx
5/12/2011 4:30:41 PM: Initializing roles
5/12/2011 4:30:41 PM: Initializing roles mapping

The key in the above is the '/DEVM/TFS/projectName', this should be '/DEVM/TFS/TFSReports/projectName'.  To get to correct folder.  Does the admin tool have an issue when the project folder 4 layers deep vs the standard of two layers?  If so is there any work around to correct this?

Other than this issue moving the TFS reports is working perfectly.

Thanks,
Trevor

Jul 5, 2011 at 9:45 AM

We encountered the same problem in our TFS configuration. After a closer look in the Admin Tool source code we discovered that the current implementation only supports 2 levels in the report folder. We changed the implementation of the TeamFoundationServerProxy.cs file in the TFSAdministrationTool.Proxy project of the solution. In the private method GetReportsRoot() we changed the lines

string[] tokens = reportFolder.Split('/');

return String.Format("/{0}/{1}/", tokens[1], tokens[2]);

in the following line of code:

return reportFolder.Substring(0, reportFolder.LastIndexOf("/") + 1);

This did the fix for us, and we can now manage the security of the reporting via the TFS Administration Tool.

 

Hope this helps.

 

 

Mar 20, 2012 at 1:21 PM

@Matonko, thanks for posting a solution for this issue. It worked for me!