locked
Wizard and custom Reports not rendering. RRS feed

  • 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