web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Rendered Report exipres after a short time when running from CRM 4

(0) ShareShare
ReportReport
Posted on by 315

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)


Any help would be much apprecaited.

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • purwar purwar Profile Picture
    2,836 on at

    Chk below link :

    support.microsoft.com/.../946289

  • Verified answer
    Maryam Profile Picture
    315 on at

    Thanks Purewar but I am not reciving an error because of the Sql Server report connector.

    My Report is rendering correctly. The problem is if it sits idel 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,

    Maryam

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans