Its under "Server Settings > Settings"......."Timeout requests after (seconds)"
From: Gavin Beau Baumanis [mailto:b...@palcare.com.au] Sent: Wednesday, 2 February 2011 4:00 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] The request has exceeded the allowable time limit Tag: CFLOOP Hi Steve, I assume that is in IIS / web server setting - since I can't find it in the CFAdmin interface anywhere? And if so would I not be getting a HTTP error and not a CFML generated one? On 02/02/2011, at 3:44 PM, Steve Onnis wrote: Maybe there is the "Stop Long Running Scripts" setting that is killing it before it finishes? From: Gavin Beau Baumanis [mailto:b...@palcare.com.au] Sent: Wednesday, 2 February 2011 3:40 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] The request has exceeded the allowable time limit Tag: CFLOOP Hi again Mark, The request timeout in CFAdmin is set to 1000. We do not use CFSETTING anywhere - so the only timeout setting we have anywhere is in the CFAdmin interface Gavin On 02/02/2011, at 3:03 PM, Mark Mandel wrote: Do you have a request setting somewhere else? as a <cfsetting> that may be lower? Is your request timeout 960 seconds? (Rather than 480) - stupid question, but figured I would ask. Mark On Wed, Feb 2, 2011 at 2:56 PM, Gavin Beau Baumanis <b...@palcare.com.au> wrote: Hi Mark, Thanks for the reply - as always I appreciate the help. I just timed it and the error is being thrown at 8 (and a bit) minutes. It is well within the 16 minutes request timeout setting of the CFAdmin. So I don't see how that can be the case - and thus the looking for answers, elsewhere. Gavin. On 02/02/2011, at 2:37 PM, Mark Mandel wrote: You page is exceeding the request time-out. The error is misleading, just because the Tag displayed just happens to be wherever the code lands when the timeout occurs. You may want to increase the request timeout on that page, or drop some <cftimers> in place, and work out what is taking so long, and attempt to speed it up (or both!) Mark On Wed, Feb 2, 2011 at 2:34 PM, Gavin Beau Baumanis <b...@palcare.com.au> wrote: Hi there everyone, We have an issue with some long running SQL in our application. The error is; The request has exceeded the allowable time limit Tag: CFLOOP The docs don't seem to indicate that the CFLOOP tag even has a timeout attribute. The stack trace (below) seems to indicate that the request is timing out - but the timeout set in the CFAdmin is 1000 seconds (16.66 minutes) and the error is being thrown before then. coldfusion.runtime.RequestTimedOutException: The request has exceeded the allowable time limit Tag: CFLOOP at coldfusion.runtime.CfJspPage.checkRequestTimeout(CfJspPage.java:2907) at cfweeklypatientvisits_bereaved2ecfm309418466._factor43(/var/www-vhosts/palca re/teomanga/patient/weeklypatientvisits_bereaved.cfm:531) at cfweeklypatientvisits_bereaved2ecfm309418466._factor64(/var/www-vhosts/palca re/teomanga/patient/weeklypatientvisits_bereaved.cfm:387) at cfweeklypatientvisits_bereaved2ecfm309418466._factor66(/var/www-vhosts/palca re/teomanga/patient/weeklypatientvisits_bereaved.cfm:386) at cfweeklypatientvisits_bereaved2ecfm309418466._factor67(/var/www-vhosts/palca re/teomanga/patient/weeklypatientvisits_bereaved..cfm:78) at cfweeklypatientvisits_bereaved2ecfm309418466._factor68(/var/www-vhosts/palca re/teomanga/patient/weeklypatientvisits_bereaved.cfm:3) at cfweeklypatientvisits_bereaved2ecfm309418466.runPage(/var/www-vhosts/palcare /teomanga/patient/weeklypatientvisits_bereaved.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion..filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet..jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203 ) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) I thought perhaps it might have been a query timeout. But we don't use the timeout attribute in any of our SQL. And we use PostgreSQL - and that DSN settings do not have a query timeout setting in CFAdmin for the PostgreSQL driver / datasource. We are bit stuck with this - So I thought I had better ask for some help. Gavin. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com <mailto:cfaussie%2bunsubscr...@googlegroups.com> . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www..twitter.com/neurotic <http://www.twitter.com/neurotic> W: www.compoundtheory.com <http://www.compoundtheory.com/> cf.Objective(ANZ) - Nov 17, 18 - Melbourne Australia http://www.cfobjective.com.au <http://www.cfobjective.com.au/> Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com <http://www.ColdFusionOrmTraining.com/> -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com.. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com <mailto:cfaussie%2bunsubscr...@googlegroups.com> . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com <http://www.compoundtheory.com/> cf.Objective(ANZ) - Nov 17, 18 - Melbourne Australia http://www.cfobjective.com.au <http://www.cfobjective.com.au/> Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com <http://www.ColdFusionOrmTraining.com/> -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com <mailto:cfaus...@googlegroups..com> . To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups..google.com/group/cfaussie?hl=en <http://groups.google.com/group/cfaussie?hl=en> . -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16820) http://www.pctools.com <http://www.pctools.com/?cclick=EmailFooterClean_51> ======= ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16820) http://www.pctools.com <http://www.pctools.com/?cclick=EmailFooterClean_51> ======= -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16820) http://www.pctools.com <http://www.pctools.com/?cclick=EmailFooterClean_51> ======= ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16820) http://www.pctools.com/ ======= -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.