Log analyzer plugin - datasource.log - How to see query which causes error?


#1

Hi,
in the datasource.log of the log analyzer plugin I have this error.
How do I find the corresponding query?
Regards
Thorsten

datasource.log - *query tag;cannot cast [m] string to a number 
value;lucee.runtime.exp.CasterException: cannot cast [m] string to a number 
value* 
Message query tag;cannot cast [m] string to a number 
value;lucee.runtime.exp.CasterException: cannot cast [m] string to a number 
value 
Last occurence 2 days ago: 4 Mar. 2017 02:49:56 
Thread name ajp-bio-8009-exec-14 
Type ERROR 
File /wheels/model/read.cfm, line 203 
Occurences 22, from 26 Feb. 2017 00:28 untill 4 Mar. 2017 02:49 

Detail "ERROR","ajp-bio-8009-exec-14","02/26/2017","00:28:05","","query 
tag;cannot cast [m] string to a number 
value;lucee.runtime.exp.CasterException: cannot cast [m] string to a number 
value
at lucee.runtime.op.Caster.toDoubleValue(Caster.java:539)
at lucee.runtime.op.Caster.toIntValue(Caster.java:807)
at lucee.runtime.op.Caster.toIntValue(Caster.java:764)
at lucee.runtime.op.Caster.toInteger(Caster.java:4248)
at lucee.runtime.db.SQLCaster.setValue(SQLCaster.java:277)
at lucee.runtime.type.QueryImpl.setItems(QueryImpl.java:361)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:271)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:218)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:833)
at lucee.runtime.tag.Query.doEndTag(Query.java:593)
at wheels.model.adapters.base_cfc$cf.udfCall2(
*/wheels/model/adapters/Base.cfc:302*)
at 
wheels.model.adapters.base_cfc$cf.udfCall(/wheels/model/adapters/Base.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)
at 
lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:781)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:823)
at lucee. 
runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)
at wheels.model.adapters.sqlserver_cfc$cf.udfCall(
*/wheels/model/adapters/SQLServer.cfc:205*)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1934)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:823)
at lucee. 
runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)
at wheels.model.read_cfm$cf.udfCall(*/wheels/model/read.cfm:203*)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1934)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:823)
at lucee. 
runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)
at models.gender_cfc$cf.udfCall(*/models/Gender.cfc:53*)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:696)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:754) 

at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)
at controllers.jobs_cfc$cf.udfCall1(*/controllers/Jobs.cfc:124*)
at controllers.jobs_cfc$cf.udfCall(/controllers/Jobs.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:204)
at lucee.runtime.tag.Invoke.doFunction(Invoke.java:235)
at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:202)
at wheels.global.cfml_cfm$cf.udfCall2(*/wheels/global/cfml.cfm:164*)
at wheels.global.cfml_cfm$cf.udfCall(/wheels/global/cfml.cfm)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)
at 
lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:781)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:823)
at lucee. 
runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)
at wheels.controller.processing_cfm$cf.udfCall(
*/wheels/controller/processing.cfm:128*)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)
at 
lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:781)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:823)
at lucee. 
runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)
at wheels.controller.processing_cfm$cf.udfCall(
*/wheels/controller/processing.cfm:95*)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:696)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:754) 

at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)
at wheels.dispatch.request_cfm$cf.udfCall1(
*/wheels/dispatch/request.cfm:198*)
at wheels.dispatch.request_cfm$cf.udfCall(/wheels/dispatch/request.cfm)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:696)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)
at 
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:754) 

at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)
at wheels.index_cfm$cf.call(*/wheels/index.cfm:1*)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)
at index_cfm$cf.call(*/index.cfm:1*)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)
at wheels.events.onrequest_cfm$cf.udfCall(*/wheels/events/onrequest.cfm:1*)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:696)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:422)
at 
lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:224)
at 
lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2293)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2284)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2252)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:891)
at 
lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) 

at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515) 

at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
"

#2

How do I find the corresponding query?

/wheels/model/read.cfm, line 203

#3

Hi Phillip,

as I use the cfwheels framework, the read.cfm is the framework code and not
the actual query I would like to see.

But thanks for your input
Thorsten


#4

Go to Lucee admin. Look at the log. Select the command that went bad. Look
at the execution order and queries. Find the error. Fix the error. Become
superhero.

(Last one optional). :slight_smile: