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
LVL 1
jduawaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
moduloConnect With a Mentor Commented:
Closed, 125 points refunded.

modulo
Community Support Moderator
Experts Exchange
0
 
SidFishesCommented:
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">
0
 
SidFishesCommented:
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
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Tacobell777Commented:
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...
0
 
jduawaAuthor Commented:
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  
0
 
jduawaAuthor Commented:
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.
0
 
Tacobell777Commented:
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.
0
 
jduawaAuthor Commented:
It occurs exactly 1Hour after the page begins to load
0
 
Tacobell777Commented:
Did you untick "Show friendly error messages" in your browser?
0
 
jduawaAuthor Commented:
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
0
 
jduawaAuthor Commented:
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
0
 
PluckaCommented:
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
0
 
jduawaAuthor Commented:
i tried that already...but thanks....
0
 
jalpinoCommented:
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 ?





 
0
 
jduawaAuthor Commented:
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...
0
 
jduawaAuthor Commented:
refund points, i fgured it out myself
thanks
0
 
jduawaAuthor Commented:
mrichmon look at the message i posted from 04/23/2004 03:21PM PDT the solution is there
0
 
mrichmonCommented:
oh okay I overlooked that.

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

Please be sure to include a link to this question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.