web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Problem with viewing c...
Microsoft Dynamics CRM (Archived)

Problem with viewing custom report on CRM web

(0) ShareShare
ReportReport
Posted on by Hasibur Rahman

Hello,

I have created a simple fetchxml report in VS studio 2008 (BID).

Here is my query

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="account">
    <attribute name="name" />
    <attribute name="primarycontactid" />
    <attribute name="tsi_primary_address" />
    <attribute name="tsi_preferred_language" />
    <attribute name="accountnumber" />
    <attribute name="accountid" />
    <order attribute="name" descending="false" />
    <filter type="and">
      <condition attribute="name" operator="like" value="%Hasi%" />
    </filter>
    <link-entity name="tsi_address" from="tsi_addressid" to="tsi_primary_address" visible="false" link-type="outer" alias="a_ef34aaab9982e311a1d600155d2d1858">
      <attribute name="createdonbehalfby" />
    </link-entity>
  </entity>
</fetch>

So, basically get all customer name with the name "Hasi" in it. It works fine in the in the preview panel of visual studio

I uploaded the report to CRM successfully. But when I go to look at it by double clicking on it - I get the following error

But if I right click on the report and open it in a new window I get the following

Please kindly help.

Thanks,

Hasib

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Hasibur Rahman Profile Picture
    Hasibur Rahman on at

    Sorry - looks like my images did not get pasted properly. I will type the error message.

    When I double click on the report  the error message that I get is

    "The report can not be displayed. (rsProcessingAborted)

    When I right click on the report and open it in a new window I get a window that says

    "This report can not have a default filter"

    Let me know if you have any confusions

  • Deeps Profile Picture
    Deeps 1,875 on at

    If it is CRM On-Premise then check Reporting Services log on Report server to get more detailed error.

  • Verified answer
    DH kumar CRM Profile Picture
    DH kumar CRM 1,345 on at

    Hi,

    This post has resolution steps mentioned to fix this issue - ashwaniashwin.wordpress.com/.../crm-2011-reporting-error-the-report-cannot-be-displayed-rsprocessingaborted

    Hope this helps...

  • Arpita Saini Profile Picture
    Arpita Saini on at

    -The error you mentioned here is a generic error that can come due to any issue in the backend.

    -You need to get the CRM plat trace or best re-create teh error and then log in to SSRS server ---> C:\Program Files\Microsoft SQL Server\MSSQL.<#>\Reporting Services\LogFiles----> get the latest log file --> open it---> scroll to the bottom---> send us the error here...

    -Next check the event viewer of crm server and ssrs server

    The errors will help us oit to give you action plan.

    -next go to CRM create a simple report using report wizard --> if that fails with same error this means we need to fix issue on server which can be a permission issue or any other issue

    -Next run the report directly from reports manager URL--> see what error you get(remember Username is SystemUserId and Password is OrganizationId that you can get from systemuserbase table in org databse)

  • Arpita Saini Profile Picture
    Arpita Saini on at

    o Verify the account running the Report Server service has the has the CRM Reader Role , Public and db_owner on MSCRM_CONFIG and ORG_MSCRM database and Public and RSExec roles on the MSDB, MASTER, ReportServer, and ReportServerTempDB databases.

  • Verified answer
    Hasibur Rahman Profile Picture
    Hasibur Rahman on at

    Hey Guys,

    Thanks for your replies. I cross checked all the db permission  - all of them are in place. When I look at the log file -> I see the following error

    library!ReportServer_0-1!1200!09/19/2014-10:04:02:: i INFO: RenderForNewSession('/DevCRM_MSCRM/CustomReports/{D4B081DA-6D3F-E411-93F3-00155D2D75C6}')

    processing!ReportServer_0-1!1200!09/19/2014-10:04:02:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> 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 ---> 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.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)

      at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)

  • DH kumar CRM Profile Picture
    DH kumar CRM 1,345 on at

    Hi,

    Try this article which will help you to resolve this issue. support.microsoft.com/.../2590774

    www.mohamedibrahim.net/.../msdyncrm-rsprocessingaborted-error-fix-setting-up-service-principal-names-spn-values-for-microsoft-dynamics-crm-crm2013-service-accounts-when-reports-created-by-report-wizard-fail-during-execution

    Hope this helps...

  • Suggested answer
    Arpita Saini Profile Picture
    Arpita Saini on at

    Looking at the error message from SSRS it is confirmed that issue is coming due to incorrect SPN. Especially we are missing two SPNs on CRM app pool:-

    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

    If you are not aware how to find which all SPNs are required. Please see below, I'm taking example here you can match it in your deployment :-

    CRM App Pool Name :- contoso\crmsvc

    CRMServerName:- CRMTest

    FQDN: abc.com

    Run below commands on any server with a user who has access on AD.

    setspn -l contoso\crmsvc

    This will list all SPNs already set. We need below two SPNS, if any of these are missing please add them.

    http/CRMTest

    http/CRMTest.abc.com

    command for the same:-

    setspn -a http/CRMTest contoso\crmsvc

    setspn -a http/CRMTest.abc.com contoso\crmsvc

    After setting SPNs please run below command of CRM server(if it is in NLB , then run it on both nodes):-

    Set the IIS useAppPoolCredentials value to True

    ----------------------------------------------------------------

    1. Open an elevated command prompt window. To open an elevated Command Prompt window, click Start, point to All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.

    2. Navigate to %windir%\system32\inetsrv.

    3. Type appcmd.exe set config -section:system.webServer/security/authentication/windowsAuthentication -useAppPoolCredentials:true

    technet.microsoft.com/.../dd759186.aspx

  • Verified answer
    Hasibur Rahman Profile Picture
    Hasibur Rahman on at

    The problem is when run the following command

    setspn -a HTTP/crmdevasync1 DEV\CRMDEVSVC

    I get the following error

    Registering ServicePrincipalNames for CN=crmdev svc,CN=Users,DC=dev,DC=teksavvy,

    DC=ca

           HTTP/crmdevasync1

    Failed to assign SPN on account 'CN=crmdev svc,CN=Users,DC=dev,DC=teksavvy,DC=ca

    ', error 0x2098/8344 -> Insufficient access rights to perform the operation.

  • Verified answer
    Hasibur Rahman Profile Picture
    Hasibur Rahman on at

    Arpita Saini ,

    Thanks for your reply.

    In our setting we have 2 front and 2 backend server. Could you kindly tell me - where would apply the instructions (for SPN problem) you mentioned in your previous message.

    Thanks,

    Hasib

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans