Thread: PageNotFound Timeout Issue

I have created a bit of custom code however it does make a lot of database calls, it is designed to email a batch of customers maybe 30 tops, pull up their past orders and items and email it to them.

The issue is for one order it works fine, however for larger numbers of results it loads for maybe 3-5 seconds then shows PageNotFound.

It would seem to be a timeout issue.
How can I extend the time for a single page?

Thanks in advance

Bump,

We know it is not our server but the software but we don't know how to overwrite it, any help please.

Hi

If you have access to your page code, you should be able to change the page's timeout using the server object - Server.ScriptTimeout= [Seconds to timeout]

Alternatively, on a site-wide basis, you can set the timeout by editing the Application Pool settings in IIS.

Application Pool -> Advanced Settings -> Process Model -> Shutdown Time Limit
I think the default value is 90 seconds.

Having said that, I'm surprised your queries to the customer/order tables are taking that long. Have you run them through SQL Server's execution plan to make sure they are using the correct indexes and also making sure they are not using locks on the tables?

Adam

I have checked the SQL queries and they are all working fine.

The problem seems to be one query calls all orders shipped in this date range.
Loop every order. The next parts are repeated for each order.
Second query, pull down the items ordered.
Send out an email to the customer.
Last query updates one field in the order table.

Is the server.scripttimeout inside the page_load? I believe it is, however it still all crashes and says page can not be displayed.

The script works fine for just one customer.