Link to home
Start Free TrialLog in
Avatar of jduawa
jduawa

asked on

Page Timeout issues??

I have a cfm page that calls a CFX tag.  What the page is accessign an oracle databse and then generating alot of PDF files based on the data in oracle
the problem i am having is that after exactly 1 hour the page says
The page cannot be displayed

i tried setting the page timeout settings in cf admin to 60000 seconds and that did not work...i tried adding ?requestTimeout=60000 after the page name in the broowser and that did not work...is there any other setting that would terminate the page after 1 hour??thanks
Avatar of SidFishes
SidFishes
Flag of Canada image

check your application.cfm ApplicationtTimeOut value...if you don't have one set it


                                                                                                         vOne day time out
<CFAPPLICATION NAME="MyApp" applicationtimeout="#createtimespan(1, 0, 0, 0)#" SESSIONMANAGEMENT="Yes" sessionTimeout="#createtimespan(1, 0, 0, 0)#" clientmanagement="yes" clientstorage="cookie">
doh...

that didn't format correctly

="#createtimespan(1, 0, 0, 0)#"  where (1,0,0,0) = (Day, Hour, Min, Sec) so 1 is one day
Avatar of Tacobell777
Tacobell777

You could try <cfsetting requesttimeout="80000"> in the calling page itself, if your not using session variables or application variables in your page then the above has nothing to do with it.

Remember if you set the timeout to 60 its one minute.

To my opinion your doing something that ColdFusion should not be doing, CF should never run this long to process something.

Another option you might try is to split the processing up, for example the first query retrieves all the work that needs to be done, and it then only generates the first 10 PDFs and so on...
Avatar of jduawa

ASKER

SidFishes, i tried your suggestion and still get the following

 The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.

--------------------------------------------------------------------------------

Please try the following:

Click the  Refresh button, or try again later.

If you typed the page address in the Address bar, make sure that it is spelled correctly.

To check your connection settings, click the Tools menu, and then click Internet Options. On the Connections tab, click Settings. The settings should match those provided by your local area network (LAN) administrator or Internet service provider (ISP).
If your Network Administrator has enabled it, Microsoft Windows can examine your network and automatically discover network connection settings.
If you would like Windows to try and discover them,
click  Detect Network Settings
Some sites require 128-bit connection security. Click the Help menu and then click About Internet Explorer to determine what strength security you have installed.
If you are trying to reach a secure site, make sure your Security settings can support it. Click the Tools menu, and then click Internet Options. On the Advanced tab, scroll to the Security section and check settings for SSL 2.0, SSL 3.0, TLS 1.0, PCT 1.0.
Click the  Back button to try another link.



Cannot find server or DNS Error
Internet Explorer  
Avatar of jduawa

ASKER

TacoBell777
while it may not be the best use of CF it is doing exactly what we need except the page times out, the cfx tag it calls contiues to run in the background until it is done, the page just gives that error after 1 hour. i even appended requestTimeOut=50000 to the url and it didnt work, maybe it is an iis setting or a setting somewhere else.
Do you get this immediately, this error? Or after a while?

If you get it immediately then it has nothign to do with a timeout.
Avatar of jduawa

ASKER

It occurs exactly 1Hour after the page begins to load
Did you untick "Show friendly error messages" in your browser?
Avatar of jduawa

ASKER

no, i have a javascript in there tellinig me the start time of the app and the current time that is how i know it is exactly 1 hour, if i trim down the query then it runs fine and shows the html it should show when it is done, but when it runs over an hour i get the message
Avatar of jduawa

ASKER

i found my answer...http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q181/0/50.asp&NoWebContent=1

"By design, Internet Explorer imposes a time-out limit for the server to return data. The time-out limit is five minutes for versions 4.0 and 4.01 and is 60 minutes for versions 5.x and 6. As a result, Internet Explorer does not wait endlessly for the server to come back with data when the server has a problem. "

thanks anyway
Hi jduawa,

There is a way around this.

Every so often do a <CFFLUSH> this will flush some output back to the browser, i've had this problem, and don't the flush fixed it for me.

Regards
Plucka
Avatar of jduawa

ASKER

i tried that already...but thanks....
Is there any way that you can break up the process into smaller peices? You said that cfx tag or whatever is using Oracle to create the pdfs, so my assumption is that it is returning more than 1 'groups' of records. Can you limit the number of records that are processed by cfx_tag ?





 
Avatar of jduawa

ASKER

Yes you can limit the query so it does not run for as long, but the idea was to run it and let it run, then when it is done use the PDF's the way we need to...
Avatar of jduawa

ASKER

refund points, i fgured it out myself
thanks
Avatar of jduawa

ASKER

mrichmon look at the message i posted from 04/23/2004 03:21PM PDT the solution is there
oh okay I overlooked that.

To get a refund you need to post a question here :
https://www.experts-exchange.com/Community_Support/

Please be sure to include a link to this question
ASKER CERTIFIED SOLUTION
Avatar of modulo
modulo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial