Status/Resolution/Reason: Closed/Withdrawn/PRNeedInfo
Reporter/Name(from Bugbase): Mark W. / ()
Created: 07/10/2019
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:Attachments:
Comments: