am still getting the exact same issue.
Also, I removed the poll from the site until this problem could be
resolved, so the referring url below is useless. However, you can still
see the poll at www.ioc.state.il.us/polltest2.cfm
TIA.
Sincerely,
Andrew
Webmaster
Illinois Comptroller's Office
www.IllinoisComptroller.com
-----Original Message-----
From: Andrew Peterson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 10:18 AM
To: CF-Talk
Subject: Pollster - Intermittent Error
Hi,
More often than not, I am receiving an error on the Flash Poll provided
by Macromedia in one of their more recent DevNet Subscription releases.
The error is in a CFC that has an SQL statement that aggregates the
responses and dumps them into the poll. The line the logs point to is
the one occupied by the WHERE clause in that SQL Statement (see below).
It seems to only have begun recently, so perhaps there is a timeout or
other mechanism that factors into pulling in a couple of thousand votes
into the poll. After all, the datasource is MS Access. I will try to
move to SQL Server - perhaps that is the problem. Any ideas?
The generic error in the Flash Pollster states "We are sorry, an error
has occurred and the poll will not be able to continue." The error log
is posted below.
Thanks in advance for any assistance. You can see the poll yourself at
www.ioc.state.il.us
Sincerely,
Andrew
Here's the query that is throwing the error:
<!---
Gets a Poll's aggregated responses.
@param pollId The ID of the Poll you want to retrieve responses for.
--->
<cffunction name="getAggregatedResponses"
returnType="query"
output="no"
hint="Gets a Poll's aggregated responses.">
<cfargument name="pollId" type="string" required="yes"/>
<cfset var q = ""/>
<cfquery name="q" datasource="#application.dataSource#">
SELECT
Options.optionText as label,
Options.sortOrder,
count(responses.responseId) as data
FROM
Responses RIGHT JOIN Options
ON
Responses.optionId = Options.optionId
WHERE
Options.optionId in (SELECT
Options.optionId
FROM
Options
WHERE
pollId = <cfqueryparam
value="#arguments.pollId#" maxLength="#sqlLengths.Polls_pollId#"/>)
GROUP BY
Options.sortOrder, Options.optionText
</cfquery>
<cfreturn q/>
</cffunction>
HERE IS THE ERROR MESSAGE IN THE LOG:
[Flash Remoting
MX]->coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error
Executing Database Query. at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:495) at
cfPolls2ecfc416965643$funcGETAGGREGATEDRESPONSES.runFunction(C:\web
app\prod\html\pollster\components\entities\Polls.cfc:235) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at
coldfusion.filter.SilentFilter.invoke(SilentFilter.java:44) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.j
ava:250) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:165) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:192) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:130) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1622) at
cfFlashHandler2ecfc1964209537$funcGETPOLLRESULTS.runFunction(C:\web
app\prod\html\pollster\components\handlers\FlashHandler.cfc:84) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at
coldfusion.filter.SilentFilter.invoke(SilentFilter.java:44) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.j
ava:250) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:165) at
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1768) at
cfFlashHandler2ecfc1964209537$funcGETPOLLINFO.runFunction(C:\web
app\prod\html\pollster\components\handlers\FlashHandler.cfc:23) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at
coldfusion.filter.SilentFilter.invoke(SilentFilter.java:44) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.j
ava:250) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at
coldfusion.filter.FlashComponentFilter.invoke(FlashComponentFilter.java:
48) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.FlashFilter.invoke(FlashFilter.java:75) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist
enceFilter.java:28) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.flash.FlashProxy.invokeComponent(FlashProxy.java:139) at
flashgateway.adapter.coldfusion.CFCAdapter.invokeFunction(CFCAdapter.jav
a:95) at
flashgateway.filter.AdapterFilter.invoke(AdapterFilter.java:266) at
flashgateway.filter.SecurityFilter.invoke(SecurityFilter.java:85) at
flashgateway.filter.LicenseFilter.invoke(LicenseFilter.java:58) at
flashgateway.filter.ErrorFilter.invoke(ErrorFilter.java:44) at
flashgateway.filter.LogFilter.invoke(LogFilter.java:43) at
flashgateway.filter.BatchProcessFilter.invoke(BatchProcessFilter.java:63
) at flashgateway.filter.DebugFilter.invoke(DebugFilter.java:38) at
flashgateway.filter.SerializationFilter.invoke(SerializationFilter.java:
59) at flashgateway.Gateway.invoke(Gateway.java:194) at
flashgateway.controller.GatewayServlet.service(GatewayServlet.java:56)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252
) at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527
) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:
192) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j
ava:348) at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java
:451) at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav
a:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Sincerely,
Andrew
Webmaster
Illinois Comptroller's Office
www.IllinoisComptroller.com
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]