?
Solved

the allowable time limit Tag: CFQUERY

Posted on 2003-03-28
8
Medium Priority
?
3,110 Views
Last Modified: 2013-12-24
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">

 -----
 
0
Comment
Question by:chinu77
[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
8 Comments
 
LVL 3

Expert Comment

by:cdillon
ID: 8225603
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.
0
 
LVL 8

Accepted Solution

by:
TallerMike earned 400 total points
ID: 8225742
MX nolonger supports the url.requesttimeout function. You'll need to user the following:

<cfsetting RequestTimeout = "500">

You can quickly fix this in your application.cfm like so:

<cfif IsDefined("url.RequestTimeout")>
    <cfsetting RequestTimeout = url.RequestTimeout>
</cfif>
0
 

Author Comment

by:chinu77
ID: 8227506
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)".  
 
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 3

Expert Comment

by:cdillon
ID: 8228656
Try this instead:

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

0
 
LVL 14

Expert Comment

by:Renante Entera
ID: 8228957
Hello!

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

GOODLUCK!
0
 
LVL 17

Expert Comment

by:anandkp
ID: 8229505
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
0
 
LVL 11

Expert Comment

by:hart
ID: 8229518
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)

0
 
LVL 11

Expert Comment

by:hart
ID: 8229523
use anand's links, hez correct..
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
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.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

762 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