Possible timeout problems generating report viewer

[luisma]

Hi all,

I would like to tell you the problems I have with my web application in discountasp server and ask you for help if it is possible.

My web application has a button which creates a background thread to generate a pdf file using report viewer (.rdcl) and then to send it via hardcoded email (the first version had just one thread but now I prefer to put this process in the background thread because of takes about ten minutes). The report is created as a chain of subreports using subreporting processing, and this subreports need to access several times to the database (sqlserver 2008 and located in discountasp server too) and use the session variables managed by the application to build querys.

In my local server it executes right, but in discountasp server, after a few minutes, an exception (I can not capture it) is being generated and the application behaviour is then wrong. I suppose is the timeout for the session, because something similar happens if the report generation is in the main thread, and then the time out exception can be captured. Then:

1) Do you think could it be the problem or there is something I'm not taking into account?

2) I'm thinking about using ASP-NET SQL Server Session, do you think this could be a solution?

3) Do you know if discountasp server allows to work with background threads during just for a few minutes or they recycled?

Thanks for your time and regards

[Ramses]

You probably have to take into account the server resources if you think that your application can be having these sort of problems.

Your application will recycle if you reach any of the following limits:
1. Memory limit: 100mb on IIS6, 200mb on IIS7
2. 70% of the CPU for 210 seconds.

[luisma]

Hi Ramses!

Do you know how could I evaluate if these resources are being exceeded? (I am using discountasp server...)

[keikoraca]

You can open up a ticket with our support team and request for them to check and see if your application is maxing out it's resources causing your application to recycle.

You may also want to check out our KB article on how to enable SQL Session State, it usually solves any problems with sessions being dropped if you feel that is the issue.

https://support.discountasp.net/KB/a334/how-to-enable-aspnet-sql-server-session-on-your-web.aspx?KBSearchID=0

[luisma]

Ok thanks keikoraca. I am going to read your link and probably I will use the tickets for support.

Now I am reading about programming scheduled-tasks, to study the possibility of generating reports as a scheduled-task which is executed each time period (a couple of minutes or similar) reading a table with reports requests and generating the reports divided into several parts, and using the code in the server.

In the post above, Ramses told that there is a memory limit for recycling processes of 200mb on IIS7, which could be (I don't know) the exceeded limit in my web application.
Does anyone know if there is a timeout too for recycling processes in this server? And, in case of scheduled-tasks, is this timeout (or about the memory limit) the same or it is greater?