Yes, I can concur about the way CF Reports timeouts: it's usually the tag preceding the one reported that was the issue. In my experience, it's that CF generally cannot timeout the actual tag that causes CF to cross over the timeout time. Commonly, it may be a cfquery (talking to a database), a cfhttp (talking to another server), a cfinvoke (calling a web service), etc. None of these can be interrupted while working.
So it's that CF returns from that long-running tag, sees before running the next tag that it's now crossed that timeout boundary (set in the Admin or CFSETTING) and reports it, but noting the tag it's about to run, which is unfortunate. This is why we often it report an error with cfoutput timing out. Of course, it's not cfoutput, but that's what often follows a cfquery, cfhttp, etc. All that said, we should note that CFQUERY does itself have a TIMEOUT attribute, and it can sometimes work. When it does, then that could in fact mean that CF would report accurately that it's that cfquery that did timeout. But there are just as many chances that that TIMEOUT will be ignored (can depend on the driver, the db, etc.) and so the cfquery will still need to finish (despite the timeout), in which case the page/admin timeout above will take effect on its return. HTH. /charlie > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of > Matthew > Sent: Monday, June 14, 2010 9:56 PM > To: cfaussie > Subject: [cfaussie] Re: CF Query Timeout > > @Claude: I know I'm a little late to help but just thought I'd mention > experiences. Once I found the the CFQUERY timeout error was mis- > leading. I had a web-service call prior to a CFQUERY and for some > reason CF was blaming the query. I proved this by pulling the query > out and putting some other action in and it blamed that. All I'm > saying is, look at the code before the query such as you Excel/XML > read. Looks like Steve's extended timeout sort you out anyway. > > Cheers > Matthew > > On Jun 9, 10:43 pm, <[email protected]> wrote: > > Hi > > > > Is there a way that I have prevent the cfquery from timing out > > > > The sit is running on cf8 server in a shared hosting environment > > > > I am creating a complex excel spreadsheet using <cfxml variable="varname"> > > that holds the xml for up to 20 different worksheets created on the fly. > > > > Given the volume of records in each worksheet often I generate the error > > > > Error Occurred While Processing Request > > > > The request has exceeded the allowable time limit Tag: CFQUERY > > > > I have tried to specify the timeout value in each query to a large amount of > > time however the timeout error still generates within 1 minute of the page > > starting to process the data. > > > > I have ensured that I am running queries of queries where possible to > > prevent unnecessary queries to the sql database however this seems not to > > have had any effect. > > > > If anyone has some suggestion I would be grateful. > > > > Regards > > > > Claude Raiola (B.Econ Acc; B.Hot. Mngt) > > Samaris Software > > Email: <mailto:[email protected]> [email protected] > > Website: <http://www.TrackingCentral.com.au>www.SAMARIS.net > > Mobile: 0414 228 948 > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
