I am using Dynamics CRM 2011 on premise.
Reports were working fine a few days ago. Today they don't.
I am getting this error: "The report cannot be displayed. (rsProcessingAborted)
"
I just run a report with warning level tracing on and this was logged:
[2013-07-09 14:10:50.099] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 102 |Category: Sandbox.LoadBalancer |User: 00000000-0000-0000-0000-000000000000 |Level: Warning |ReqId: 0792ea86-fee7-4f86-b38a-00b5cf68cf57 | SandboxHostManager.PingSingleClient ilOffset = 0xB8
>ping: exception: SRV-CRM02: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at net.tcp://srv-crm02/CrmSandboxHost that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
[2013-07-09 14:10:50.512] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 102 |Category: Sandbox |User: 00000000-0000-0000-0000-000000000000 |Level: Warning |ReqId: 0792ea86-fee7-4f86-b38a-00b5cf68cf57 | SandboxClientBase`1.Stop ilOffset = 0xD
>System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
Server stack trace:
at System.ServiceModel.Channels.CommunicationObject.Close(TimeSpan timeout)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at System.ServiceModel.ICommunicationObject.Close()
at Microsoft.Crm.Sandbox.SandboxClientBase`1.Stop()
This is in the reporting service log: http://pastebin.com/qm8FLzrn
Fixed by removing ports from SPNs.
Thanks to Alen at Microsoft.