tracker issue : CF-4204800

select a category, or use search below
(searches all categories and all time range)

Long running queries timeout

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/PRNeedInfo

Reporter/Name(from Bugbase): Mark W. / ()

Created: 07/10/2019

Components: Database, CFQuery

Versions: 2018

Failure Type: Usability Issue

Found In Build/Fixed In Build: 87315.134646 /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2016

Vote Count: 1

Problem Description:  I have a CFM page that runs fine in version 10 but times out in 2018.  The error that is logged is:
"Error","ajp-nio-8018-exec-5","06/26/19","14:46:56","OTCAS","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: D:\wwwroot\lls_dev\intranet\otcas\home\cube&weight_reports\report\rptWordCubeandWeight.cfm, line: 79 "
I have tried setting the requesttimeout at the top of the page:
<cfsetting requesttimeout="500">

I have tried modifying the request timeout at there server level.
I have tried adding the timeout attribute in the CFQUERY tag.
I have tried seeing if there were any SQL Server switches/properties that could be added to extend the timeout (didn't find anything)

Nothing I have tried seems to work.  The query runs anywhere from 45 seconds to a little over 1 minute in the SQL Server management studio.  I assume the timeout is happening after 30 to 60 seconds.  If I plug another shorter running query into the code the page will finish.

Any help you can provide would be greatly appreciated.

Steps to Reproduce:

Actual Result:

Expected Result:

Any Workarounds:



Mark, Can you please share the exception stack trace so that we know which component is throwing Timeout exception? -Nimit
Comment by Nimit S.
31133 | August 20, 2019 04:48:36 AM GMT
Mark, can you pls. share the info requested in Nimit's last comment.
Comment by Piyush K.
33219 | March 02, 2020 11:27:34 AM GMT
closing this since for the lack of details. Mark, if you find your way back here, pls. feel free to write to me at to pick this up again.
Comment by Piyush K.
33330 | March 24, 2020 09:24:31 AM GMT