arguments.Exception
Catch
Entries: 18
additional
Struct
SQL
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.2100
DriverName
stringMicrosoft SQL Server JDBC Driver 3.0
DriverVersion
string3.0.1301.101
Datasource
stringelitefixtures30_local
cause
Struct
Entries: 15
additional
Struct
SQL
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.2100
DriverName
stringMicrosoft SQL Server JDBC Driver 3.0
DriverVersion
string3.0.1301.101
Datasource
stringelitefixtures30_local
DataSource
stringelitefixtures30_local
Detail
stringSHUTDOWN is in progress.
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number6005
queryError
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
Sql
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
SQLState
stringS0002
StackTrace
string at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197):197 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493):1493 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390):390 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340):340 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575):4575 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400):1400 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179):179 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154):154 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322):322 at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:127):127 at railo.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:117):117 at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:222):222 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:233):233 at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687 at railo.runtime.tag.Query.doEndTag(Query.java:531):531 at cart_items_cfc$cf.udfCall(D:\Production\EliteFixtures30\components\cart_items.cfc:28):28 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547 at inc.udf_application_onsessionstart_cfm$cf.call(D:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm:86):86 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813 at app_defaults_cfm$cf.call(D:\Production\EliteFixtures30\app_defaults.cfm:123):123 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813 at application_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:100):100 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547 at application_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:38):38 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:388):388 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:114):114 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99):99 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589):589 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source):-1 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1 at java.lang.Thread.run(Unknown Source):-1
TagContext
Array
1
Struct
codePrintHTML
string26: LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id<br> 27: WHERE c.cartid = &lt;cfqueryparam cfsqltype=&quot;cf_sql_idstamp&quot; value=&quot;#arguments.cart_id#&quot;&gt;<br> <b>28: &lt;/cfquery&gt;</b><br> 29: <br> 30: &lt;cfreturn cartContent&gt;<br>
codePrintPlain
string26: LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id 27: WHERE c.cartid = <cfqueryparam cfsqltype="cf_sql_idstamp" value="#arguments.cart_id#"> 28: </cfquery> 29: 30: <cfreturn cartContent>
column
number0
id
string??
line
number28
Raw_Trace
stringcart_items_cfc$cf.udfCall(D:\Production\EliteFixtures30\components\cart_items.cfc:28)
template
stringD:\Production\EliteFixtures30\components\cart_items.cfc
type
stringcfml
2
Struct
codePrintHTML
string84: &lt;cfset session.cart_id = cookie_cart_id&gt;<br> 85: &lt;!---Getting anonymous users cart content---&gt;<br> <b>86: &lt;cfset get_anonymous_cart = request.factory.getComponent(&quot;cart_items&quot;).GetCartItemsByCartId(session.cart_id)&gt;&lt;!--- Load cart ---&gt;</b><br> 87: &lt;cfloop query=&quot;get_anonymous_cart&quot;&gt;<br> 88: &lt;cfif NOT isPromoProduct&gt;<br>
codePrintPlain
string84: <cfset session.cart_id = cookie_cart_id> 85: <!---Getting anonymous users cart content---> 86: <cfset get_anonymous_cart = request.factory.getComponent("cart_items").GetCartItemsByCartId(session.cart_id)><!--- Load cart ---> 87: <cfloop query="get_anonymous_cart"> 88: <cfif NOT isPromoProduct>
column
number0
id
string??
line
number86
Raw_Trace
stringinc.udf_application_onsessionstart_cfm$cf.call(D:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm:86)
template
stringD:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm
type
stringcfml
3
Struct
codePrintHTML
string121: &lt;!--- &lt;cflog application=&quot;yes&quot; date=&quot;yes&quot; time=&quot;yes&quot; type=&quot;information&quot; file=&quot;visit#DateFormat(Now(), &quot;yyyymmdd&quot;)#&quot; thread=&quot;yes&quot; text=&quot;Start #cgi.PATH_INFO#?#cgi.QUERY_STRING#&quot;&gt; ---&gt;<br> 122: <br> <b>123: &lt;cfinclude template=&quot;inc/udf_application_onSessionStart.cfm&quot;&gt;</b><br> 124: &lt;cfset REQUEST.REMOTE_ADDR = CGI.REMOTE_ADDR/&gt;<br> 125: &lt;cfif IsDefined(&quot;CGI.HTTP_CF_CONNECTING_IP&quot;) AND CGI.HTTP_CF_CONNECTING_IP NEQ &quot;&quot;&gt;<br>
codePrintPlain
string121: <!--- <cflog application="yes" date="yes" time="yes" type="information" file="visit#DateFormat(Now(), "yyyymmdd")#" thread="yes" text="Start #cgi.PATH_INFO#?#cgi.QUERY_STRING#"> ---> 122: 123: <cfinclude template="inc/udf_application_onSessionStart.cfm"> 124: <cfset REQUEST.REMOTE_ADDR = CGI.REMOTE_ADDR/> 125: <cfif IsDefined("CGI.HTTP_CF_CONNECTING_IP") AND CGI.HTTP_CF_CONNECTING_IP NEQ "">
column
number0
id
string??
line
number123
Raw_Trace
stringapp_defaults_cfm$cf.call(D:\Production\EliteFixtures30\app_defaults.cfm:123)
template
stringD:\Production\EliteFixtures30\app_defaults.cfm
type
stringcfml
4
Struct
codePrintHTML
string98: &lt;cfinclude template=&quot;app_global.cfm&quot;&gt;<br> 99: &lt;cfinclude template=&quot;app_function.cfm&quot;&gt;<br> <b>100: &lt;cfinclude template=&quot;app_defaults.cfm&quot;&gt;</b><br> 101: &lt;cfif CGI_QUERY_STRING NEQ CGI.QUERY_STRING&gt;<br> 102: &lt;cflocation url=&quot;#request.base##redirect_url#?#CGI_QUERY_STRING#&quot; addtoken=&quot;no&quot; statuscode=&quot;301&quot;&gt;<br>
codePrintPlain
string98: <cfinclude template="app_global.cfm"> 99: <cfinclude template="app_function.cfm"> 100: <cfinclude template="app_defaults.cfm"> 101: <cfif CGI_QUERY_STRING NEQ CGI.QUERY_STRING> 102: <cflocation url="#request.base##redirect_url#?#CGI_QUERY_STRING#" addtoken="no" statuscode="301">
column
number0
id
string??
line
number100
Raw_Trace
stringapplication_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:100)
template
stringD:\Production\EliteFixtures30\application.cfc
type
stringcfml
5
Struct
codePrintHTML
string36: &lt;cfset REQUEST.SessionTimeout = Session.System.SessionTimeout /&gt;<br> 37: &lt;cfset This.sessiontimeout=REQUEST.SessionTimeout&gt;<br> <b>38: &lt;cfset this.InitVariables()&gt;</b><br> 39: &lt;/cffunction&gt;<br> 40: <br>
codePrintPlain
string36: <cfset REQUEST.SessionTimeout = Session.System.SessionTimeout /> 37: <cfset This.sessiontimeout=REQUEST.SessionTimeout> 38: <cfset this.InitVariables()> 39: </cffunction> 40:
column
number0
id
string??
line
number38
Raw_Trace
stringapplication_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:38)
template
stringD:\Production\EliteFixtures30\application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringelitefixtures30_local
Detail
stringSHUTDOWN is in progress.
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
name
stringonRequestStart
NativeErrorCode
number6005
queryError
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
rootCause
Struct
Entries: 15
additional
Struct
SQL
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.2100
DriverName
stringMicrosoft SQL Server JDBC Driver 3.0
DriverVersion
string3.0.1301.101
Datasource
stringelitefixtures30_local
DataSource
stringelitefixtures30_local
Detail
stringSHUTDOWN is in progress.
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number6005
queryError
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
Sql
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
SQLState
stringS0002
StackTrace
string at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197):197 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493):1493 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390):390 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340):340 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575):4575 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400):1400 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179):179 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154):154 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322):322 at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:127):127 at railo.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:117):117 at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:222):222 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:233):233 at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687 at railo.runtime.tag.Query.doEndTag(Query.java:531):531 at cart_items_cfc$cf.udfCall(D:\Production\EliteFixtures30\components\cart_items.cfc:28):28 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547 at inc.udf_application_onsessionstart_cfm$cf.call(D:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm:86):86 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813 at app_defaults_cfm$cf.call(D:\Production\EliteFixtures30\app_defaults.cfm:123):123 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813 at application_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:100):100 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547 at application_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:38):38 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:388):388 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:114):114 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99):99 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589):589 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source):-1 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1 at java.lang.Thread.run(Unknown Source):-1
TagContext
Array
1
Struct
codePrintHTML
string26: LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id<br> 27: WHERE c.cartid = &lt;cfqueryparam cfsqltype=&quot;cf_sql_idstamp&quot; value=&quot;#arguments.cart_id#&quot;&gt;<br> <b>28: &lt;/cfquery&gt;</b><br> 29: <br> 30: &lt;cfreturn cartContent&gt;<br>
codePrintPlain
string26: LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id 27: WHERE c.cartid = <cfqueryparam cfsqltype="cf_sql_idstamp" value="#arguments.cart_id#"> 28: </cfquery> 29: 30: <cfreturn cartContent>
column
number0
id
string??
line
number28
Raw_Trace
stringcart_items_cfc$cf.udfCall(D:\Production\EliteFixtures30\components\cart_items.cfc:28)
template
stringD:\Production\EliteFixtures30\components\cart_items.cfc
type
stringcfml
2
Struct
codePrintHTML
string84: &lt;cfset session.cart_id = cookie_cart_id&gt;<br> 85: &lt;!---Getting anonymous users cart content---&gt;<br> <b>86: &lt;cfset get_anonymous_cart = request.factory.getComponent(&quot;cart_items&quot;).GetCartItemsByCartId(session.cart_id)&gt;&lt;!--- Load cart ---&gt;</b><br> 87: &lt;cfloop query=&quot;get_anonymous_cart&quot;&gt;<br> 88: &lt;cfif NOT isPromoProduct&gt;<br>
codePrintPlain
string84: <cfset session.cart_id = cookie_cart_id> 85: <!---Getting anonymous users cart content---> 86: <cfset get_anonymous_cart = request.factory.getComponent("cart_items").GetCartItemsByCartId(session.cart_id)><!--- Load cart ---> 87: <cfloop query="get_anonymous_cart"> 88: <cfif NOT isPromoProduct>
column
number0
id
string??
line
number86
Raw_Trace
stringinc.udf_application_onsessionstart_cfm$cf.call(D:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm:86)
template
stringD:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm
type
stringcfml
3
Struct
codePrintHTML
string121: &lt;!--- &lt;cflog application=&quot;yes&quot; date=&quot;yes&quot; time=&quot;yes&quot; type=&quot;information&quot; file=&quot;visit#DateFormat(Now(), &quot;yyyymmdd&quot;)#&quot; thread=&quot;yes&quot; text=&quot;Start #cgi.PATH_INFO#?#cgi.QUERY_STRING#&quot;&gt; ---&gt;<br> 122: <br> <b>123: &lt;cfinclude template=&quot;inc/udf_application_onSessionStart.cfm&quot;&gt;</b><br> 124: &lt;cfset REQUEST.REMOTE_ADDR = CGI.REMOTE_ADDR/&gt;<br> 125: &lt;cfif IsDefined(&quot;CGI.HTTP_CF_CONNECTING_IP&quot;) AND CGI.HTTP_CF_CONNECTING_IP NEQ &quot;&quot;&gt;<br>
codePrintPlain
string121: <!--- <cflog application="yes" date="yes" time="yes" type="information" file="visit#DateFormat(Now(), "yyyymmdd")#" thread="yes" text="Start #cgi.PATH_INFO#?#cgi.QUERY_STRING#"> ---> 122: 123: <cfinclude template="inc/udf_application_onSessionStart.cfm"> 124: <cfset REQUEST.REMOTE_ADDR = CGI.REMOTE_ADDR/> 125: <cfif IsDefined("CGI.HTTP_CF_CONNECTING_IP") AND CGI.HTTP_CF_CONNECTING_IP NEQ "">
column
number0
id
string??
line
number123
Raw_Trace
stringapp_defaults_cfm$cf.call(D:\Production\EliteFixtures30\app_defaults.cfm:123)
template
stringD:\Production\EliteFixtures30\app_defaults.cfm
type
stringcfml
4
Struct
codePrintHTML
string98: &lt;cfinclude template=&quot;app_global.cfm&quot;&gt;<br> 99: &lt;cfinclude template=&quot;app_function.cfm&quot;&gt;<br> <b>100: &lt;cfinclude template=&quot;app_defaults.cfm&quot;&gt;</b><br> 101: &lt;cfif CGI_QUERY_STRING NEQ CGI.QUERY_STRING&gt;<br> 102: &lt;cflocation url=&quot;#request.base##redirect_url#?#CGI_QUERY_STRING#&quot; addtoken=&quot;no&quot; statuscode=&quot;301&quot;&gt;<br>
codePrintPlain
string98: <cfinclude template="app_global.cfm"> 99: <cfinclude template="app_function.cfm"> 100: <cfinclude template="app_defaults.cfm"> 101: <cfif CGI_QUERY_STRING NEQ CGI.QUERY_STRING> 102: <cflocation url="#request.base##redirect_url#?#CGI_QUERY_STRING#" addtoken="no" statuscode="301">
column
number0
id
string??
line
number100
Raw_Trace
stringapplication_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:100)
template
stringD:\Production\EliteFixtures30\application.cfc
type
stringcfml
5
Struct
codePrintHTML
string36: &lt;cfset REQUEST.SessionTimeout = Session.System.SessionTimeout /&gt;<br> 37: &lt;cfset This.sessiontimeout=REQUEST.SessionTimeout&gt;<br> <b>38: &lt;cfset this.InitVariables()&gt;</b><br> 39: &lt;/cffunction&gt;<br> 40: <br>
codePrintPlain
string36: <cfset REQUEST.SessionTimeout = Session.System.SessionTimeout /> 37: <cfset This.sessiontimeout=REQUEST.SessionTimeout> 38: <cfset this.InitVariables()> 39: </cffunction> 40:
column
number0
id
string??
line
number38
Raw_Trace
stringapplication_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:38)
template
stringD:\Production\EliteFixtures30\application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
string SELECT c.id, c.cartid, c.product_id, c.itemprice AS price_discount, c.itemqty AS quantity, c.created_date, c.updated_date, c.active_status, c.isStoredCart, c.customer_id, c.user_ip, c.isPromoProduct, m.URLDisplayName, p.sku, p.name_short, p.family, p.finish_1, p.description_1, 'USD' AS CurrencyCode, p.weight_shipment FROM cart_items c WITH (NOLOCK) LEFT JOIN products p WITH (NOLOCK) ON c.product_id = p.id LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id WHERE c.cartid = 'A2A38834-2C94-4AFB-8A19-2BBCCCF97C1F'
SQLState
stringS0002
StackTrace
string at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197):197 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493):1493 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390):390 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340):340 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575):4575 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400):1400 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179):179 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154):154 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322):322 at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:127):127 at railo.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:117):117 at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:222):222 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:233):233 at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687 at railo.runtime.tag.Query.doEndTag(Query.java:531):531 at cart_items_cfc$cf.udfCall(D:\Production\EliteFixtures30\components\cart_items.cfc:28):28 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547 at inc.udf_application_onsessionstart_cfm$cf.call(D:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm:86):86 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813 at app_defaults_cfm$cf.call(D:\Production\EliteFixtures30\app_defaults.cfm:123):123 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813 at application_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:100):100 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547 at application_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:38):38 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93 at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307 at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208 at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:388):388 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:114):114 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99):99 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589):589 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source):-1 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1 at java.lang.Thread.run(Unknown Source):-1
TagContext
Array
1
Struct
codePrintHTML
string26: LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id<br> 27: WHERE c.cartid = &lt;cfqueryparam cfsqltype=&quot;cf_sql_idstamp&quot; value=&quot;#arguments.cart_id#&quot;&gt;<br> <b>28: &lt;/cfquery&gt;</b><br> 29: <br> 30: &lt;cfreturn cartContent&gt;<br>
codePrintPlain
string26: LEFT JOIN manufacturers m WITH (NOLOCK) ON p.manufacturer_id = m.id 27: WHERE c.cartid = <cfqueryparam cfsqltype="cf_sql_idstamp" value="#arguments.cart_id#"> 28: </cfquery> 29: 30: <cfreturn cartContent>
column
number0
id
string??
line
number28
Raw_Trace
stringcart_items_cfc$cf.udfCall(D:\Production\EliteFixtures30\components\cart_items.cfc:28)
template
stringD:\Production\EliteFixtures30\components\cart_items.cfc
type
stringcfml
2
Struct
codePrintHTML
string84: &lt;cfset session.cart_id = cookie_cart_id&gt;<br> 85: &lt;!---Getting anonymous users cart content---&gt;<br> <b>86: &lt;cfset get_anonymous_cart = request.factory.getComponent(&quot;cart_items&quot;).GetCartItemsByCartId(session.cart_id)&gt;&lt;!--- Load cart ---&gt;</b><br> 87: &lt;cfloop query=&quot;get_anonymous_cart&quot;&gt;<br> 88: &lt;cfif NOT isPromoProduct&gt;<br>
codePrintPlain
string84: <cfset session.cart_id = cookie_cart_id> 85: <!---Getting anonymous users cart content---> 86: <cfset get_anonymous_cart = request.factory.getComponent("cart_items").GetCartItemsByCartId(session.cart_id)><!--- Load cart ---> 87: <cfloop query="get_anonymous_cart"> 88: <cfif NOT isPromoProduct>
column
number0
id
string??
line
number86
Raw_Trace
stringinc.udf_application_onsessionstart_cfm$cf.call(D:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm:86)
template
stringD:\Production\EliteFixtures30\inc\udf_application_onSessionStart.cfm
type
stringcfml
3
Struct
codePrintHTML
string121: &lt;!--- &lt;cflog application=&quot;yes&quot; date=&quot;yes&quot; time=&quot;yes&quot; type=&quot;information&quot; file=&quot;visit#DateFormat(Now(), &quot;yyyymmdd&quot;)#&quot; thread=&quot;yes&quot; text=&quot;Start #cgi.PATH_INFO#?#cgi.QUERY_STRING#&quot;&gt; ---&gt;<br> 122: <br> <b>123: &lt;cfinclude template=&quot;inc/udf_application_onSessionStart.cfm&quot;&gt;</b><br> 124: &lt;cfset REQUEST.REMOTE_ADDR = CGI.REMOTE_ADDR/&gt;<br> 125: &lt;cfif IsDefined(&quot;CGI.HTTP_CF_CONNECTING_IP&quot;) AND CGI.HTTP_CF_CONNECTING_IP NEQ &quot;&quot;&gt;<br>
codePrintPlain
string121: <!--- <cflog application="yes" date="yes" time="yes" type="information" file="visit#DateFormat(Now(), "yyyymmdd")#" thread="yes" text="Start #cgi.PATH_INFO#?#cgi.QUERY_STRING#"> ---> 122: 123: <cfinclude template="inc/udf_application_onSessionStart.cfm"> 124: <cfset REQUEST.REMOTE_ADDR = CGI.REMOTE_ADDR/> 125: <cfif IsDefined("CGI.HTTP_CF_CONNECTING_IP") AND CGI.HTTP_CF_CONNECTING_IP NEQ "">
column
number0
id
string??
line
number123
Raw_Trace
stringapp_defaults_cfm$cf.call(D:\Production\EliteFixtures30\app_defaults.cfm:123)
template
stringD:\Production\EliteFixtures30\app_defaults.cfm
type
stringcfml
4
Struct
codePrintHTML
string98: &lt;cfinclude template=&quot;app_global.cfm&quot;&gt;<br> 99: &lt;cfinclude template=&quot;app_function.cfm&quot;&gt;<br> <b>100: &lt;cfinclude template=&quot;app_defaults.cfm&quot;&gt;</b><br> 101: &lt;cfif CGI_QUERY_STRING NEQ CGI.QUERY_STRING&gt;<br> 102: &lt;cflocation url=&quot;#request.base##redirect_url#?#CGI_QUERY_STRING#&quot; addtoken=&quot;no&quot; statuscode=&quot;301&quot;&gt;<br>
codePrintPlain
string98: <cfinclude template="app_global.cfm"> 99: <cfinclude template="app_function.cfm"> 100: <cfinclude template="app_defaults.cfm"> 101: <cfif CGI_QUERY_STRING NEQ CGI.QUERY_STRING> 102: <cflocation url="#request.base##redirect_url#?#CGI_QUERY_STRING#" addtoken="no" statuscode="301">
column
number0
id
string??
line
number100
Raw_Trace
stringapplication_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:100)
template
stringD:\Production\EliteFixtures30\application.cfc
type
stringcfml
5
Struct
codePrintHTML
string36: &lt;cfset REQUEST.SessionTimeout = Session.System.SessionTimeout /&gt;<br> 37: &lt;cfset This.sessiontimeout=REQUEST.SessionTimeout&gt;<br> <b>38: &lt;cfset this.InitVariables()&gt;</b><br> 39: &lt;/cffunction&gt;<br> 40: <br>
codePrintPlain
string36: <cfset REQUEST.SessionTimeout = Session.System.SessionTimeout /> 37: <cfset This.sessiontimeout=REQUEST.SessionTimeout> 38: <cfset this.InitVariables()> 39: </cffunction> 40:
column
number0
id
string??
line
number38
Raw_Trace
stringapplication_cfc$cf.udfCall(D:\Production\EliteFixtures30\application.cfc:38)
template
stringD:\Production\EliteFixtures30\application.cfc
type
stringcfml
type
stringdatabase
where
string