Solved

Page Timeout issues??

Posted on 2004-04-23
21
181 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
 
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Join & Write a Comment

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now