On Premise CRM2013 Custom Reports Reporting Error (rsProcessingAborted) Error

(0) Share

Report

Posted on by PCR985

Hello,

We converted a CRM2011 system to CRM2013 recently, and then implemented IFD/ADFS. Everything ran fine in CRM2011. After we converted the organizations, all custom reports did not run. Out of the box reports continues to run.

The error we see is "Reporting Error: The report cannot be displayed. (rsProcessingAborted)"

The CRM2013 is running a a separate server than the Database and SSRS. All other SSRS reports are running fine.

Any comments, suggestions or assistance is greatly appreciated.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Deepesh161 6,317 on at

Like (0)

Report
Copy link

Link copied!

One out of the two links always resolved this issue for me in past:

blog.simpletrees.com/.../mscrm-and-dreaded-rsprocessingaborted.html

blogs.msdn.com/.../configuring-service-principal-names.aspx

Was this reply helpful? Yes No
PCR985 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the quick reply.

Unfortunately I was not able to link through to either link you provided. Can you please re-post the links?

Thanks!

Was this reply helpful? Yes No
Suggested answer

Deepesh161 6,317 on at

Like (0)

Report
Copy link

Link copied!

One out of the two links always resolved this issue for me in past:

blog.simpletrees.com/.../mscrm-and-dreaded-rsprocessingaborted.html

blogs.msdn.com/.../configuring-service-principal-names.aspx

Was this reply helpful? Yes No
Arpita Saini Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi PCR985,

Please follow below steps and it should fix the issue:-

1) Checked what is the account running CRM app pool in IIS. If you have a custom account running it then go ahead with below steps.

2) Add below SPNs

setspn -a http/<crmservername> <domainname/crmapppoolaccount>

setspn -a http/<crmservername>.FQDN <domainname/crmapppoolaccount>

3) Then run below steps on CRM server to set UseAppPool Credentials to true

Set the IIS useAppPoolCredentials value to True

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.

Navigate to %windir%\system32\inetsrv.

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

Was this reply helpful? Yes No
Naveen Dasari 275 on at

Like (0)

Report
Copy link

Link copied!

Hi,

are you using the sql query directly on crm tables ? if using then change them to filtered views then try . due to sequrity reason this won't work if using sql table in other servers.

Thanks

Naveen Dasari

Was this reply helpful? Yes No
PCR985 on at

Like (0)

Report
Copy link

Link copied!

All of the custom reports were created and deployed with the CRM Report Wizard. So should be using the Fetch XML Data Source.

Was this reply helpful? Yes No
matthew.mickas 505 on at

Like (0)

Report
Copy link

Link copied!

Also make sure both servers are on the same UR.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Arpita Saini!

Thank you very much for share your knowledge. Your information work very well for me.

Was this reply helpful? Yes No