Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011: The report cannot be displayed. (rsProcessingAborted) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all,

    Suddenly I am facing the following problem

    Everytime I try to run any report, whether it's an OOB or custom report the following error occured:

    Reporting Error

    The report cannot be displayed. (rsProcessingAborted)

    I'm running CRM on premise with UR 8

    Please advise..

    Thanks and best regards..

    Wednesday, July 25, 2012 1:42 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    You should switch on trace, restart iis, reproduce an error and recheck logs. Hint regarding error that appeared should be inside logs.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Follow Andriy on Twitter

    Wednesday, July 25, 2012 1:48 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    The SSRS logs are probably going to provide you with the most detail on the issue.
    Wednesday, July 25, 2012 5:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The SSRS logs are probably going to provide you with the most detail on the issue.
    Please provide more details on how to to access these logs
    Wednesday, July 25, 2012 5:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    http://msdn.microsoft.com/en-us/library/ms156500(v=sql.105).aspx

    • Edited by Ken Heiman Wednesday, July 25, 2012 8:32 PM
    Wednesday, July 25, 2012 8:30 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Go to Event viewer in the server and in that you can find the details about the error in Windows Logs -> application tab.

    and check the report server is started and running if not start the report server then try running the reports.

    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Thursday, July 26, 2012 8:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Go to Event viewer in the server and in that you can find the details about the error in Windows Logs -> application tab.

    and check the report server is started and running if not start the report server then try running the reports.

    I have checked the event viewer. and the error detaisl are as follow:

    - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="MSCRMReporting" /> 
  <EventID Qualifiers="49152">19970</EventID> 
  <Level>2</Level> 
  <Task>0</Task> 
  <Keywords>0x80000000000000</Keywords> 
  <TimeCreated SystemTime="2012-07-26T09:08:22.000000000Z" /> 
  <EventRecordID>8877292</EventRecordID> 
  <Channel>Application</Channel> 
  <Computer>CRM.intercom.com.eg</Computer> 
  <Security /> 
  </System>
- <EventData>
  <Data>An error has occurred during report processing. (rsProcessingAborted)</Data> 
  <Data>w3wp</Data> 
  <Data>C:\Program Files\Microsoft Dynamics CRM\CRMWeb\</Data> 
  </EventData>
  </Event>

    Thursday, July 26, 2012 9:14 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Pls check if your reporting services and report server are started and running. if not then start the reportserver.

    Go to Start and search for "reporting services configuration manager",

    and connect to your report server and check if its started.

    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Thursday, July 26, 2012 9:19 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Pls check if your reporting services and report server are started and running. if not then start the reportserver.

    Go to Start and search for "reporting services configuration manager",

    and connect to your report server and check if its started.

    The report server is already started, I have stopped it and restart it again with no luck
    Thursday, July 26, 2012 9:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Then i think we have to take a look at the SQL server logs for details. see the server logs to find the error details. you can find that in programfiles-> microsoft sql server-> your instance of the ser server -> logs.

    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Thursday, July 26, 2012 9:33 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear all,

    Happy to announce that the problem has been finally solved using this very useful post:

    http://nishantrana.wordpress.com/2011/05/26/reporting-error-report-cannot-be-displayed-rsprocessingaborted/

    Regards

    Thursday, July 26, 2012 10:08 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear all,

    Currently I'm facing the same error again but with a specific user

    Please advise, there is an urgent need for reports so fast response will be appreciated

    I believe that it's an access rights problem as when the user is logged in as administrator, he could run the report

    Thanks

    Wednesday, August 1, 2012 11:44 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Tthe User running the report should have the read access to the database from which the reports are fetched also the user should be in the ReportingGroup in sql server and PrivReportingGroup and also make sure that these two groups have access to the datasource that being used in that report. since administrator has access to all the database and is a member of all the groups he dont need it.

    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Wednesday, August 1, 2012 12:58 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Please explain how to be sure of the above
    Wednesday, August 1, 2012 1:14 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Do the same steps which you  did above

    Start SQL Server Management Studio

    1.Expand Security, then expand Logins

    2.Select and right click the domainname\PrivReportingGroup {ad4075d5-35a8-4c8f-9995-1e5d27973e51},CRMTESTING\ReportingGroup {ad4075d5-35a8-4c8f-9995-1e5d27973e51},CRMTESTING\SQLAccessGroup {ad4075d5-35a8-4c8f-9995-1e5d27973e51},                                                      Select User Mapping and select YouOrg_MSCRM database and specify following role membership

       CRMReaderRole,   public, db_owner.


    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Thursday, August 2, 2012 6:10 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    unfortunately the above did not solve the problem, however I have created a new security role by copying the system administrator role and removing privileges from the unwanted entities.

    I can say that the problem belongs to the customizations tab, as the role was copied from a system administrator this tab is completely filled, and I don't need all these permissions for the new role, but once I try to modify them the above error ocurred

    Please advise..

    Thursday, August 2, 2012 10:24 AM