Hi Everyone,
I have a problem running the SSRS Fetch XML reports on CRM 2016 On-prem. The report works when I run it from Visual Studio, but when deployed to CRM org, It fails with the following error (see attached image):
The report cannot be displayed. (rsProcessingAborted)
I am using the Fetch XML data source type.
Does anyone encountered this problem before ?
Thank you.
*This post is locked for comments
Can you check if the connection is working fine. ON the report server :
Let us know if the connection succeed and if not, what is the error.
The other thing you can try is to check MSCRM_CONFIG database to see if the GUID of your organization is same as mention in error log .i.e. 6e86e59c-3896-e611-80f4-005056855463
A simple query like (select Id from Organization where DatabaseName = 'Organizationname_MSCRM' will give you the id.
Hi, there's nothing wrong with the Query, since you are using the Fetch XML for the data, there are issues with your connection string / credentials. Make sure they are accurate, if it doesn't work try replacing the OrgName with disco. Are you trying to deploy the report in the same environment that you have used in the connection string?
https://technet.microsoft.com/en-us/library/dn531151.aspx#FetchBased
It's always a good Idea to use SQL Filtered Views for SSRS Reporting in an On-premise Deployment.
Hi,
Thanks for replying.
The error message is : Organization With Id = 6e86e59c-3896-e611-80f4-005056855463 Does Not Exist
Well, the Organization exists and CRM is workin fine.
Here is the complete Logs:
processing!ReportServer_0-4!3728!03/01/2017-12:33:03:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmConfigObjectNotFoundException: Organization With Id = 6e86e59c-3896-e611-80f4-005056855463 Does Not Exist ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Organization With Id = 6e86e59c-3896-e611-80f4-005056855463 Does Not Exist
at Microsoft.Crm.ServerLocatorService.GetOrganizationScaleGroupId(Guid organizationId)
at Microsoft.Crm.Sandbox.InternalSandboxSdkClientManager.SelectAvailableServer(Guid organizationId, ServerRoles preferredServerRole)
at Microsoft.Crm.Sandbox.InternalSandboxSdkClientManager.GetAvailableClient(Guid organizationId, ServerRoles preferredServerRole, ServerData preferredServer)
at Microsoft.Crm.Sandbox.SandboxFetchProxy.InitializeClient()
at Microsoft.Crm.Sandbox.SandboxFetchProxy..ctor(Guid userId, Guid organizationId, ServerRoles preferredServerRole, ServerData preferredServer)
at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.DoOpen()
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
at Microsoft.Crm.ServerLocatorService.GetOrganizationScaleGroupId(Guid organizationId)
at Microsoft.Crm.Sandbox.InternalSandboxSdkClientManager.SelectAvailableServer(Guid organizationId, ServerRoles preferredServerRole)
at Microsoft.Crm.Sandbox.InternalSandboxSdkClientManager.GetAvailableClient(Guid organizationId, ServerRoles preferredServerRole, ServerData preferredServer)
at Microsoft.Crm.Sandbox.SandboxFetchProxy.InitializeClient()
at Microsoft.Crm.Sandbox.SandboxFetchProxy..ctor(Guid userId, Guid organizationId, ServerRoles preferredServerRole, ServerData preferredServer)
at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.DoOpen()
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
--- End of inner exception stack trace ---
Most likely permission issues, have you tried running the report from the report manager?
Do you have access to the Server? If so, type= event viewer, in the search, go to windows logs > Application and look out for errors and see the description.
OR
go to SQL installation folder> for example = SQLServer\MSRS12.MSSQLSERVER\Reporting Services\LogFiles. If the log files are enabled you should be able to see the logs and they are pretty much self explanatory
This should help :
If it doesnt work, pls share the log details.
Thanks,
PS
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
