Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Facing a weird issue with one of the CRM Web server. Below is the detail
1- We have a distributed setup wherein we have 2 CRM Web Servers and 2 App Servers linked to a single Database server.
2- The DB server has the reporting server and the MS CRM reports extension
3- Now the servers are linked via a single F5 URL that can send request to any of the available web server.
4- Whenever a user accesses a CRM report and if the request goes to Server 1 then the reports is not displayed. Instead below error is displayed
Reports cannot be run because the Connector for Microsoft SQL Server Reporting Services, a required component for reporting is not installed on the server that is running Microsoft SQL Server Reporting Services.
5- On server 1 below error is logged into the event viewer.
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 6/19/2017 12:22:46 PM Event time (UTC): 6/19/2017 9:22:46 AM Event ID: dad343b8b5c146d1993196655273a1a4 Event sequence: 655049 Event occurrence: 91 Event detail code: 0 Application information: Application domain: /LM/W3SVC/2/ROOT-1-131423115595418347 Trust level: Full Application Virtual Path: / Application Path: Microsoft Dynamics CRM\CRMWeb\ Machine name: ****** Process information: Process ID: 10072 Process name: w3wp.exe Account name: ***** Exception information: Exception type: CrmException Exception message: MSCRM Data Connector Not Installed at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal() at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters() at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Request information: Request URL: GIB-CRM/CRMReports/rsviewer/reportviewer.aspx Request path: /GIB-CRM/CRMReports/rsviewer/reportviewer.aspx User host address: ::1 User: ******* Is authenticated: True Authentication Type: Negotiate Thread account name: ******** Thread information: Thread ID: 37 Thread account name: Is impersonating: False Stack trace: at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal() at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters() at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
6- On Server 2 the reports are working fine without any error.
My understanding seems that either the MS CRM installation is corrupted or some of the files within the installation got corrupt. Now the funniest thing is that the CRM on this server is not giving any other issue so apart from reports the rest of the CRM functionality is working perfectly. Also the issue has surfaced just recently and the reports were working fine on the server. There is no update installed on the server and both the CRM Web servers are the exact replica.
Any help in this would be really appreciating.
Thanks and Regards,
This does sound strange, as the configuration data regarding the report server is stored in the MSCRM_Config database, so both web servers should see the same data.
It might be that Server 1 has incorrectly been configured as having the reporting server role. I suggest you run CRM Deployment Manager to check the roles of each server, and also the configured ReportServer url for each organisation. It's worth running CRM Deployment Manager on each of Server 1 and Server 2 to check they display the same information (they should, as this is read from MSCRM_Config)
The following link provides a resolution of this error.
Hope this helps.
Business Applications communities