RE: The request has exceeded the allowable time limit Tag: cfmail
I do, but the code doesn't produce errors. When I restart ColdFusion server and try again without changing code it works fine. -Original Message- From: Will Swain [mailto:w...@hothorse.com] Sent: Monday, March 30, 2009 9:47 AM To: cf-talk Subject: RE: The request has exceeded the allowable time limit Tag: cfmail Do you have some error handling code in your application.cfc that emails errors to you? Jat. -Original Message- From: Chad McCue [mailto:c...@advmediaproductions.com] Sent: 30 March 2009 14:41 To: cf-talk Subject: The request has exceeded the allowable time limit Tag: cfmail I am not sure why I receive this error, the piece of code I am running does not try to send any mail at all. The request has exceeded the allowable time limit Tag: cfmail ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The request has exceeded the allowable time limit Tag: cfmail
Do you have some error handling code in your application.cfc that emails errors to you? Jat. -Original Message- From: Chad McCue [mailto:c...@advmediaproductions.com] Sent: 30 March 2009 14:41 To: cf-talk Subject: The request has exceeded the allowable time limit Tag: cfmail I am not sure why I receive this error, the piece of code I am running does not try to send any mail at all. The request has exceeded the allowable time limit Tag: cfmail ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The request has exceeded the allowable time limit
On Wednesday 13 Jun 2007, Sung Woo wrote: > ugly, but I have to make an exception in this case. Two of the tables I'm > hitting are extremely slow (200-300ms for data to return from the metrics > I've run), so there are inherent issues with this transaction. And I'm guessing you can't wither fix the database or cache the result ? -- Tom Chiverton Helping to appropriately lead end-to-end e-markets on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The request has exceeded the allowable time limit
On Wednesday 13 Jun 2007, Sung Woo wrote: > If there's no solution to this, then I'll need to run the script in steps > -- 300 or 400 records at a time. Or don't use ColdFusion. -- Tom Chiverton Helping to appropriately differentiate internet architectures on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The request has exceeded the allowable time limit
Looks like my reply got hosed somehow. In any case, to make a long story short, two of the DBs I hit come with some ugly latency, so 2 seconds is the best I can do. I always try to hit 250ms or less in anything I do in CF, but sometimes exceptions have to be made. CF Admin can't be the issue -- I have a 60-second limit on templates, but that's meaningless when you have cfsetting requesttimeout=xxx on the page. If there's no solution to this, then I'll need to run the script in steps -- 300 or 400 records at a time. > On Wednesday 13 Jun 2007, Sung Woo wrote: > > happening that I don't think I can replicate in a SP. At least not > easily. > > And besides, it's already written in CF, so I can't go back now. > > You can (should ?) if it is running for too long. > > > 2 seconds for a transaction that ties together data from four > discrete > > databases is OK in my book. > > I'd expect it to run in well under a second. Tens of milli's, ideally. > > Maybe that's just me. > > > My main question still remains unanswered -- > > is there some place in CF where a 600-second template limitation > exists? > > The CF admin., not unusually. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The request has exceeded the allowable time limit
Like most CF transactions, I consider anything longer than 250ms to be ugly, but I have to make an exception in this case. Two of the tables I'm hitting are extremely slow (200-300ms for data to return from the metrics I've run), so there are inherent issues with this transaction. CF Admin is not the issue. I have a timeout of 60 seconds, but CFSETTING RequestTimeout = xxx is supposed to overrule that. - Sung > On Wednesday 13 Jun 2007, Sung Woo wrote: > > happening that I don't think I can replicate in a SP. At least not > easily. > > And besides, it's already written in CF, so I can't go back now. > > You can (should ?) if it is running for too long. > > > 2 seconds for a transaction that ties together data from four > discrete > > databases is OK in my book. > > I'd expect it to run in well under a second. Tens of milli's, ideally. > > Maybe that's just me. > > > My main question still remains unanswered -- > > is there some place in CF where a 600-second template limitation > exists? > > The CF admin., not unusually. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The request has exceeded the allowable time limit
On Wednesday 13 Jun 2007, Sung Woo wrote: > happening that I don't think I can replicate in a SP. At least not easily. > And besides, it's already written in CF, so I can't go back now. You can (should ?) if it is running for too long. > 2 seconds for a transaction that ties together data from four discrete > databases is OK in my book. I'd expect it to run in well under a second. Tens of milli's, ideally. Maybe that's just me. > My main question still remains unanswered -- > is there some place in CF where a 600-second template limitation exists? The CF admin., not unusually. -- Tom Chiverton Helping to collaboratively utilize best-of-breed markets on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The request has exceeded the allowable time limit
> On Wednesday 13 Jun 2007, Sung Woo wrote: > > I'm pulling in 5 other templates. For each record, it takes 2 > seconds to > > run. Here's a snippet of the log file: > > What are you doing ? Maybe you could do it faster (like in a stored > proc.) ? Hi Tom, It's possible to do it in a SP, but there's a whole lot of stuff that's happening that I don't think I can replicate in a SP. At least not easily. And besides, it's already written in CF, so I can't go back now. 2 seconds for a transaction that ties together data from four discrete databases is OK in my book. My main question still remains unanswered -- is there some place in CF where a 600-second template limitation exists? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The request has exceeded the allowable time limit
On Wednesday 13 Jun 2007, Sung Woo wrote: > I'm pulling in 5 other templates. For each record, it takes 2 seconds to > run. Here's a snippet of the log file: What are you doing ? Maybe you could do it faster (like in a stored proc.) ? -- Tom Chiverton Helping to enormously maintain guinine materials on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The request has exceeded the allowable time limit
>How long do you expect the job to take to complete? 2 hours seems way too
>long for an http request to run.
>
>How many templates are involved?
Hi Neil,
At this point, I don't expect the job to take any more than 15 minutes. I
currently have around 750 records, and at the 10-minute mark, it gets to about
450.
It's entirely possible for the transaction to take 2 hours, though, down the
road. The script runs when nobody is on the server, so load is not an issue.
I'm pulling in 5 other templates. For each record, it takes 2 seconds to run.
Here's a snippet of the log file:
{ts '2007-06-12 22:33:38'}: Start 1
{ts '2007-06-12 22:33:40'}: End 1
{ts '2007-06-12 22:33:40'}: Start 2
{ts '2007-06-12 22:33:42'}: End 2
{ts '2007-06-12 22:33:42'}: Start 3
{ts '2007-06-12 22:33:44'}: End 3
..
..
..
{ts '2007-06-12 22:43:36'}: Start 574
{ts '2007-06-12 22:43:37'}: End 574
{ts '2007-06-12 22:43:37'}: Start 575
{ts '2007-06-12 22:43:38'}: error 575
You can see here that exactly at 10 minutes, the script halts.
Is there some other setting in jrun.xml or something that I'm missing?
~|
ColdFusion 8 beta â Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280981
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The request has exceeded the allowable time limit
How long do you expect the job to take to complete? 2 hours seems way too long for an http request to run. How many templates are involved? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: Sung Woo To: CF-Talk Sent: Wed Jun 13 03:47:50 2007 Subject: The request has exceeded the allowable time limit For the life of me, I can't figure out what I'm doing wrong. Running CFMX7.0.2 on Win2K: I have a scheduled task that includes a bunch of other templates, updating a bunch of tables. Anyway, I have the Timeout (sec) value in the Scheduled Task set at 7200. That's 2 hours, right? 60 seconds * 60 minutes * 2 = 7200 seconds. On the scheduled task itself, I have this on top of it: Yet this is the problem: I get this error at EXACTLY the 10 minute mark: "The request has exceeded the allowable time limit" Sometimes it's CFQUERY; other times it's CFFILE; whatever it hits at the 10 minute mark is when this error is generated. Which means that despite the requesttimeouts I have here, something else is overriding it and putting a hard limit of 60 seconds. I do have FusionReactor on this box, but crash protection is not enabled, so it shouldn't be the cause. What is going on here? ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The request has exceeded the allowable time limit
> Which means that despite the requesttimeouts I have here, something > else is overriding it and putting a hard limit of 60 seconds. I do > have FusionReactor on this box, but crash protection is not enabled, > so it shouldn't be the cause. What is going on here? Sorry, I meant a hard limit of 600 seconds, or 10 minutes. ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The request has exceeded the allowable time limit Tag: cfoutput
Oh...that's easy enough. Thanks. -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 11:53 AM To: CF-Talk Subject: Re: The request has exceeded the allowable time limit Tag: cfoutput On 6/14/06, James Holmes <[EMAIL PROTECTED]> wrote: > The template is running past the time allowed in the CF Admin. It > could be either the DB or the post DB processing time. Anyway, you can > increase the time available to the template with a cfsetting tag. > > On 6/14/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > I'm getting this error when a complex query is run. It has multiple inner > > joins and is returning potentially thousands of records with about 60 > > columns each. > > > > --- > > The request has exceeded the allowable time limit Tag: cfoutput > > The error occurred on line 111. > > --- > > -- > CFAJAX docs and other useful articles: > http://jr-holmes.coldfusionjournal.com/ > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: The request has exceeded the allowable time limit Tag: cfoutput
On 6/14/06, James Holmes <[EMAIL PROTECTED]> wrote: > The template is running past the time allowed in the CF Admin. It > could be either the DB or the post DB processing time. Anyway, you can > increase the time available to the template with a cfsetting tag. > > On 6/14/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > I'm getting this error when a complex query is run. It has multiple inner > > joins and is returning potentially thousands of records with about 60 > > columns each. > > > > --- > > The request has exceeded the allowable time limit Tag: cfoutput > > The error occurred on line 111. > > --- > > -- > CFAJAX docs and other useful articles: > http://jr-holmes.coldfusionjournal.com/ > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: The request has exceeded the allowable time limit Tag: cfoutput
Just put this at the top of your page: Set the time to be whatever you want in seconds. Andy Matthews wrote: > James... > > Do you have an example of using cfsetting in this way? > > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 14, 2006 11:36 AM > To: CF-Talk > Subject: Re: The request has exceeded the allowable time limit Tag: > cfoutput > > > The template is running past the time allowed in the CF Admin. It > could be either the DB or the post DB processing time. Anyway, you can > increase the time available to the template with a cfsetting tag. > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: The request has exceeded the allowable time limit Tag: cfoutput
James... Do you have an example of using cfsetting in this way? -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 11:36 AM To: CF-Talk Subject: Re: The request has exceeded the allowable time limit Tag: cfoutput The template is running past the time allowed in the CF Admin. It could be either the DB or the post DB processing time. Anyway, you can increase the time available to the template with a cfsetting tag. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: The request has exceeded the allowable time limit Tag: cfoutput
The template is running past the time allowed in the CF Admin. It could be either the DB or the post DB processing time. Anyway, you can increase the time available to the template with a cfsetting tag. On 6/14/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > I'm getting this error when a complex query is run. It has multiple inner > joins and is returning potentially thousands of records with about 60 > columns each. > > --- > The request has exceeded the allowable time limit Tag: cfoutput > The error occurred on line 111. > --- -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: The request has exceeded the allowable time limit Tag: CFQUERY
Try setting the default request timeout for that template higher by adding a cfsetting. Add this to the template in the top, to give the query 60 seconds time to execute before the process is aborted. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184103 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
