Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Page Timeout issues??

Posted on 2004-04-23
21
Medium Priority
?
193 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
[X]
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
  • 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
Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

 
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

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

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

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

670 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