{"id":2122,"date":"2015-12-08T10:37:07","date_gmt":"2015-12-08T05:07:07","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=2122"},"modified":"2022-09-02T16:42:17","modified_gmt":"2022-09-02T11:12:17","slug":"rsprocessingaborted-error-for-dynamics-crm-custom-reports","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2015\/12\/rsprocessingaborted-error-for-dynamics-crm-custom-reports\/","title":{"rendered":"RsProcessingAborted Error for Dynamics CRM Custom Reports"},"content":{"rendered":"

Introduction:<\/strong><\/p>\n

We developed a custom SSRS report that is working just fine on the dev environment, which is a single box with CRM and SQL installed on the same machine. But when it was moved to production where CRM is installed on a separate box than the SQL server, it would not work and simple throw the \u201crsProcessingAborted\u201d error as shown below.\"RsProcessing<\/a><\/p>\n

All OOB report were working\u00a0 just fine and it was showing this error for any custom report deployed on this CRM.<\/p>\n

Resolution:<\/strong><\/p>\n

Looking at this error we did not get the exact cause of this issue. One of the solutions that worked previously is to open the 808 port, another is to ensure the fields referred in the query exist in the specified entity. But both of these were just fine in this case. To check the exact error look for the look files which can usually be found at the following location<\/p>\n

<SQL INSTALLDIR>\\MSRS11.MSSQLSERVER\\Reporting Services\\LogFiles.\"RsProcessingAborted<\/a><\/em><\/p>\n

When we checked the error log file and found the exact error. We are getting following error in log file.<\/p>\n

To resolve this issue you need to run SETSPN command. Below is syntax for this command.<\/p>\n

setspn \u2013a HTTP\/NETBIOSNAME DOMAIN\\SERVICEACCOUNT<\/strong><\/p>\n

    \n
  1. NETBIOSNAME: You will get this name from IIS where your CRM is running as shown in below screenshot.\"RsProcessing<\/a><\/li>\n<\/ol>\n
      \n
    1. SERVICEACCOUNT: Use account under which CRMAppPool is running.\"RsProcessing<\/a><\/li>\n<\/ol>\n

      Here is our final command that we run from command prompt.<\/p>\n

      setspn \u2013a HTTP\/AD7\u00a0 adventure7\\administrator <\/strong><\/p>\n

      Once we execute the command then after our issue is resolved and we able to run the custom report successfully.<\/p>\n

      Conclusion:<\/strong><\/p>\n

      To resolve the rsProcessingAborted \u00a0issue of custom reports, look into the log files to find out the actual error message. Most often than not, especially if SQL Server and CRM Server are 2 different servers you need to Kerberos by using the setspn command.<\/p>\n

      Generate Your Own New Leads Within Microsoft Dynamics 365 CRM<\/div><\/div><\/h2>\n

      Contact us for a demo<\/a> to know more about how Maplytics<\/a> can help you to generate new leads from within Microsoft Dynamics 365 CRM.<\/em><\/p>\n

      Maplytics<\/a> is a 5-star rated, preferred business app on the Microsoft AppSource<\/a> that is Certified for Microsoft Dynamics 365 (CfMD) and comes with powerful features like Appointment Planning, Sales Routing, Territory Management, Heat Maps, Geo-analytical Dashboards and more that empower organizations to add more value to their CRM data, improve sales & service processes, and achieve high ROI.<\/em><\/p>\n

      Get your free trial<\/a> from our Website or Microsoft AppSource<\/a>!<\/em><\/p>\n

      ‘If data is the new oil, location intelligence is ??\u201d<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

      Introduction: We developed a custom SSRS report that is working just fine on the dev environment, which is a single box with CRM and SQL installed on the same machine. But when it was moved to production where CRM is installed on a separate box than the SQL server, it would not work and simple\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[19,58],"tags":[1512],"class_list":["post-2122","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-ssrs-reports","tag-rsprocessingaborted-error"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/2122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=2122"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/2122\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=2122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=2122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}