Every once in a while I get this error screen after logging into eQSL. :
(I have to hit the browser (IE 6.0) refresh to continue and it works ok after that.)

The request has exceeded the allowable time limit Tag: CFQUERY


The error occurred in D:\www\eQSL\Htdocs\qslcard\CookieTest.cfm: line 163

161 : WHERE CallsignFrom = '#CardStyle.Callsign#'
162 : AND QSODate BETWEEN #CreateODBCDateTime(CardStyle.LicenseEffectiveDate)# AND #CreateODBCDateTime(CardStyle.LicenseExpiryDate)#
163 : AND (FromHamID IS NULL OR FromHamID <> #CardStyle.HamID#)
164 : </CFQUERY>
165 : <!--- If he does, then set ALL of them --->



--------------------------------------------------------------------------------

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; SBC)
Remote Address 144.160.5.25
Referrer
Date/Time 02-Jan-07 06:32 AM

Stack Trace (click to expand)
at cfCookieTest2ecfm536603564.runPage(D:\www\eQSL\Htdocs\qslcard\CookieTest.cfm:163)


coldfusion.runtime.RequestTimedOutException: The request has exceeded the allowable time limit Tag: CFQUERY
at coldfusion.sql.Executive.getRowSet(Executive.java:281)
at coldfusion.sql.Executive.executeQuery(Executive.java:705)
at coldfusion.sql.Executive.executeQuery(Executive.java:638)
at coldfusion.sql.Executive.executeQuery(Executive.java:599)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:498)
at cfCookieTest2ecfm536603564.runPage(D:\www\eQSL\Htdocs\qslcard\CookieTest.cfm:163)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:349)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

---

N1ORK Orest 'Andy' Zajac

Well, it took a while, but you guys finally fixed my log-in cookie test. Get to my page in about 8 seconds now. Great job, keep up the good work!
73

---

N1ORK Orest 'Andy' Zajac

Ok, same waiting for cookie test issue, but with a twist. I no longer get the timeout error as above, but since about 4/15/07, I again have to wait a long time (+/- 2 min.) to get to my page. My old call page (for n1cjg) has no problem. However, if I double click on my eQSL shortcut again, I get a new IE7 tab and it goes right into my page bypassing the login screen and the cookie test screen. So that's how I've been getting past this new issue.
73!

---

N1ORK Orest 'Andy' Zajac

Seems to be ok now. Only takes about 5-8 seconds to get to my page. I guess 'STUFF' happens once in a while.

---

N1ORK Orest 'Andy' Zajac