Thursday, June 14, 2012 10:10 AM
I have a big problem with the new SSRS 2012 (Sharepoint Mode) at one of my customers Sharepoint 2010 farm and I hope somebody can help. I get always the following error message if i try to open a report over the Report Viewer Webpart or try to save a report over Report Builder 3.0 in a document library. SSRS 2010 is configured on a Single Server Farm (Sharepoint Mode) and published as a Sharepoint Application Service. Kerberos is also configured in the whole farm.
Message Report Builder:
Message Report Viewer in Sharepoint 2010:
06/13/2012 14:09:19.10 w3wp.exe (0x08F4) 0x08C4 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://<spfarmssrs>:32843/8e68c61c48d3486b8f5780736e9de269/ReportingWebService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Management/get_IsWebServiceEnabled' MessageId: 'urn:uuid:77ac2a30-b595-4faa-83f6-e2ce1e41e283' 665ee657-7c17-474e-b050-d115a932180f
06/13/2012 14:09:19.10 w3wp.exe (0x08F4) 0x08C4 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 665ee657-7c17-474e-b050-d115a932180f
06/13/2012 14:09:19.13 w3wp.exe (0x08F4) 0x08C4 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=36.9361189760151 665ee657-7c17-474e-b050-d115a932180f
06/13/2012 14:09:19.29 w3wp.exe (0x08F4) 0x08C4 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://<spfarmssrs>:32843/8e68c61c48d3486b8f5780736e9de269/ReportExecution.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Execution/LoadReport' MessageId: 'urn:uuid:b07b919a-fc06-4cf8-add1-617f40a1d42f' 665ee657-7c17-474e-b050-d115a932180f
06/13/2012 14:09:19.29 w3wp.exe (0x08F4) 0x08C4 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 665ee657-7c17-474e-b050-d115a932180f
06/13/2012 14:09:20.55 w3wp.exe (0x08F4) 0x08C4 SQL Server Reporting Services Report Server Catalog 0000 Unexpected Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item 'http://<spfarm1>/Reports/Unbenannt.rdl' cannot be found.; 665ee657-7c17-474e-b050-d115a932180f
The Sharepoint Environment looks like:
- Sharepoint Farm 1:
- Server 1: WFE -> is connected to the published Reporting Servers on Server 3.
- Server 2: Sharepoint Application
- Sharepoint Farm 2:
- Server 3: SSRS 2010 Sharepoint Mode
- Reporting Services Service Application published
- Database Server is a SQL Server 2008 R2 Cluster
- SP1 and the CU Februar Patch is installed on all servers.
- Kerberos is configured for all service users.
Hope someone can help to resolve the problem.
Saturday, June 16, 2012 9:08 AM
There area couple of issues I think but I cant quite tell if you have done this.
- Created an SSRS Reporting Services Application
- Open Port 32843 on your Windows Server Firewalls
- Also, usually when yiou see the Topology error you have created your AAM Settings
Monday, June 18, 2012 8:22 AM
Thank you for your reply. The first two steps already done. What do you mean with the AAM settings?
In my explanation there is an typing error. On Server 2 there is the new SSRS 2012 (Sharepoint Mode) feature with the Sharepoint Reporting Services AddIn installed.
Friday, August 03, 2012 4:41 PM
Any Luck on this yet? The best I can find is that publishing between farms is not supported but would like to know if someone got it working.
Tuesday, August 07, 2012 10:21 AM
Not yet. Sorry. I also think that the publishing between farms is not supported.