locked
CRM Reporting issues RRS feed

  • Question

  • My CRM 4 deployment is as follows:
    1.) CRM Server 4.0 - Server 2008 x64  ( CRMhost01)
    ----Service account used for initial install was Network Service, changed after to domain\CrmService (web app account) and all changed made to support 2008.
    2.) SQL Server (database) - SQL server 2008 Enterprise (SQLhost01)
    3.) Reporting Services Server - 2008 Installed on CRM server

    When opening the reports from in CRM using localhost the reports display without any issues, However if i open the reports from in crm using the hostname of the server it displays a reporting error.

    The event viewer is giving the following to errors.


    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 24/07/2009 10:34:48 AM
    Event time (UTC): 24/07/2009 12:34:48 AM
    Event ID: a61992b7506643c2a5852c19f8e804aa
    Event sequence: 10
    Event occurrence: 1
    Event detail code: 0
    Application information:
    Application domain: /LM/W3SVC/1/ROOT-3-128928681634157084
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\inetpub\wwwroot\
    Machine name: ERISCRM01
    Process information:
    Process ID: 3672
    Process name: w3wp.exe
    Account name: ERIS\crmservice
    Exception information:
    Exception type: CrmReportingException
    Exception message: An error has occurred during report processing. (rsProcessingAborted)
    Request information:
    Request URL: http://eriscrm01/erisdefault/CRMReports/rsviewer/reportviewer.aspx
    Request path: /erisdefault/CRMReports/rsviewer/reportviewer.aspx
    User host address: fe80::91bc:9637:d916:1b4eC:\inetpub\wwwroot\
    User: ERIS\Administrator
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: ERIS\crmservice
    Thread information:
    Thread ID: 3
    Thread account name: ERIS\crmservice
    Is impersonating: False
    Stack trace: at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
    at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


    And

    Event 19969
    MscrmReporting

    Web service request SetParameters to Report Server http://eriscrm01/ReportServer failed with SoapException. Error: An error has occurred during report processing. (rsProcessingAborted)



    Opening the reports server path http:\\eriscrm01\reportserver i am able to execute any reports. Reporting service was installed on the sql server to start off with however moved to the crm server to attempt to resolve this issue however has not changed anything.


    This site is also Public facing over ISA, and i am unable to open the reports there, receive the same error.

    Friday, July 24, 2009 12:42 AM

Answers

  • Did you install the SRSS Data Connector?  I have seen this help even when the Report Server and CRM are on the same server although it is not required.
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Monday, July 27, 2009 7:56 PM
    Monday, July 27, 2009 6:54 PM

All replies

  • Hi Braden,

    this looks like a DNS issue. Please check the dns resolution for the server and the domain.
    You can also check the entries for the serverin the CRM-Databse.
    Use the following SQL-Steatement on the CRM Server. There should be the same value in all three fields like "servername:port"
    If not, update the fields with the right servername and port

    SELECT Id, ColumnName, NvarCharColumn From DeploymentProperties
    WHERE ColumnName IN ('ADSdkRootDomain','ADWebApplicationRootDomain','AsyncSdkRootDomain')


    Viele Grüße

    Michael Sulz
    axcentro GmbH
    MVP für Microsoft Dynamics CRM
    Friday, July 24, 2009 12:20 PM
  • Thanks for that michael.

    I have managed to resolve the issue of reporting not opening on the local server using the FQDN of the server ( Port incorrect). However this has not resolved the problem, I still receive the error when attempting to open the reports on any other client or server.

    Any other ideas??

    Monday, July 27, 2009 2:57 AM
  • Hi Braden,

    have you check the dns resolution for the server?
    The easiest way to do is to use the tool dnslint from microsoft:
     

    http://support.microsoft.com/kb/321045/de


    Viele Grüße

    Michael Sulz
    axcentro GmbH
    MVP für Microsoft Dynamics CRM
    Monday, July 27, 2009 6:05 AM
  • i have Checked DNS and there doesnt appear to be any issues.

    The reports server opens without any issues using its DNS name, it seems the problem is just opening them within CRM.

    Monday, July 27, 2009 6:07 AM
  • it looks like a SPN issue to me.

    also start the report server configuration wizard and see under which account the services are running.
    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Monday, July 27, 2009 4:49 PM
  • Did you install the SRSS Data Connector?  I have seen this help even when the Report Server and CRM are on the same server although it is not required.
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Monday, July 27, 2009 7:56 PM
    Monday, July 27, 2009 6:54 PM
  • Hi braden,

    have you got any solution to your issue, i am facing same issue with same server setup.
    the error is inconsistent in my case.


    SKD
    Thursday, October 22, 2009 12:15 AM