locked
Rendered SSRS report exipres after a short time when running from CRM 4 RRS feed

  • Question

  • Hi folks,

    I have crm 4 and SSRS 2008 R2 report which I upload and run from CRM 4.

    I generate my report from CRM Report area without any issue but,  If I do not navigate within the report for a little while, once I try to do it

    I get an error saying 'The report can Not be dipslayed!....

    I have to run the report again and regenerate it at that point. It seems to me that it kind of exipres after a very short time.

    Please note once I run this report from the Business Inteligence Studio I do not encounter this report.

    It seems to me that it should be a kind of setting or something on the CRM server to increase this time? Or maybe someone else has a better idea.

    Below are the realted errors and warning I found on event viewer of my application server.

    Error:

    Report render failure. Error: Page navigation is out of range

    from the event viewer on CRM 4 application server

    Warning:

    Event code: 3005

    Event message: An unhandled exception has occurred.

    Event time: 11/4/2013 4:24:23 PM

    Event time (UTC): 11/4/2013 11:24:23 PM

    Event ID: 5eb5a41a2dfb4805b67b7980eab8bc69

    Event sequence: 6278

    Event occurrence: 75

    Event detail code: 0

    Application information:

        Application domain: /LM/W3SVC/1/ROOT-1-130279935803523871

        Trust level: Full

        Application Virtual Path: /

        Application Path: C:\inetpub\wwwroot\

        Machine name: MyAPPServer

    Process information:

        Process ID: 5044

        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://MyAPPSERVER/MYORG/CRMReports/rsviewer/reportviewer.aspx

        Request path: /MYORG/CRMReports/rsviewer/reportviewer.aspx

        User host address: 199.217.227.251

        User: MyDomain\MYID

        Is authenticated: True

        Authentication Type: Negotiate

        Thread account name: NT AUTHORITY\NETWORK SERVICE

    Thread information:

        Thread ID: 32

        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.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


    To summerize it:

    My Report is rendering correctly. The problem is if it sits idle for 2 minutes then when I try to navigate between pages then I get an error.(Which I think it is because of the teh seesion expiration between CRM and SQL)

    I beleive CRM opesn a connection with SQL when you run the report from CRM and expires the session after couple of seconds(I guess about 60 to 90 seconds). There should be a setting in the web.config on application server or some where else to increase this time to for example 5 minutes:

    My Questions are:

      1- Where can I change the default expiry time

      2- What are the negative impacts if we increase it to 5 to 10 minute?

    Thanks in advance for your help!

    Tuesday, November 5, 2013 4:58 PM