Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 Restore of Database into new Org and new Server but Reports are not working RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hey guys,

    I did the standard creation of a new org on new server from our old Dev box into our new Dev box. Everything works except the reports. Every report does not work, new reports, out of the box reports, and custom reports. I checked the url of the report server and it is pointing to the proper server and the reports are there as well. The report server config url works as well. When you click on the report is says:

    "Reporting Error"

    "The report cannot be displayed. (rsProcessingAborted)"

    I checked the event logs of CRM and I see:

    "An error has occured during report processing. (rsProcessingAborted) w3wp

    C:\Program Files\Microsoft Dynamics CRM\CRMWeb\"

    I checked the event log of the CRMSql box and I see no error. I also looked at the permissions of a user named crmadmin on the sql server database and I copied the permissions to be the same as the old box. I looked around on the web and I saw a couple of posts about setting the SPN but I'm not sure if that applies in my case. All of the sql services are started and the configuration of the sql box seems correct in sql configuration window. So basically the question is...Is there anything else that I need to do after restoring an organization from a backup to get the reports to work? Or is there any place that I could look that would give me more specific errors? Any ideas?

    Thanks in Advance


    Friday, September 13, 2013 3:29 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Can you check if any of the solutions listed in these blogs help

    http://inogic.blogspot.in/2012/05/solutions-to-issues-with-reports-in.html

    http://inogic.blogspot.in/2012/05/reports-not-working-after-upgrade-to.html

    HTH

    Sam

    Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    • Proposed as answer by Sam - Inogic Friday, September 13, 2013 5:54 AM
    • Marked as answer by Bill Blancett Monday, September 16, 2013 11:10 PM
    Friday, September 13, 2013 5:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you Sam,

    I asked for either the solution or a way to find out what the error was and you presented a couple of ways to find the more specifice errors, Thanks! I basically ended up looking in the SQL Reporting Services log files located in the sql reporting services folder on the box that has sql installed. From here I was able to see the more specific error which was "The
    requested value 'Geo' was not found". This led me to google for the issue and what I found out was that this was related to the SQL server reporting extension that you have to install with CRM. I installed the original SRSDataConnector from the original media and this version will conflict with the later version that is on the latest CRM installation media on the web http://www.microsoft.com/en-us/download/details.aspx?id=27822 and is used in the subsequent rollups. So I downloaded the latest version of CRM 2011 and then I went into the installation media folder and found the SRSDataConnector folder and redid the installation from here. It prompts you to uninstall or repair and I chose to repair. This then fixed my reports.

    Thanks,

    Bill

    Thanks in Advance

    • Marked as answer by Bill Blancett Monday, September 16, 2013 11:19 PM
    Monday, September 16, 2013 11:19 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Can you check if any of the solutions listed in these blogs help

    http://inogic.blogspot.in/2012/05/solutions-to-issues-with-reports-in.html

    http://inogic.blogspot.in/2012/05/reports-not-working-after-upgrade-to.html

    HTH

    Sam

    Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    • Proposed as answer by Sam - Inogic Friday, September 13, 2013 5:54 AM
    • Marked as answer by Bill Blancett Monday, September 16, 2013 11:10 PM
    Friday, September 13, 2013 5:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you Sam,

    I asked for either the solution or a way to find out what the error was and you presented a couple of ways to find the more specifice errors, Thanks! I basically ended up looking in the SQL Reporting Services log files located in the sql reporting services folder on the box that has sql installed. From here I was able to see the more specific error which was "The
    requested value 'Geo' was not found". This led me to google for the issue and what I found out was that this was related to the SQL server reporting extension that you have to install with CRM. I installed the original SRSDataConnector from the original media and this version will conflict with the later version that is on the latest CRM installation media on the web http://www.microsoft.com/en-us/download/details.aspx?id=27822 and is used in the subsequent rollups. So I downloaded the latest version of CRM 2011 and then I went into the installation media folder and found the SRSDataConnector folder and redid the installation from here. It prompts you to uninstall or repair and I chose to repair. This then fixed my reports.

    Thanks,

    Bill

    Thanks in Advance

    • Marked as answer by Bill Blancett Monday, September 16, 2013 11:19 PM
    Monday, September 16, 2013 11:19 PM