locked
I receive an error when I want to get a report in CRM 4.0 RRS feed

  • Question

  • I use MS Dynamic CRM 4.0 Pro. I am not able to get any report remotely, however, the reporting features works well on the Server. Windows 2003 logs the following error in the Event Viewer.

    Event Type: Warning
    Event Source: ASP.NET 2.0.50727.0
    Event Category: Web Event
    Event ID: 1309
    Date:  6/13/2009
    Time:  2:25:31 PM
    User:  N/A
    Computer: SVR01
    Description:
    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 6/13/2009 2:25:31 PM
    Event time (UTC): 6/13/2009 10:55:31 AM
    Event ID: fc21fe4cd31441ea89b644d36721a5d6
    Event sequence: 4313
    Event occurrence: 20
    Event detail code: 0
     
    Application information:
        Application domain: /LM/W3SVC/1/ROOT-1-128893444133362428
        Trust level: Full
        Application Virtual Path: /
        Application Path: c:\inetpub\wwwroot\
        Machine name: SVR01
     
    Process information:
        Process ID: 884
        Process name: w3wp.exe
        Account name: NT AUTHORITY\NETWORK SERVICE
     
    Exception information:
        Exception type: CrmException
        Exception message: An error occurred during report rendering.
     
    Request information:
        Request URL: http://crm.aminsanat.com/ASC/CRMReports/rsviewer/reportviewer.aspx
        Request path: /ASC/CRMReports/rsviewer/reportviewer.aspx
        User host address: 192.168.1.111
        User: AMINSANAT\mohammad.dolabi
        Is authenticated: True
        Authentication Type: Negotiate
        Thread account name: NT AUTHORITY\NETWORK SERVICE
     
    Thread information:
        Thread ID: 7
        Thread account name: NT AUTHORITY\NETWORK SERVICE
        Is impersonating: False
        Stack trace:    at Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     
     
    Custom event details:

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    -----------------------------
    -----------------------------
    Event Type: Error
    Event Source: MSCRMReporting
    Event Category: None
    Event ID: 19970
    Date:  6/13/2009
    Time:  2:25:31 PM
    User:  N/A
    Computer: SVR01
    Description:
    Report render failure. Error: The 'CRM_FormatDate' parameter is missing a value

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Saturday, June 13, 2009 10:03 AM

Answers

  • If you haven't already, install the SRS data connector on your reporting server.  This will probably fix it--it fixes most authentication issues runnig reports.

    the install files for the srs connector are part of the CRM install files.  There are also rollup updates for srs connector.  You should run whichever srs connector rollup as you are for crm.
    Sunday, June 14, 2009 12:39 AM
    Moderator