locked
CRM Fetch XML is not working OOB on 2016 on premise RRS feed

  • Question

  • I am creating out of box XML report on crm, but it is showing an error. " The report cannot be displayed. (rsProcessingAborted)"

    We have 3 different servers for application, DB and Report Server. We are using SSL. Earlier SPN was register under service account on which app pool is runing on application server but still we were not able to access the report. Now we have changed SPN setttings and it is configured for SSRS service account user but still we are having same issue.  

    Friday, September 1, 2017 12:12 PM

All replies

  • Hi, 

    I think that this link could help you : https://community.dynamics.com/crm/f/117/t/108705

    Kr, 

    Moh

    Friday, September 1, 2017 12:25 PM
  • The first thing to check is the reporting services log files. This should give some more information on the issue.

    Also, is the issue specific to one report, or does it apply to all reports ?

    If some reports work, but others don't, is there a common theme ? e.g. it could be that all FetchXml reports don't work, whereas SQL reports do work, or vice versa


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, September 1, 2017 1:25 PM
    Moderator
  • This issue is to all Fetch XML report only, and I have check log and I found below errors...

    webserver!ReportServer_0-7!740!09/05/2017-16:39:27:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: レポートの処理中にエラーが発生しました。 ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: レポートの処理中にエラーが発生しました。 ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: データ ソース 'CRM' への接続を作成できません。 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: 
    Microsoft.Crm.CrmConfigObjectNotFoundException: User Was Not Found ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: User Was Not Found
       at Microsoft.Crm.ServerLocatorService.GetCrmUserId(Guid organizationId, String authenticationInfo)
       at Microsoft.Crm.LocatorService.GetCrmUserId(Guid organizationId, String authenticationInfo)
       at Microsoft.Crm.Core.DataServices.Configuration.ConfigProviders.LocatorServiceUserInfoProvider.GetCrmUserId(Guid organizationId, String authenticationInfo)
       at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.Initialize(SecurityIdentifier user)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
       at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
       at Microsoft.Crm.ServerLocatorService.GetCrmUserId(Guid organizationId, String authenticationInfo)
       at Microsoft.Crm.LocatorService.GetCrmUserId(Guid organizationId, String authenticationInfo)
       at Microsoft.Crm.Core.DataServices.Configuration.ConfigProviders.LocatorServiceUserInfoProvider.GetCrmUserId(Guid organizationId, String authenticationInfo)
       at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.Initialize(SecurityIdentifier user)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
       at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
       at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbConnectionExtension.Open(String userSid)
       at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtConnectionBase.Open()
       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenConnection(IProcessingDataSource dataSourceObj, DataSourceInfo dataSourceInfo, IDbConnection conn)
       --- End of inner exception stack trace ---
       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenConnection(IProcessingDataSource dataSourceObj, DataSourceInfo dataSourceInfo, IDbConnection conn)
       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.HandleImpersonation(IProcessingDataSource dataSource, DataSourceInfo dataSourceInfo, String datasetName, IDbConnection connection, Action afterImpersonationAction)
       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataS

    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 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: 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.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessReceivedBlob(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)
       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.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessRe


    • Edited by Sarang L Tuesday, September 5, 2017 7:42 AM
    Tuesday, September 5, 2017 7:41 AM