Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Reports - why is it so...
Microsoft Dynamics CRM (Archived)

Reports - why is it so difficult!

(1) ShareShare
ReportReport
Posted on by Pete_N 1,695

Windows Server 2016 , CRM 2016 , SQL 2014

I have been going around in circles for the last few days. An windows update seems to have put the kibosh on my system

If I go into CRM and view an out of the box report, everything is well and dandy. If i use the report wizard and generate a simple report ( just a list ) against the account entity, the report gets created, but when trying to run the report i get the dreaded RsProcessingAborted Error

I have looked through the reporting services log ( below ) and scanned the net. Think i have followed about 20 sets of instructions and all to no effect ,  I need help!

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 2014.0120.5000.00 ((SQL14_PCU_main).160617-1804)</Product>
  <Locale>English (United Kingdom)</Locale>
  <TimeZone>GMT Standard Time</TimeZone>
  <Path>C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__11_30_2016_15_09_12.log</Path>
  <SystemName>CBDATA</SystemName>
  <OSName>Microsoft Windows NT 6.2.9200</OSName>
  <OSVersion>6.2.9200</OSVersion>
  <ProcessID>2484</ProcessID>
  <Virtualization>Hypervisor</Virtualization>
</Header>
<ProcessorArchitecture>AMD64</ProcessorArchitecture>
<ApplicationArchitecture>AMD64</ApplicationArchitecture>
rshost!rshost!10fc!11/30/2016-15:09:12:: i INFO: CLR runtime is initialized.
rshost!rshost!10fc!11/30/2016-15:09:12:: i INFO: Derived memory configuration based on physical memory as 10482716 KB
appdomainmanager!DefaultDomain!10fc!11/30/2016-15:09:12:: i INFO: Entered managed ServiceMain in DefaultDomain.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing DisableSecureFormsAuthenticationCookie to 'False'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing AuthenticationTypes to '5'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: w WARN: Initializing UrlRoot to default value of ''  because it was incorrectly specified in Configuration file as ''.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing MaxConnections to '2'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing AppID to '(Default)'  as specified in Configuration file.
library!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Initializing CacheLevel to 'Default'  as specified in Configuration file.
resourceutilities!DefaultDomain!dc4!11/30/2016-15:09:12:: i INFO: Reporting Services starting SKU: Standard
configmanager!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Using report server internal url localhost/ReportServer.
configmanager!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Using report server external url http://CBDATA:80/ReportServer.
configmanager!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Using url root http://CBDATA:80/ReportServer.
rshost!rshost!dc4!11/30/2016-15:09:13:: i INFO: Configuring maxPhysicalCpu=4, minLogicalCpu=0
rshost!rshost!dc4!11/30/2016-15:09:13:: i INFO: Logical processor per physical processor 2
rshost!rshost!dc4!11/30/2016-15:09:13:: i INFO: Logical processor per core 1
rshost!rshost!dc4!11/30/2016-15:09:13:: i INFO: Maximum logical CPU is 2
configmanager!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Using report server internal url localhost/ReportServer.
configmanager!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Using report server external url http://CBDATA:80/ReportServer.
configmanager!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Using url root http://CBDATA:80/ReportServer.
library!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
library!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\Logfiles
appdomainmanager!DefaultDomain!dc4!11/30/2016-15:09:13:: i INFO: Appdomain:2 WindowsService_0 started.
library!WindowsService_0!dc4!11/30/2016-15:09:15:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!WindowsService_0!dc4!11/30/2016-15:09:15:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!WindowsService_0!dc4!11/30/2016-15:09:15:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!WindowsService_0!dc4!11/30/2016-15:09:15:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
library!WindowsService_0!dc4!11/30/2016-15:09:15:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\Logfiles
resourceutilities!WindowsService_0!dc4!11/30/2016-15:09:15:: i INFO: Reporting Services starting SKU: Standard
library!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: Catalog SQL Server Edition = Standard
rshost!rshost!4fc!11/30/2016-15:09:15:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer.
rshost!rshost!4fc!11/30/2016-15:09:15:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
rshost!rshost!4fc!11/30/2016-15:09:15:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportManager.
rshost!rshost!4fc!11/30/2016-15:09:15:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
rshost!rshost!4fc!11/30/2016-15:09:15:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
resourceutilities!DefaultDomain!dc4!11/30/2016-15:09:15:: i INFO: Maximum memory limit is 65536Mb
rshost!rshost!dc4!11/30/2016-15:09:15:: i INFO: Derived memory configuration based on physical memory as 10482716 KB
servicecontroller!DefaultDomain!4fc!11/30/2016-15:09:15:: i INFO: Total Physical memory: 10734301184
rpcserver!DefaultDomain!1334!11/30/2016-15:09:15:: i INFO: Process monitoring started.
crypto!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: Exporting public key
crypto!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: Performing sku validation
crypto!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: Importing existing encryption key
dbpolling!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!6a0!11/30/2016-15:09:15:: i INFO: PollingMaintenance: Polling started
resourceutilities!WindowsService_0!6a0!11/30/2016-15:09:15:: i INFO: Maximum memory limit is 65536Mb
rpcserver!DefaultDomain!1030!11/30/2016-15:09:15:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!1030!11/30/2016-15:09:15:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS12.MSSQLSERVER'
appdomainmanager!WindowsService_0!1030!11/30/2016-15:09:15:: i INFO: Appdomain:2 WindowsService_0 initialized.
library!DefaultDomain!dc4!11/30/2016-15:09:16:: i INFO: Catalog SQL Server Edition = Standard
appdomainmanager!DefaultDomain!630!11/30/2016-15:13:58:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-131249924381320982 started.
appdomainmanager!ReportServer_0-1!630!11/30/2016-15:14:00:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
appdomainmanager!DefaultDomain!630!11/30/2016-15:14:00:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-131249924381320982 initialized (#1).
webserver!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: Reporting Web Server started
library!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
library!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\Logfiles
resourceutilities!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: Reporting Services starting SKU: Standard
ui!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2014, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
resourceutilities!ReportServer_0-1!630!11/30/2016-15:14:13:: i INFO: Maximum memory limit is 65536Mb
library!ReportServer_0-1!630!11/30/2016-15:14:16:: i INFO: Catalog SQL Server Edition = Standard
crypto!ReportServer_0-1!630!11/30/2016-15:14:16:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!ReportServer_0-1!630!11/30/2016-15:14:16:: i INFO: Exporting public key
crypto!ReportServer_0-1!630!11/30/2016-15:14:16:: i INFO: Performing sku validation
crypto!ReportServer_0-1!630!11/30/2016-15:14:16:: i INFO: Importing existing encryption key
wcfruntime!ReportServer_0-1!630!11/30/2016-15:14:19:: i INFO: Entering ExeuteCommand - Command = Render
library!ReportServer_0-1!630!11/30/2016-15:14:19:: i INFO: RenderForNewSession('/BOSS_MSCRM/CustomReports/{85EF5948-07B7-E611-841F-00155D011B07}')
CLR version v4.0.30319 loaded. processing!ReportServer_0-1!630!11/30/2016-15:15:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmException: An unexpected error occurred.
System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace:
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout
processing!ReportServer_0-1!630!11/30/2016-15:15:06:: e ERROR: An exception has occurred in data set 'DSMain'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmException: An unexpected error occurred.
System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace:
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.H
processing!ReportServer_0-1!630!11/30/2016-15:15:06:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!ReportServer_0-1!630!11/30/2016-15:15:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmException: An unexpected error occurred.
System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace:
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel
processing!ReportServer_0-1!630!11/30/2016-15:15:06:: w WARN: Data source 'CRM': Report processing has been aborted.
processing!ReportServer_0-1!630!11/30/2016-15:15:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmException: An unexpected error occurred.
System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace:
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel
library!ReportServer_0-1!630!11/30/2016-15:15:06:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmException: An unexpected error occurred.
System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace:
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channel
webserver!ReportServer_0-1!630!11/30/2016-15:15:06:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmException: An unexpected error occurred.
System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://cbcrm/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0187598. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.10.1.44:808
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace:
   at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
   at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan tim
rpcserver!DefaultDomain!1334!11/30/2016-15:15:18:: i INFO: Process monitoring stopped.
rpcserver!DefaultDomain!14f4!11/30/2016-15:15:18:: i INFO: RPC Server stopped.
servicecontroller!DefaultDomain!14f4!11/30/2016-15:15:18:: i INFO: RPC Server stopped.
appdomainmanager!DefaultDomain!14f4!11/30/2016-15:15:18:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-131249924381320982 unregistered.
appdomainmanager!ReportServer_0-1!14f4!11/30/2016-15:15:18:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-131249924381320982 unloading
servicecontroller!WindowsService_0!14f4!11/30/2016-15:15:18:: i INFO: Service controller exiting.
appdomainmanager!DefaultDomain!14f4!11/30/2016-15:15:18:: i INFO: Appdomain:2 WindowsService_0 unregistered.
appdomainmanager!DefaultDomain!14f4!11/30/2016-15:15:18:: i INFO: Appdomain:2 WindowsService_0 unloading.
dbpolling!WindowsService_0!dc4!11/30/2016-15:15:18:: i INFO: EventPolling polling service stopped
dbpolling!WindowsService_0!dc4!11/30/2016-15:15:18:: i INFO: NotificationPolling polling service stopped
dbpolling!WindowsService_0!dc4!11/30/2016-15:15:18:: i INFO: SchedulePolling polling service stopped
dbpolling!WindowsService_0!dc4!11/30/2016-15:15:18:: i INFO: UpgradePolling polling service stopped
appdomainmanager!DefaultDomain!4fc!11/30/2016-15:15:18:: i INFO: AppDomain:2 0 pending unload(s)
appdomainmanager!DefaultDomain!a24!11/30/2016-15:15:18:: i INFO: Appdomain:2 unregistered.
rshost!rshost!a24!11/30/2016-15:15:18:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.
servicecontroller!DefaultDomain!14f4!11/30/2016-15:15:18:: i INFO: Service shutting down.

*This post is locked for comments

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,304 User Group Leader on at
    RE: Reports - why is it so difficult!

    Hi Pete please review the following solution which involves adding an Inbound Rule in Windows Firewal for the crm server for tcp protocol using port 808 crmlearnings.blogspot.co.uk/.../crm-2011-crm-reports-following-error-in.html

    Hope that helps :)

  • tpeschat Profile Picture
    tpeschat 4,926 on at
    RE: Reports - why is it so difficult!

    Hi,

    We also faced issues with reports on CRM 2016, bringing even Down our CRM environment at all.

    On our side this was caused by using SQL Server 2014 with the latest SP installed in combination with CRM 2016.

    In the latest SP something changed in the execution Plans, which has a negative effect on CRM.

    It was proposed to us to run SQL Server 2014 in 2012 compatibity Mode, which "fixed" the issue on our side.

    Hth Thomas

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans