Microsoft Dynamics CRM (Archived)

the report cannot be displayed (rsprocessingaborted)

(0) Share

Report

Posted on by suresh p

1,320

Error: the report cannot be displayed (rsprocessingaborted).

How to solve this?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

suresh p 1,320 on at

Like (3)

Report
Copy link

Link copied!
To resolve this issue I had to follow these steps

Start SQL Server Management Studio

Expand Security, then expand Logins

Select and right click the account under which the SQL Server Reporting Services is running.

Select User Mapping and select YouOrg_MSCRM database and specify following role membership

CRMReaderRole,

db_owner

public.

Was this reply helpful? Yes No
suresh p 1,320 on at

Like (0)

Report
Copy link

Link copied!

setspn –a HTTP/crm Domain\User

setspn –a HTTP/crm.server.com Domain\User

Was this reply helpful? Yes No
Verified answer

suresh p 1,320 on at

Like (0)

Report
Copy link

Link copied!

See this link

http://cognettacloud.com/?p=97

Was this reply helpful? Yes No
Mohammad Atif on at

Like (0)

Report
Copy link

Link copied!

Error: the report cannot be displayed (rsprocessingaborted). is very generic , good to know that you are able to resolve the issue. I would say the best approach is to check if the reports are running from the report server or not. if not, after running the report form the report Manager(any CRM OOB) when it fail see the report logs and if this is due to the SPN or permission you will get clear error message there

When SPN is the cause of the report failure :support.microsoft.com/.../2590774.

Thanks,

Mohammad

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi,

check Permissions, check if your query gets from 'filtered' veiw.

check event viewer - message on server where crm installed

and not

Was this reply helpful? Yes No
TimZ on at

Like (0)

Report
Copy link

Link copied!

Hi,

I also needed to set these same permissions (CRMReaderRole, db_owner, public) on my 'MSCRM_Config' database for the account under which the SQL Server Reporting Service is running. That is the only way I could get this to work.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

In the few times I've seen this it's been an SPN issue (or lack thereof) especially when you're using domain accounts. See this link:

www.cognettacloud.com/.../fixing-reporting-issues-with-crm-2011

Was this reply helpful? Yes No
MohankumarJ 10 on at

Like (0)

Report
Copy link

Link copied!

Reason can be that the Report is not mapped with appropriate DataSource

Was this reply helpful? Yes No
Seenivasan M 307 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am getting this same error .but, the link which you have provided is not available. please share me the link or solution for this issue if you have it.

Thanks in advance.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Check your all queries inside query designer, there must be some wrong attribute value assigning

Was this reply helpful? Yes No