[KCFusion] ColdFusion Query Times Out
I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121&RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
Re: [KCFusion] ColdFusion Query Times Out
Mind if we see the query? A. - Original Message - From: Bruce Phillips To: > Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121&RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
Re: [KCFusion] ColdFusion Query Times Out
Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenterfrom submissions JOIN conferences on submissions.confid = conferences.confidJOIN categories on submissions.catid = categories.catidJOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionidJOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = AND submissions.cancelled= AND submissions.rejected= order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]>>> [EMAIL PROTECTED] 07/23/03 12:01PM >>> Mind if we see the query? A. - Original Message - From: Bruce Phillips To: > Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121&RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
RE: [KCFusion] ColdFusion Query Times Out
The timeout parameter of the cfquery tag is in milliseconds in the help docs, so you've set it to timeout in 0.26 seconds. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Bruce PhillipsSent: Wednesday, July 23, 2003 10:59 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] ColdFusion Query Times Out Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenterfrom submissions JOIN conferences on submissions.confid = conferences.confidJOIN categories on submissions.catid = categories.catidJOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionidJOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = AND submissions.cancelled= AND submissions.rejected= order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]>>> [EMAIL PROTECTED] 07/23/03 12:01PM >>> Mind if we see the query? A. - Original Message - From: Bruce Phillips To: > Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121&RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
RE: [KCFusion] ColdFusion Query Times Out
You do realize the timeout attribute is in milliseconds? You are telling it to timeout after 260 milliseconds. -Original Message- From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:59 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] ColdFusion Query Times Out Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenter from submissions JOIN conferences on submissions.confid = conferences.confid JOIN categories on submissions.catid = categories.catid JOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionid JOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = AND submissions.cancelled= AND submissions.rejected= order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname Bruce Phillips Society of Teachers of Family Medicine 913-906-6000 ext 5405 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 07/23/03 12:01PM >>> Mind if we see the query? A. - Original Message - From: Bruce Phillips To: > Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121&RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce Phillips Society of Teachers of Family Medicine 913-906-6000 ext 5405 [EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* ***
RE: [KCFusion] ColdFusion Query Times Out
TIMEOUT attribute in MX is now in seconds and not milliseconds as in CF 5. Also applies to each part of query, not the whole operation. Please refer to http://livedocs.macromedia.com/cf6docs/CFML_Reference/Tags-pt218.jsp Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]>>> [EMAIL PROTECTED] 07/23/03 01:12PM >>> The timeout parameter of the cfquery tag is in milliseconds in the help docs, so you've set it to timeout in 0.26 seconds. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Bruce PhillipsSent: Wednesday, July 23, 2003 10:59 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] ColdFusion Query Times Out Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenterfrom submissions JOIN conferences on submissions.confid = conferences.confidJOIN categories on submissions.catid = categories.catidJOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionidJOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = AND submissions.cancelled= AND submissions.rejected= order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]>>> [EMAIL PROTECTED] 07/23/03 12:01PM >>> Mind if we see the query? A. - Original Message - From: Bruce Phillips To: > Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121&RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
RE: [KCFusion] Updater 3
Thanks. Its not looking like a problem with the Oracle setup. The same thing is occurring in Java. Jeff -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:35 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Updater 3 Jeff, I was unsuccessful at installing Updater 3 on one machine, but I think it was a windows problem. I had no problems on 2 other machines, but these were running MS SQL 2000 and not Oracle. I have not heard of any significant problems with U3 and Oracle, though I haven't been watching for them either. If you can survive this problem, Redsky (free upgrade) may fix it when it is available shortly. If not, see if you can uninstall U3 and move back to U2. Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] ColdFusion Query Times Out
Title: Message Not an actual solution but you might try trimming down the query until you can get it to run, i.e. remove the order by and maybe some joins. Once its running add things back and see what seems to cause the timeout. Also, have you ran the query outside of CF to get an estimate of the time needed? -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:13 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] ColdFusion Query Times Out TIMEOUT attribute in MX is now in seconds and not milliseconds as in CF 5. Also applies to each part of query, not the whole operation. Please refer to http://livedocs.macromedia.com/cf6docs/CFML_Reference/Tags-pt218.jsp Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]>>> [EMAIL PROTECTED] 07/23/03 01:12PM >>> The timeout parameter of the cfquery tag is in milliseconds in the help docs, so you've set it to timeout in 0.26 seconds. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Bruce PhillipsSent: Wednesday, July 23, 2003 10:59 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] ColdFusion Query Times Out Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. select submissions.*, presenters.*, categories.catname_display, conferences.confName_display,conferences.confid,Submissions2Presenters.mainpresenterfrom submissions JOIN conferences on submissions.confid = conferences.confidJOIN categories on submissions.catid = categories.catidJOIN Submissions2Presenters on Submissions2Presenters.Submissionid = Submissions.submissionidJOIN presenters ON Submissions2Presenters.presenterID = presenters.presenterid where submissions.confid = AND submissions.cancelled= AND submissions.rejected= order by categories.catname_display, submissions.submissionID, assigned_session, Submissions2Presenters.MainPresenter DESC, lastname ,firstname Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]>>> [EMAIL PROTECTED] 07/23/03 12:01PM >>> Mind if we see the query? A. - Original Message - From: Bruce Phillips To: > Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds. I've tried setting the timeout attribute in the CFQUERY tab, but that attribute appears to be ignored. This is the error message I get: Error Causing Template: /sTFMPresenter/Admin/ReportReviewConf.cfm URL Variables Provided: confid=121&RequestTimeOut=10 Error Message: The request has exceeded the allowable time limit Tag: CFQUERY I don't have access to the ColdFusion Administrator since we have a separate web hosting company. Any advice on how I can get long complex queries to work would be appreciated. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* ***