Answered by:
Wizard and custom Reports not rendering.

Question
-
The out of the box reports run correctly, but the custom reports and reports created with the report wizard do not display.
The report log shows the below error ( I apologize for adding the stack). I've followed various threads to set the spns. The same error is thrown after the spn change.
[2016-06-23 09:56:28.625] Process:ReportingServicesService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 71 |Category: Platform |User: 838822fd-d69d-e511-80b8-00155d001a01 |Level: Error |ReqId: 00000000-0000-0000-0000-000000000000 | ExceptionConverter.ConvertMessageAndErrorCode ilOffset = 0x222
at ExceptionConverter.ConvertMessageAndErrorCode(Exception exception, Int32& errorCode) ilOffset = 0x222
at ExceptionConverter.ToSingleFaultOther(Exception exception) ilOffset = 0x21
at ExceptionConverter.ConvertToFault(Exception exception) ilOffset = 0x54
at ExceptionConverter.TryConvertToFaultExceptionInternal(Exception exception, Boolean createNewFaultException, FaultException`1& faultException) ilOffset = 0x6D
at ExceptionConverter.TryConvertToFaultException(Exception exception, Boolean createNewFaultException, FaultException`1& faultException) ilOffset = 0x0
at InternalSandboxSdkClientManager.OnServerError(Object sender, ServerErrorEventArgs e) ilOffset = 0x7
at InternalSandboxSdkClient.Execute(SandboxSdkContext requestContext, String operation, Byte[] serializedRequest) ilOffset = 0x0
at SandboxFetchProxy.ExecuteInternal(SandboxSdkContext sdkContext, String requestName, Byte[] serializedRequest, IList`1 contactedServers) ilOffset = 0x0
at SandboxFetchProxy.Execute(OrganizationRequest request) ilOffset = 0xF
at SdkMetadataProvider.GetEntity(String name) ilOffset = 0x32
at MetadataHelper.GetEntity(String name) ilOffset = 0x0
at EntityExpression.get_EntityMetadata() ilOffset = 0x0
at AttributeExpression.get_AttributeMetadata() ilOffset = 0x0
at PropertyExpressionFactory.GetAttributeTypeCode(AttributeExpression attribute) ilOffset = 0x3
at PropertyExpressionFactory.GetProperties(AttributeExpression attribute) ilOffset = 0x0
at FetchProcessor.InitializeEntityFields(XmlNode entityNode, EntityExpression parentEntityExpression, IList`1 reportFieldNames) ilOffset = 0x7A
at FetchProcessor.InitializeFields(XmlDocument fetchDocument) ilOffset = 0x37
at FetchProcessor..ctor(String fetchXml, ICrmDataParameterCollection parameters, IMetadataHelper metadataHelper) ilOffset = 0x6E
at FetchDataExtensionCommand.<ExecuteReader>b__0() ilOffset = 0x3D
at ExceptionManager.HandleUnsafeException(Func`1 body) ilOffset = 0x0
>System.ServiceModel.Security.SecurityNegotiationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #120B8A6C: System.ServiceModel.Security.SecurityNegotiationException: A call to SSPI failed, see inner exception. ---> System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32Exception: The target principal name is incorrect
> --- End of inner exception stack trace ---
> at System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
> at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
> at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
> --- End of inner exception stack trace ---
>
>Server stack trace:
> at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
> at System.ServiceModel.Channels.StreamSecurityUpgradeInitiatorBase.InitiateUpgrade(Stream stream)
> at System.ServiceModel.Channels.ConnectionUpgradeHelper.InitiateUpgrade(StreamUpgradeInitiator upgradeInitiator, IConnection& connection, ClientFramingDecoder decoder, IDefaultCommunicationTimeouts defaultTimeouts, TimeoutHelper& timeoutHelper)
> at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper)
> at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper)
> 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.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
> at System.ServiceModel.ICommunicationObject.Open()
> at Microsoft.Crm.Sandbox.SandboxClientBase`1.Open()
> at Microsoft.Crm.Sandbox.SandboxClientBase`1.get_Proxy()
> at Microsoft.Crm.Sandbox.InternalSandboxSdkClient.Execute(SandboxSdkContext requestContext, String operation, Byte[] serializedRequest)
[2016-06-23 09:56:28.625] Process:ReportingServicesService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 71 |Category: Platform |User: 838822fd-d69d-e511-80b8-00155d001a01 |Level: Error |ReqId: 00000000-0000-0000-0000-000000000000 | ExceptionConverter.ConvertMessageAndErrorCode ilOffset = 0x222
at ExceptionConverter.ConvertMessageAndErrorCode(Exception exception, Int32& errorCode) ilOffset = 0x222
at ExceptionConverter.ToSingleFaultOther(Exception exception) ilOffset = 0x21
at ExceptionConverter.ConvertToFault(Exception exception) ilOffset = 0x54
at ExceptionConverter.TryConvertToFaultExceptionInternal(Exception exception, Boolean createNewFaultException, FaultException`1& faultException) ilOffset = 0x6D
at ExceptionConverter.TryConvertToFaultException(Exception exception, Boolean createNewFaultException, FaultException`1& faultException) ilOffset = 0x0
at InternalSandboxSdkClientManager.OnServerError(Object sender, ServerErrorEventArgs e) ilOffset = 0x7
at InternalSandboxSdkClient.Execute(SandboxSdkContext requestContext, String operation, Byte[] serializedRequest) ilOffset = 0x0
at SandboxFetchProxy.ExecuteInternal(SandboxSdkContext sdkContext, String requestName, Byte[] serializedRequest, IList`1 contactedServers) ilOffset = 0x0
at SandboxFetchProxy.Execute(OrganizationRequest request) ilOffset = 0xF
at SdkMetadataProvider.GetEntity(String name) ilOffset = 0x32
at MetadataHelper.GetEntity(String name) ilOffset = 0x0
at EntityExpression.get_EntityMetadata() ilOffset = 0x0
at AttributeExpression.get_AttributeMetadata() ilOffset = 0x0
at PropertyExpressionFactory.GetAttributeTypeCode(AttributeExpression attribute) ilOffset = 0x3
at PropertyExpressionFactory.GetProperties(AttributeExpression attribute) ilOffset = 0x0
at FetchProcessor.InitializeEntityFields(XmlNode entityNode, EntityExpression parentEntityExpression, IList`1 reportFieldNames) ilOffset = 0x7A
at FetchProcessor.InitializeFields(XmlDocument fetchDocument) ilOffset = 0x37
at FetchProcessor..ctor(String fetchXml, ICrmDataParameterCollection parameters, IMetadataHelper metadataHelper) ilOffset = 0x6E
at FetchDataExtensionCommand.<ExecuteReader>b__0() ilOffset = 0x3D
at ExceptionManager.HandleUnsafeException(Func`1 body) ilOffset = 0x0
>System.Security.Authentication.AuthenticationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #17E2A3C0: System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32Exception: The target principal name is incorrect
> --- End of inner exception stack trace ---
> at System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
> at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
> at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
[2016-06-23 09:56:28.625] Process:ReportingServicesService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 71 |Category: Platform |User: 838822fd-d69d-e511-80b8-00155d001a01 |Level: Error |ReqId: 00000000-0000-0000-0000-000000000000 | ExceptionConverter.ConvertMessageAndErrorCode ilOffset = 0x222
at ExceptionConverter.ConvertMessageAndErrorCode(Exception exception, Int32& errorCode) ilOffset = 0x222
at ExceptionConverter.ToSingleFaultOther(Exception exception) ilOffset = 0x21
at ExceptionConverter.ConvertToFault(Exception exception) ilOffset = 0x54
at ExceptionConverter.TryConvertToFaultExceptionInternal(Exception exception, Boolean createNewFaultException, FaultException`1& faultException) ilOffset = 0x6D
at ExceptionConverter.TryConvertToFaultException(Exception exception, Boolean createNewFaultException, FaultException`1& faultException) ilOffset = 0x0
at InternalSandboxSdkClientManager.OnServerError(Object sender, ServerErrorEventArgs e) ilOffset = 0x7
at InternalSandboxSdkClient.Execute(SandboxSdkContext requestContext, String operation, Byte[] serializedRequest) ilOffset = 0x0
at SandboxFetchProxy.ExecuteInternal(SandboxSdkContext sdkContext, String requestName, Byte[] serializedRequest, IList`1 contactedServers) ilOffset = 0x0
at SandboxFetchProxy.Execute(OrganizationRequest request) ilOffset = 0xF
at SdkMetadataProvider.GetEntity(String name) ilOffset = 0x32
at MetadataHelper.GetEntity(String name) ilOffset = 0x0
at EntityExpression.get_EntityMetadata() ilOffset = 0x0
at AttributeExpression.get_AttributeMetadata() ilOffset = 0x0
at PropertyExpressionFactory.GetAttributeTypeCode(AttributeExpression attribute) ilOffset = 0x3
at PropertyExpressionFactory.GetProperties(AttributeExpression attribute) ilOffset = 0x0
at FetchProcessor.InitializeEntityFields(XmlNode entityNode, EntityExpression parentEntityExpression, IList`1 reportFieldNames) ilOffset = 0x7A
at FetchProcessor.InitializeFields(XmlDocument fetchDocument) ilOffset = 0x37
at FetchProcessor..ctor(String fetchXml, ICrmDataParameterCollection parameters, IMetadataHelper metadataHelper) ilOffset = 0x6E
at FetchDataExtensionCommand.<ExecuteReader>b__0() ilOffset = 0x3D
at ExceptionManager.HandleUnsafeException(Func`1 body) ilOffset = 0x0
>System.ComponentModel.Win32Exception: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #0EFFAE32: System.ComponentModel.Win32Exception (0x80004005): The target principal name is incorrect
[2016-06-23 09:56:28.625] Process:ReportingServicesService |Organization:007f112c-50b6-41c4-b415-76de1d88b3bf |Thread: 71 |Category: Reports |User: 838822fd-d69d-e511-80b8-00155d001a01 |Level: Error |ReqId: 00000000-0000-0000-0000-000000000000 | SdkMetadataProvider.GetEntity ilOffset = 0x32
at SdkMetadataProvider.GetEntity(String name) ilOffset = 0x32
at MetadataHelper.GetEntity(String name) ilOffset = 0x0
at EntityExpression.get_EntityMetadata() ilOffset = 0x0
at AttributeExpression.get_AttributeMetadata() ilOffset = 0x0
at PropertyExpressionFactory.GetAttributeTypeCode(AttributeExpression attribute) ilOffset = 0x3
at PropertyExpressionFactory.GetProperties(AttributeExpression attribute) ilOffset = 0x0
at FetchProcessor.InitializeEntityFields(XmlNode entityNode, EntityExpression parentEntityExpression, IList`1 reportFieldNames) ilOffset = 0x7A
at FetchProcessor.InitializeFields(XmlDocument fetchDocument) ilOffset = 0x37
at FetchProcessor..ctor(String fetchXml, ICrmDataParameterCollection parameters, IMetadataHelper metadataHelper) ilOffset = 0x6E
at FetchDataExtensionCommand.<ExecuteReader>b__0() ilOffset = 0x3D
at ExceptionManager.HandleUnsafeException(Func`1 body) ilOffset = 0x0
>Retrieving metadata for entity salesorderdetail failed.
[2016-06-23 09:56:28.625] Process:ReportingServicesService |Organization:007f112c-50b6-41c4-b415-76de1d88b3bf |Thread: 71 |Category: Exception |User: 838822fd-d69d-e511-80b8-00155d001a01 |Level: Error |ReqId: 00000000-0000-0000-0000-000000000000 | ExceptionManager.PrepareException ilOffset = 0x83
at ExceptionManager.PrepareException(Exception ex, Int32 errorCode, Object[] args) ilOffset = 0x83
at SdkMetadataProvider.GetEntity(String name) ilOffset = 0x32
at MetadataHelper.GetEntity(String name) ilOffset = 0x0
at EntityExpression.get_EntityMetadata() ilOffset = 0x0
at AttributeExpression.get_AttributeMetadata() ilOffset = 0x0
at PropertyExpressionFactory.GetAttributeTypeCode(AttributeExpression attribute) ilOffset = 0x3
at PropertyExpressionFactory.GetProperties(AttributeExpression attribute) ilOffset = 0x0
at FetchProcessor.InitializeEntityFields(XmlNode entityNode, EntityExpression parentEntityExpression, IList`1 reportFieldNames) ilOffset = 0x7A
at FetchProcessor.InitializeFields(XmlDocument fetchDocument) ilOffset = 0x37
at FetchProcessor..ctor(String fetchXml, ICrmDataParameterCollection parameters, IMetadataHelper metadataHelper) ilOffset = 0x6E
at FetchDataExtensionCommand.<ExecuteReader>b__0() ilOffset = 0x3D
at ExceptionManager.HandleUnsafeException(Func`1 body) ilOffset = 0x0
>Crm Exception: Message: An unexpected error occurred., ErrorCode: -2147220970, InnerException: System.ServiceModel.Security.SecurityNegotiationException: A call to SSPI failed, see inner exception. ---> System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32Exception: The target principal name is incorrect
--- End of inner exception stack trace ---
at System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
at System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
--- End of inner exception stack trace ---
Server stack trace:
at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
at System.ServiceModel.Channels.StreamSecurityUpgradeInitiatorBase.InitiateUpgrade(Stream stream)
at System.ServiceModel.Channels.ConnectionUpgradeHelper.InitiateUpgrade(StreamUpgradeInitiator upgradeInitiator, IConnection& connection, ClientFramingDecoder decoder, IDefaultCommunicationTimeouts defaultTimeouts, TimeoutHelper& timeoutHelper)
at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper)
at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper)
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.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at System.ServiceModel.ICommunicationObject.Open()
at Microsoft.Crm.Sandbox.SandboxClientBase`1.Open()
at Microsoft.Crm.Sandbox.SandboxClientBase`1.get_Proxy()
at Microsoft.Crm.Sandbox.InternalSandboxSdkClient.Execute(SandboxSdkContext requestContext, String operation, Byte[] serializedRequest)
at Microsoft.Crm.Sandbox.SandboxFetchProxy.ExecuteInternal(SandboxSdkContext sdkContext, String requestName, Byte[] serializedRequest, IList`1 contactedServers)
at Microsoft.Crm.Sandbox.SandboxFetchProxy.Execute(OrganizationRequest request)
at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.SdkMetadataProvider.GetEntity(String name)
[2016-06-23 09:56:28.625] Process:ReportingServicesService |Organization:007f112c-50b6-41c4-b415-76de1d88b3bf |Thread: 71 |Category: Reports |User: 838822fd-d69d-e511-80b8-00155d001a01 |Level: Error |ReqId: 00000000-0000-0000-0000-000000000000 | SdkMetadataProvider.GetEntity ilOffset = 0x32
at SdkMetadataProvider.GetEntity(String name) ilOffset = 0x32
at MetadataHelper.GetEntity(String name) ilOffset = 0x0
at EntityExpression.get_EntityMetadata() ilOffset = 0x0
at AttributeExpression.get_AttributeMetadata() ilOffset = 0x0
at PropertyExpressionFactory.GetAttributeTypeCode(AttributeExpression attribute) ilOffset = 0x3
at PropertyExpressionFactory.GetProperties(AttributeExpression attribute) ilOffset = 0x0
at FetchProcessor.InitializeEntityFields(XmlNode entityNode, EntityExpression parentEntityExpression, IList`1 reportFieldNames) ilOffset = 0x7A
at FetchProcessor.InitializeFields(XmlDocument fetchDocument) ilOffset = 0x37
at FetchProcessor..ctor(String fetchXml, ICrmDataParameterCollection parameters, IMetadataHelper metadataHelper) ilOffset = 0x6E
at FetchDataExtensionCommand.<ExecuteReader>b__0() ilOffset = 0x3D
at ExceptionManager.HandleUnsafeException(Func`1 body) ilOffset = 0x0
>Unhandled Exception: Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
>Microsoft.Crm.CrmException: An unexpected error occurred.
>System.ServiceModel.Security.SecurityNegotiationException: A call to SSPI failed, see inner exception.
>System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception.
>System.ComponentModel.Win32Exception: The target principal name is incorrect
>
>Inner Exception: Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred.
>
>Inner Exception: Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception.
>
>Server stack trace:
> at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
> at System.ServiceModel.Channels.StreamSecurityUpgradeInitiatorBase.InitiateUpgrade(Stream stream)
> at System.ServiceModel.Channels.ConnectionUpgradeHelper.InitiateUpgrade(StreamUpgradeInitiator upgradeInitiator, IConnection& connection, ClientFramingDecoder decoder, IDefaultCommunicationTimeouts defaultTimeouts, TimeoutHelper& timeoutHelper)
> at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper)
> at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper)
> 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.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
> at System.ServiceModel.ICommunicationObject.Open()
> at Microsoft.Crm.Sandbox.SandboxClientBase`1.Open()
> at Microsoft.Crm.Sandbox.SandboxClientBase`1.get_Proxy()
> at Microsoft.Crm.Sandbox.InternalSandboxSdkClient.Execute(SandboxSdkContext requestContext, String operation, Byte[] serializedRequest)
> at Microsoft.Crm.Sandbox.SandboxFetchProxy.ExecuteInternal(SandboxSdkContext sdkContext, String requestName, Byte[] serializedRequest, IList`1 contactedServers)
> at Microsoft.Crm.Sandbox.SandboxFetchProxy.Execute(OrganizationRequest request)
> at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.SdkMetadataProvider.GetEntity(String name)
>Inner Exception: Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception.
> at System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
> at System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
> at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
> at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
>Inner Exception: Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The target principal name is incorrect
>Thursday, June 23, 2016 5:27 PM
Answers
-
This does indeed point to a SPN issue. The issue was a CRMFetch spn. The solution as outlined in this support article https://support.microsoft.com/en-us/kb/2590774 is as follows:
a. On the SRS Server:Create a string registry key under the hive of under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM for SandboxClientSpn.<CRMServerName> with <CRMServerName> being the name of the CRM server As a value add the regarding FetchXML SPN: HTTP/CRMfetch(<CRMSERVERNAME>)
b. Add SPNs to match what was entered above HTTP/CRMfetch(<CRMSERVERNAME>)
E.g. you could achieve this in command line prompt executing setspn. In this example The CRM Server Name is CRM1 and the Application Pool that is running the CRM Service is MyCRM\CRMServiceAccount
Setspn –A HTTP/CRMFetch(CRM1) MyCRM\CRMServiceAccount- Marked as answer by mosbySE Thursday, June 23, 2016 10:50 PM
Thursday, June 23, 2016 10:50 PM