Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Page Timeout issues??

Posted on 2004-04-23
21
187 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:jduawa
  • 9
  • 3
  • 2
  • +4
21 Comments
 
LVL 36

Expert Comment

by:SidFishes
ID: 10903287
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
 
LVL 36

Expert Comment

by:SidFishes
ID: 10903314
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
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10903733
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 1

Author Comment

by:jduawa
ID: 10904032
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
 
LVL 1

Author Comment

by:jduawa
ID: 10904040
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
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10904188
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
 
LVL 1

Author Comment

by:jduawa
ID: 10904195
It occurs exactly 1Hour after the page begins to load
0
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10904218
Did you untick "Show friendly error messages" in your browser?
0
 
LVL 1

Author Comment

by:jduawa
ID: 10904235
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
 
LVL 1

Author Comment

by:jduawa
ID: 10904373
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
 
LVL 18

Expert Comment

by:Plucka
ID: 10926900
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
 
LVL 1

Author Comment

by:jduawa
ID: 10928949
i tried that already...but thanks....
0
 
LVL 2

Expert Comment

by:jalpino
ID: 10956082
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
 
LVL 1

Author Comment

by:jduawa
ID: 10959834
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
 
LVL 1

Author Comment

by:jduawa
ID: 11165615
refund points, i fgured it out myself
thanks
0
 
LVL 1

Author Comment

by:jduawa
ID: 11225242
mrichmon look at the message i posted from 04/23/2004 03:21PM PDT the solution is there
0
 
LVL 35

Expert Comment

by:mrichmon
ID: 11225277
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
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11247962
Closed, 125 points refunded.

modulo
Community Support Moderator
Experts Exchange
0

Featured Post

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question