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: To Track//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