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!