asked on

the allowable time limit Tag: CFQUERY

My company recently upgraded to ColdfusionMX and my exsisting application is giving me the below error, I tried cfquery's timeout attribute and ?requesttimeout=500 but neither didn't help. Can somebody tell me why it is happening and the fix for it.

-----
Error Occurred While Processing Request
The request has exceeded the allowable time limit Tag: CFQUERY

The Error Occurred in C:\Inetpub\wwwroot\gc\CSA\CSAver2.cfm: line 250

248 :
249 :
250 : <td align="center"><cfoutput>#months.PageHits# </cfoutput></td>
251 : <cfif "#months.PageHits#" EQ "">
252 : <cfset Array_pg_View[j] = "0">

-----

cdillon

For the query that is called "months", is there a timeout specified (in the query)? If not, you could specify the timeout for the query to be longer. Is this query properly optimized? Is the table that it draws the results from also optimized? To me it sounds like the table is growing and the query is taking too long to execute.

Try adding the timeout portion of the tag if it's not already set and make it an adequate amount of time for the query.

<CFQUERY NAME="months"
DATASOURCE="ds_name"
TIMEOUT="milliseconds"
>

If there is a timeout parameter, try and delete it.

ASKER CERTIFIED SOLUTION

TallerMike

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

chinu77

ASKER

Did try Timeout attribute -- didn't work. On trying
<cfsetting RequestTimeout = "500">

got the below error:

Error Occurred While Processing Request
Errors reported by Java compiler: Found 1 semantic error compiling "C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfCSAver22ecfm332379485.java": 233. setting14.setRequestTimeout(_validateTagAttrValue("cfsetting", "requestTimeout", coldfusion.runtime.Cast._long(this._resolveAndAutoscalarize("URL", new String[] {"REQUESTTIMEOUT"})))); <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> *** Error: No match was found for method "setRequestTimeout(double)".

cdillon

Try this instead:

<cfset somevariable = "500">
<cfsetting RequestTimeout = "#someVariable#">

Renante Entera

Hello!

Have you try restarting your ColdFusion Services?
If not then go on, maybe this could help you.

GOODLUCK!

anandkp

if ur using CFMX - then download the patchs ColdFusion MX

Updater Release 3
Release Notes Part 2 - ColdFusion MX Issues Fixed in this Release
March 19, 2003

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater.html

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater01.html

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater02.html

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater03.html

& then try the same stuff as suggested by "Mike" - it shld help u out [hopefully]

K'Rgds
Anand

hart

install the updater2 for CFMX to get this to work

<cfset somevariable = "500">
<cfsetting RequestTimeout = "#someVariable#">

i think it will.

let me know..

Regards
Hart(harish)

hart

use anand's links, hez correct..