Ok, I have a page that loads most of the time. However, occasionally it gives
an error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested
type.
In verbose debugging the query that fails should be no problem whatsoever and
in fact in runs fine in SQL but only 70% of the time when the page is
refreshed.
We are on CF8 Enterprise with two instances.
What could be happening?
Here's the verbose error message:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type.
The error occurred in
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:
line 63
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:
line 54
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:
line 1
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:
line 210
Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:
line 5
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:
line 63
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:
line 54
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:
line 1
Called from
C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:
line 210
Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:
line 5
319 : <cfquery name="qPhotographer" dataSource="#ipi_dsn#">
320 : SELECT * FROM ipi_photographers
321 : WHERE id = <cfqueryparam CFSQLType="CF_SQL_INTEGER"
value="#arguments.photographerid#" />
322 : </cfquery>
323 : <cfreturn qPhotographer />
SQLSTATE HY000
SQL SELECT * FROM ipi_photographers WHERE id = (param 1)
DATASOURCE photoeyecom
Resources:
* 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/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16
Remote Address 10.10.47.254
Referrer
Date/Time 20-Apr-11 01:08 AM
Stack Trace
at
cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162)
at
cfdsp_search_results2ecfm265917465.._factor0(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:63)
at
cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:54)
at
cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:1)
at
cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210)
at
cfsearch_results2ecfm1795000755.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:5)
at
cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162)
at
cfdsp_search_results2ecfm265917465._factor0(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:63)
at
cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results..cfm:54)
at
cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:1)
at
cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210)
at
cfsearch_results2ecfm1795000755.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:5)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Value can not be
converted to requested type.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.base.BaseData.getBoolean(Unknown Source)
at macromedia.jdbc.base.BaseData.getObject(Unknown Source)
at macromedia.jdbc.base.BaseResultSet.getObject(Unknown Source)
at
com.intergral.fusionreactor.jdbc.g.getObject(ResultSetSurrogate.java:553)
at coldfusion.sql.QueryTable.populate(QueryTable.java:352)
at coldfusion.sql.QueryTable.populate(QueryTable.java:217)
at coldfusion.sql.Executive.getRowSet(Executive.java:466)
at coldfusion.sql.Executive.executeQuery(Executive.java:1252)
at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
at coldfusion.sql.Executive.executeQuery(Executive.java:939)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
at
cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2471)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165)
at
cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272)
at
cfdsp_search_results2ecfm265917465._factor0(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:63)
at
cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:54)
at
cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
at
cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
at
cfsearch_results2ecfm1795000755.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:5)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:282)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at
com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:386)
at
com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:264)
at
com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:174)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343859
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
