struct
EVENTNAME onRequest
EXCEPTION
struct
Cause
struct
Cause
struct
ErrorCode 1205
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState 40001
StackTrace java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59) at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6) at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1095
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1059
RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 526
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2703
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 525
RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CFQUERY
LINE 1305
RAW_TRACE at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305)
TEMPLATE E:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 59
RAW_TRACE at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_CATEGORY
LINE 6
RAW_TRACE at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
20
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
22
struct
COLUMN 0
ID CFINCLUDE
LINE 220
RAW_TRACE at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220)
TEMPLATE E:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
DataSource koalasql
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
ErrorCode 40001
Exceptions
array
1
struct
class java.sql.SQLTransactionRollbackException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Message Error Executing Database Query.
NativeErrorCode 1205
RootCause
struct
ErrorCode 1205
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState 40001
StackTrace java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59) at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6) at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1095
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1059
RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 526
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2703
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 525
RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CFQUERY
LINE 1305
RAW_TRACE at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305)
TEMPLATE E:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 59
RAW_TRACE at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_CATEGORY
LINE 6
RAW_TRACE at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
20
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
22
struct
COLUMN 0
ID CFINCLUDE
LINE 220
RAW_TRACE at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220)
TEMPLATE E:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
SQLState 40001
Sql SELECT DISTINCT webstyle , max(style_id) as style_id , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage FROM [dbo].[web_all_products_stratus] WHERE 1=1 --AND pictureid is not null --Search Results AND style_id IN ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) , (param 70) , (param 71) , (param 72) , (param 73) , (param 74) , (param 75) , (param 76) , (param 77) , (param 78) , (param 79) , (param 80) , (param 81) , (param 82) , (param 83) , (param 84) , (param 85) , (param 86) , (param 87) , (param 88) , (param 89) , (param 90) , (param 91) , (param 92) , (param 93) , (param 94) , (param 95) , (param 96) , (param 97) , (param 98) , (param 99) , (param 100) , (param 101) , (param 102) , (param 103) , (param 104) , (param 105) , (param 106) , (param 107) , (param 108) , (param 109) , (param 110) , (param 111) , (param 112) , (param 113) , (param 114) , (param 115) , (param 116) , (param 117) , (param 118) , (param 119) , (param 120) , (param 121) , (param 122) , (param 123) , (param 124) , (param 125) , (param 126) , (param 127) , (param 128) , (param 129) , (param 130) , (param 131) , (param 132) , (param 133) , (param 134) , (param 135) , (param 136) , (param 137) , (param 138) , (param 139) , (param 140) , (param 141) , (param 142) , (param 143) , (param 144) , (param 145) , (param 146) , (param 147) , (param 148) , (param 149) , (param 150) , (param 151) , (param 152) , (param 153) , (param 154) , (param 155) , (param 156) , (param 157) , (param 158) , (param 159) , (param 160) , (param 161) , (param 162) , (param 163) , (param 164) , (param 165) , (param 166) , (param 167) , (param 168) , (param 169) , (param 170) , (param 171) , (param 172) , (param 173) , (param 174) , (param 175) , (param 176) , (param 177) , (param 178) , (param 179) , (param 180) , (param 181) , (param 182) , (param 183) , (param 184) , (param 185) , (param 186) , (param 187) , (param 188) , (param 189) , (param 190) , (param 191) , (param 192) , (param 193) , (param 194) , (param 195) , (param 196) , (param 197) , (param 198) , (param 199) , (param 200) , (param 201) , (param 202) , (param 203) , (param 204) , (param 205) , (param 206) , (param 207) , (param 208) , (param 209) , (param 210) , (param 211) , (param 212) , (param 213) , (param 214) , (param 215) , (param 216) , (param 217) , (param 218) , (param 219) , (param 220) , (param 221) , (param 222) , (param 223) , (param 224) , (param 225) , (param 226) , (param 227) , (param 228) , (param 229) , (param 230) , (param 231) , (param 232) , (param 233) , (param 234) , (param 235) , (param 236) , (param 237) , (param 238) , (param 239) , (param 240) , (param 241) , (param 242) , (param 243) ) and ltrim(rtrim(dept)) = (param 244) and ltrim(rtrim(typ)) = (param 245) and ltrim(rtrim(subtyp1)) = (param 246) and ltrim(rtrim(subtyp2)) = (param 247) and ltrim(rtrim(subtyp3)) = 'EMPTY' AND upper(Sale) = 'Y' AND ( 1=2 OR REPLACE(REPLACE(upper(OF1), '.', ' '), '+', ' ') like (param 248) ) GROUP BY WEBSTYLE
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59) at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6) at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) ... 74 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 1305
RAW_TRACE at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305)
TEMPLATE E:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 59
RAW_TRACE at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_CATEGORY
LINE 6
RAW_TRACE at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 220
RAW_TRACE at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220)
TEMPLATE E:\websites\stratusecommerce\application.cfc
TYPE CFML
7
struct
COLUMN 0
ID ??
LINE 1095
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1059
RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
18
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 526
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
19
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
20
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
21
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2703
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
22
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 525
RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
where (param 1) = [type='IN', class='java.lang.Double', value='109211.0', sqltype='CF_SQL_FLOAT'] , (param 2) = [type='IN', class='java.lang.Double', value='109220.0', sqltype='CF_SQL_FLOAT'] , (param 3) = [type='IN', class='java.lang.Double', value='24135.0', sqltype='CF_SQL_FLOAT'] , (param 4) = [type='IN', class='java.lang.Double', value='109241.0', sqltype='CF_SQL_FLOAT'] , (param 5) = [type='IN', class='java.lang.Double', value='102355.0', sqltype='CF_SQL_FLOAT'] , (param 6) = [type='IN', class='java.lang.Double', value='59056.0', sqltype='CF_SQL_FLOAT'] , (param 7) = [type='IN', class='java.lang.Double', value='66436.0', sqltype='CF_SQL_FLOAT'] , (param 8) = [type='IN', class='java.lang.Double', value='63958.0', sqltype='CF_SQL_FLOAT'] , (param 9) = [type='IN', class='java.lang.Double', value='103809.0', sqltype='CF_SQL_FLOAT'] , (param 10) = [type='IN', class='java.lang.Double', value='103853.0', sqltype='CF_SQL_FLOAT'] , (param 11) = [type='IN', class='java.lang.Double', value='104900.0', sqltype='CF_SQL_FLOAT'] , (param 12) = [type='IN', class='java.lang.Double', value='109137.0', sqltype='CF_SQL_FLOAT'] , (param 13) = [type='IN', class='java.lang.Double', value='71891.0', sqltype='CF_SQL_FLOAT'] , (param 14) = [type='IN', class='java.lang.Double', value='44090.0', sqltype='CF_SQL_FLOAT'] , (param 15) = [type='IN', class='java.lang.Double', value='109064.0', sqltype='CF_SQL_FLOAT'] , (param 16) = [type='IN', class='java.lang.Double', value='102357.0', sqltype='CF_SQL_FLOAT'] , (param 17) = [type='IN', class='java.lang.Double', value='105660.0', sqltype='CF_SQL_FLOAT'] , (param 18) = [type='IN', class='java.lang.Double', value='104470.0', sqltype='CF_SQL_FLOAT'] , (param 19) = [type='IN', class='java.lang.Double', value='98833.0', sqltype='CF_SQL_FLOAT'] , (param 20) = [type='IN', class='java.lang.Double', value='109035.0', sqltype='CF_SQL_FLOAT'] , (param 21) = [type='IN', class='java.lang.Double', value='57837.0', sqltype='CF_SQL_FLOAT'] , (param 22) = [type='IN', class='java.lang.Double', value='67635.0', sqltype='CF_SQL_FLOAT'] , (param 23) = [type='IN', class='java.lang.Double', value='102487.0', sqltype='CF_SQL_FLOAT'] , (param 24) = [type='IN', class='java.lang.Double', value='104708.0', sqltype='CF_SQL_FLOAT'] , (param 25) = [type='IN', class='java.lang.Double', value='103719.0', sqltype='CF_SQL_FLOAT'] , (param 26) = [type='IN', class='java.lang.Double', value='103720.0', sqltype='CF_SQL_FLOAT'] , (param 27) = [type='IN', class='java.lang.Double', value='87669.0', sqltype='CF_SQL_FLOAT'] , (param 28) = [type='IN', class='java.lang.Double', value='102748.0', sqltype='CF_SQL_FLOAT'] , (param 29) = [type='IN', class='java.lang.Double', value='104713.0', sqltype='CF_SQL_FLOAT'] , (param 30) = [type='IN', class='java.lang.Double', value='104717.0', sqltype='CF_SQL_FLOAT'] , (param 31) = [type='IN', class='java.lang.Double', value='108477.0', sqltype='CF_SQL_FLOAT'] , (param 32) = [type='IN', class='java.lang.Double', value='24139.0', sqltype='CF_SQL_FLOAT'] , (param 33) = [type='IN', class='java.lang.Double', value='103949.0', sqltype='CF_SQL_FLOAT'] , (param 34) = [type='IN', class='java.lang.Double', value='97756.0', sqltype='CF_SQL_FLOAT'] , (param 35) = [type='IN', class='java.lang.Double', value='103581.0', sqltype='CF_SQL_FLOAT'] , (param 36) = [type='IN', class='java.lang.Double', value='102363.0', sqltype='CF_SQL_FLOAT'] , (param 37) = [type='IN', class='java.lang.Double', value='103422.0', sqltype='CF_SQL_FLOAT'] , (param 38) = [type='IN', class='java.lang.Double', value='107572.0', sqltype='CF_SQL_FLOAT'] , (param 39) = [type='IN', class='java.lang.Double', value='107574.0', sqltype='CF_SQL_FLOAT'] , (param 40) = [type='IN', class='java.lang.Double', value='108589.0', sqltype='CF_SQL_FLOAT'] , (param 41) = [type='IN', class='java.lang.Double', value='52786.0', sqltype='CF_SQL_FLOAT'] , (param 42) = [type='IN', class='java.lang.Double', value='109295.0', sqltype='CF_SQL_FLOAT'] , (param 43) = [type='IN', class='java.lang.Double', value='105318.0', sqltype='CF_SQL_FLOAT'] , (param 44) = [type='IN', class='java.lang.Double', value='106316.0', sqltype='CF_SQL_FLOAT'] , (param 45) = [type='IN', class='java.lang.Double', value='107029.0', sqltype='CF_SQL_FLOAT'] , (param 46) = [type='IN', class='java.lang.Double', value='46051.0', sqltype='CF_SQL_FLOAT'] , (param 47) = [type='IN', class='java.lang.Double', value='107487.0', sqltype='CF_SQL_FLOAT'] , (param 48) = [type='IN', class='java.lang.Double', value='107573.0', sqltype='CF_SQL_FLOAT'] , (param 49) = [type='IN', class='java.lang.Double', value='101546.0', sqltype='CF_SQL_FLOAT'] , (param 50) = [type='IN', class='java.lang.Double', value='105128.0', sqltype='CF_SQL_FLOAT'] , (param 51) = [type='IN', class='java.lang.Double', value='106958.0', sqltype='CF_SQL_FLOAT'] , (param 52) = [type='IN', class='java.lang.Double', value='109274.0', sqltype='CF_SQL_FLOAT'] , (param 53) = [type='IN', class='java.lang.Double', value='24132.0', sqltype='CF_SQL_FLOAT'] , (param 54) = [type='IN', class='java.lang.Double', value='32159.0', sqltype='CF_SQL_FLOAT'] , (param 55) = [type='IN', class='java.lang.Double', value='50518.0', sqltype='CF_SQL_FLOAT'] , (param 56) = [type='IN', class='java.lang.Double', value='65139.0', sqltype='CF_SQL_FLOAT'] , (param 57) = [type='IN', class='java.lang.Double', value='108756.0', sqltype='CF_SQL_FLOAT'] , (param 58) = [type='IN', class='java.lang.Double', value='107483.0', sqltype='CF_SQL_FLOAT'] , (param 59) = [type='IN', class='java.lang.Double', value='108642.0', sqltype='CF_SQL_FLOAT'] , (param 60) = [type='IN', class='java.lang.Double', value='59656.0', sqltype='CF_SQL_FLOAT'] , (param 61) = [type='IN', class='java.lang.Double', value='60237.0', sqltype='CF_SQL_FLOAT'] , (param 62) = [type='IN', class='java.lang.Double', value='104125.0', sqltype='CF_SQL_FLOAT'] , (param 63) = [type='IN', class='java.lang.Double', value='108928.0', sqltype='CF_SQL_FLOAT'] , (param 64) = [type='IN', class='java.lang.Double', value='103504.0', sqltype='CF_SQL_FLOAT'] , (param 65) = [type='IN', class='java.lang.Double', value='101153.0', sqltype='CF_SQL_FLOAT'] , (param 66) = [type='IN', class='java.lang.Double', value='101423.0', sqltype='CF_SQL_FLOAT'] , (param 67) = [type='IN', class='java.lang.Double', value='59992.0', sqltype='CF_SQL_FLOAT'] , (param 68) = [type='IN', class='java.lang.Double', value='106733.0', sqltype='CF_SQL_FLOAT'] , (param 69) = [type='IN', class='java.lang.Double', value='103654.0', sqltype='CF_SQL_FLOAT'] , (param 70) = [type='IN', class='java.lang.Double', value='24136.0', sqltype='CF_SQL_FLOAT'] , (param 71) = [type='IN', class='java.lang.Double', value='9294.0', sqltype='CF_SQL_FLOAT'] , (param 72) = [type='IN', class='java.lang.Double', value='24153.0', sqltype='CF_SQL_FLOAT'] , (param 73) = [type='IN', class='java.lang.Double', value='51640.0', sqltype='CF_SQL_FLOAT'] , (param 74) = [type='IN', class='java.lang.Double', value='104194.0', sqltype='CF_SQL_FLOAT'] , (param 75) = [type='IN', class='java.lang.Double', value='107251.0', sqltype='CF_SQL_FLOAT'] , (param 76) = [type='IN', class='java.lang.Double', value='24130.0', sqltype='CF_SQL_FLOAT'] , (param 77) = [type='IN', class='java.lang.Double', value='108644.0', sqltype='CF_SQL_FLOAT'] , (param 78) = [type='IN', class='java.lang.Double', value='109277.0', sqltype='CF_SQL_FLOAT'] , (param 79) = [type='IN', class='java.lang.Double', value='24154.0', sqltype='CF_SQL_FLOAT'] , (param 80) = [type='IN', class='java.lang.Double', value='46133.0', sqltype='CF_SQL_FLOAT'] , (param 81) = [type='IN', class='java.lang.Double', value='105140.0', sqltype='CF_SQL_FLOAT'] , (param 82) = [type='IN', class='java.lang.Double', value='107612.0', sqltype='CF_SQL_FLOAT'] , (param 83) = [type='IN', class='java.lang.Double', value='105930.0', sqltype='CF_SQL_FLOAT'] , (param 84) = [type='IN', class='java.lang.Double', value='107486.0', sqltype='CF_SQL_FLOAT'] , (param 85) = [type='IN', class='java.lang.Double', value='63608.0', sqltype='CF_SQL_FLOAT'] , (param 86) = [type='IN', class='java.lang.Double', value='106328.0', sqltype='CF_SQL_FLOAT'] , (param 87) = [type='IN', class='java.lang.Double', value='106960.0', sqltype='CF_SQL_FLOAT'] , (param 88) = [type='IN', class='java.lang.Double', value='39407.0', sqltype='CF_SQL_FLOAT'] , (param 89) = [type='IN', class='java.lang.Double', value='60965.0', sqltype='CF_SQL_FLOAT'] , (param 90) = [type='IN', class='java.lang.Double', value='106959.0', sqltype='CF_SQL_FLOAT'] , (param 91) = [type='IN', class='java.lang.Double', value='39335.0', sqltype='CF_SQL_FLOAT'] , (param 92) = [type='IN', class='java.lang.Double', value='32330.0', sqltype='CF_SQL_FLOAT'] , (param 93) = [type='IN', class='java.lang.Double', value='101748.0', sqltype='CF_SQL_FLOAT'] , (param 94) = [type='IN', class='java.lang.Double', value='108641.0', sqltype='CF_SQL_FLOAT'] , (param 95) = [type='IN', class='java.lang.Double', value='49396.0', sqltype='CF_SQL_FLOAT'] , (param 96) = [type='IN', class='java.lang.Double', value='67686.0', sqltype='CF_SQL_FLOAT'] , (param 97) = [type='IN', class='java.lang.Double', value='62364.0', sqltype='CF_SQL_FLOAT'] , (param 98) = [type='IN', class='java.lang.Double', value='107445.0', sqltype='CF_SQL_FLOAT'] , (param 99) = [type='IN', class='java.lang.Double', value='36734.0', sqltype='CF_SQL_FLOAT'] , (param 100) = [type='IN', class='java.lang.Double', value='35745.0', sqltype='CF_SQL_FLOAT'] , (param 101) = [type='IN', class='java.lang.Double', value='44050.0', sqltype='CF_SQL_FLOAT'] , (param 102) = [type='IN', class='java.lang.Double', value='59063.0', sqltype='CF_SQL_FLOAT'] , (param 103) = [type='IN', class='java.lang.Double', value='63756.0', sqltype='CF_SQL_FLOAT'] , (param 104) = [type='IN', class='java.lang.Double', value='109437.0', sqltype='CF_SQL_FLOAT'] , (param 105) = [type='IN', class='java.lang.Double', value='109438.0', sqltype='CF_SQL_FLOAT'] , (param 106) = [type='IN', class='java.lang.Double', value='108711.0', sqltype='CF_SQL_FLOAT'] , (param 107) = [type='IN', class='java.lang.Double', value='45638.0', sqltype='CF_SQL_FLOAT'] , (param 108) = [type='IN', class='java.lang.Double', value='55722.0', sqltype='CF_SQL_FLOAT'] , (param 109) = [type='IN', class='java.lang.Double', value='109055.0', sqltype='CF_SQL_FLOAT'] , (param 110) = [type='IN', class='java.lang.Double', value='87726.0', sqltype='CF_SQL_FLOAT'] , (param 111) = [type='IN', class='java.lang.Double', value='66484.0', sqltype='CF_SQL_FLOAT'] , (param 112) = [type='IN', class='java.lang.Double', value='107066.0', sqltype='CF_SQL_FLOAT'] , (param 113) = [type='IN', class='java.lang.Double', value='59173.0', sqltype='CF_SQL_FLOAT'] , (param 114) = [type='IN', class='java.lang.Double', value='59174.0', sqltype='CF_SQL_FLOAT'] , (param 115) = [type='IN', class='java.lang.Double', value='30550.0', sqltype='CF_SQL_FLOAT'] , (param 116) = [type='IN', class='java.lang.Double', value='58395.0', sqltype='CF_SQL_FLOAT'] , (param 117) = [type='IN', class='java.lang.Double', value='109020.0', sqltype='CF_SQL_FLOAT'] , (param 118) = [type='IN', class='java.lang.Double', value='108929.0', sqltype='CF_SQL_FLOAT'] , (param 119) = [type='IN', class='java.lang.Double', value='57289.0', sqltype='CF_SQL_FLOAT'] , (param 120) = [type='IN', class='java.lang.Double', value='109021.0', sqltype='CF_SQL_FLOAT'] , (param 121) = [type='IN', class='java.lang.Double', value='11336.0', sqltype='CF_SQL_FLOAT'] , (param 122) = [type='IN', class='java.lang.Double', value='89225.0', sqltype='CF_SQL_FLOAT'] , (param 123) = [type='IN', class='java.lang.Double', value='106030.0', sqltype='CF_SQL_FLOAT'] , (param 124) = [type='IN', class='java.lang.Double', value='100540.0', sqltype='CF_SQL_FLOAT'] , (param 125) = [type='IN', class='java.lang.Double', value='108973.0', sqltype='CF_SQL_FLOAT'] , (param 126) = [type='IN', class='java.lang.Double', value='101027.0', sqltype='CF_SQL_FLOAT'] , (param 127) = [type='IN', class='java.lang.Double', value='108968.0', sqltype='CF_SQL_FLOAT'] , (param 128) = [type='IN', class='java.lang.Double', value='57240.0', sqltype='CF_SQL_FLOAT'] , (param 129) = [type='IN', class='java.lang.Double', value='109321.0', sqltype='CF_SQL_FLOAT'] , (param 130) = [type='IN', class='java.lang.Double', value='11337.0', sqltype='CF_SQL_FLOAT'] , (param 131) = [type='IN', class='java.lang.Double', value='32412.0', sqltype='CF_SQL_FLOAT'] , (param 132) = [type='IN', class='java.lang.Double', value='101994.0', sqltype='CF_SQL_FLOAT'] , (param 133) = [type='IN', class='java.lang.Double', value='103094.0', sqltype='CF_SQL_FLOAT'] , (param 134) = [type='IN', class='java.lang.Double', value='103772.0', sqltype='CF_SQL_FLOAT'] , (param 135) = [type='IN', class='java.lang.Double', value='20946.0', sqltype='CF_SQL_FLOAT'] , (param 136) = [type='IN', class='java.lang.Double', value='87733.0', sqltype='CF_SQL_FLOAT'] , (param 137) = [type='IN', class='java.lang.Double', value='49389.0', sqltype='CF_SQL_FLOAT'] , (param 138) = [type='IN', class='java.lang.Double', value='107054.0', sqltype='CF_SQL_FLOAT'] , (param 139) = [type='IN', class='java.lang.Double', value='82654.0', sqltype='CF_SQL_FLOAT'] , (param 140) = [type='IN', class='java.lang.Double', value='87734.0', sqltype='CF_SQL_FLOAT'] , (param 141) = [type='IN', class='java.lang.Double', value='27881.0', sqltype='CF_SQL_FLOAT'] , (param 142) = [type='IN', class='java.lang.Double', value='102010.0', sqltype='CF_SQL_FLOAT'] , (param 143) = [type='IN', class='java.lang.Double', value='102515.0', sqltype='CF_SQL_FLOAT'] , (param 144) = [type='IN', class='java.lang.Double', value='8962.0', sqltype='CF_SQL_FLOAT'] , (param 145) = [type='IN', class='java.lang.Double', value='27883.0', sqltype='CF_SQL_FLOAT'] , (param 146) = [type='IN', class='java.lang.Double', value='20896.0', sqltype='CF_SQL_FLOAT'] , (param 147) = [type='IN', class='java.lang.Double', value='54194.0', sqltype='CF_SQL_FLOAT'] , (param 148) = [type='IN', class='java.lang.Double', value='30760.0', sqltype='CF_SQL_FLOAT'] , (param 149) = [type='IN', class='java.lang.Double', value='67724.0', sqltype='CF_SQL_FLOAT'] , (param 150) = [type='IN', class='java.lang.Double', value='106025.0', sqltype='CF_SQL_FLOAT'] , (param 151) = [type='IN', class='java.lang.Double', value='107546.0', sqltype='CF_SQL_FLOAT'] , (param 152) = [type='IN', class='java.lang.Double', value='103803.0', sqltype='CF_SQL_FLOAT'] , (param 153) = [type='IN', class='java.lang.Double', value='8940.0', sqltype='CF_SQL_FLOAT'] , (param 154) = [type='IN', class='java.lang.Double', value='20969.0', sqltype='CF_SQL_FLOAT'] , (param 155) = [type='IN', class='java.lang.Double', value='51923.0', sqltype='CF_SQL_FLOAT'] , (param 156) = [type='IN', class='java.lang.Double', value='56455.0', sqltype='CF_SQL_FLOAT'] , (param 157) = [type='IN', class='java.lang.Double', value='106005.0', sqltype='CF_SQL_FLOAT'] , (param 158) = [type='IN', class='java.lang.Double', value='103683.0', sqltype='CF_SQL_FLOAT'] , (param 159) = [type='IN', class='java.lang.Double', value='107702.0', sqltype='CF_SQL_FLOAT'] , (param 160) = [type='IN', class='java.lang.Double', value='105346.0', sqltype='CF_SQL_FLOAT'] , (param 161) = [type='IN', class='java.lang.Double', value='9105.0', sqltype='CF_SQL_FLOAT'] , (param 162) = [type='IN', class='java.lang.Double', value='109379.0', sqltype='CF_SQL_FLOAT'] , (param 163) = [type='IN', class='java.lang.Double', value='101029.0', sqltype='CF_SQL_FLOAT'] , (param 164) = [type='IN', class='java.lang.Double', value='101441.0', sqltype='CF_SQL_FLOAT'] , (param 165) = [type='IN', class='java.lang.Double', value='101558.0', sqltype='CF_SQL_FLOAT'] , (param 166) = [type='IN', class='java.lang.Double', value='105946.0', sqltype='CF_SQL_FLOAT'] , (param 167) = [type='IN', class='java.lang.Double', value='103579.0', sqltype='CF_SQL_FLOAT'] , (param 168) = [type='IN', class='java.lang.Double', value='47954.0', sqltype='CF_SQL_FLOAT'] , (param 169) = [type='IN', class='java.lang.Double', value='47955.0', sqltype='CF_SQL_FLOAT'] , (param 170) = [type='IN', class='java.lang.Double', value='63714.0', sqltype='CF_SQL_FLOAT'] , (param 171) = [type='IN', class='java.lang.Double', value='9104.0', sqltype='CF_SQL_FLOAT'] , (param 172) = [type='IN', class='java.lang.Double', value='8972.0', sqltype='CF_SQL_FLOAT'] , (param 173) = [type='IN', class='java.lang.Double', value='49250.0', sqltype='CF_SQL_FLOAT'] , (param 174) = [type='IN', class='java.lang.Double', value='107576.0', sqltype='CF_SQL_FLOAT'] , (param 175) = [type='IN', class='java.lang.Double', value='53136.0', sqltype='CF_SQL_FLOAT'] , (param 176) = [type='IN', class='java.lang.Double', value='56599.0', sqltype='CF_SQL_FLOAT'] , (param 177) = [type='IN', class='java.lang.Double', value='101621.0', sqltype='CF_SQL_FLOAT'] , (param 178) = [type='IN', class='java.lang.Double', value='101885.0', sqltype='CF_SQL_FLOAT'] , (param 179) = [type='IN', class='java.lang.Double', value='103680.0', sqltype='CF_SQL_FLOAT'] , (param 180) = [type='IN', class='java.lang.Double', value='98863.0', sqltype='CF_SQL_FLOAT'] , (param 181) = [type='IN', class='java.lang.Double', value='8959.0', sqltype='CF_SQL_FLOAT'] , (param 182) = [type='IN', class='java.lang.Double', value='20942.0', sqltype='CF_SQL_FLOAT'] , (param 183) = [type='IN', class='java.lang.Double', value='101104.0', sqltype='CF_SQL_FLOAT'] , (param 184) = [type='IN', class='java.lang.Double', value='48423.0', sqltype='CF_SQL_FLOAT'] , (param 185) = [type='IN', class='java.lang.Double', value='56596.0', sqltype='CF_SQL_FLOAT'] , (param 186) = [type='IN', class='java.lang.Double', value='56598.0', sqltype='CF_SQL_FLOAT'] , (param 187) = [type='IN', class='java.lang.Double', value='56477.0', sqltype='CF_SQL_FLOAT'] , (param 188) = [type='IN', class='java.lang.Double', value='103011.0', sqltype='CF_SQL_FLOAT'] , (param 189) = [type='IN', class='java.lang.Double', value='106998.0', sqltype='CF_SQL_FLOAT'] , (param 190) = [type='IN', class='java.lang.Double', value='106029.0', sqltype='CF_SQL_FLOAT'] , (param 191) = [type='IN', class='java.lang.Double', value='83843.0', sqltype='CF_SQL_FLOAT'] , (param 192) = [type='IN', class='java.lang.Double', value='71871.0', sqltype='CF_SQL_FLOAT'] , (param 193) = [type='IN', class='java.lang.Double', value='61251.0', sqltype='CF_SQL_FLOAT'] , (param 194) = [type='IN', class='java.lang.Double', value='9116.0', sqltype='CF_SQL_FLOAT'] , (param 195) = [type='IN', class='java.lang.Double', value='38530.0', sqltype='CF_SQL_FLOAT'] , (param 196) = [type='IN', class='java.lang.Double', value='57991.0', sqltype='CF_SQL_FLOAT'] , (param 197) = [type='IN', class='java.lang.Double', value='59516.0', sqltype='CF_SQL_FLOAT'] , (param 198) = [type='IN', class='java.lang.Double', value='101622.0', sqltype='CF_SQL_FLOAT'] , (param 199) = [type='IN', class='java.lang.Double', value='59546.0', sqltype='CF_SQL_FLOAT'] , (param 200) = [type='IN', class='java.lang.Double', value='105092.0', sqltype='CF_SQL_FLOAT'] , (param 201) = [type='IN', class='java.lang.Double', value='49131.0', sqltype='CF_SQL_FLOAT'] , (param 202) = [type='IN', class='java.lang.Double', value='9114.0', sqltype='CF_SQL_FLOAT'] , (param 203) = [type='IN', class='java.lang.Double', value='104419.0', sqltype='CF_SQL_FLOAT'] , (param 204) = [type='IN', class='java.lang.Double', value='8964.0', sqltype='CF_SQL_FLOAT'] , (param 205) = [type='IN', class='java.lang.Double', value='101091.0', sqltype='CF_SQL_FLOAT'] , (param 206) = [type='IN', class='java.lang.Double', value='59362.0', sqltype='CF_SQL_FLOAT'] , (param 207) = [type='IN', class='java.lang.Double', value='101559.0', sqltype='CF_SQL_FLOAT'] , (param 208) = [type='IN', class='java.lang.Double', value='50884.0', sqltype='CF_SQL_FLOAT'] , (param 209) = [type='IN', class='java.lang.Double', value='56479.0', sqltype='CF_SQL_FLOAT'] , (param 210) = [type='IN', class='java.lang.Double', value='104053.0', sqltype='CF_SQL_FLOAT'] , (param 211) = [type='IN', class='java.lang.Double', value='9098.0', sqltype='CF_SQL_FLOAT'] , (param 212) = [type='IN', class='java.lang.Double', value='9112.0', sqltype='CF_SQL_FLOAT'] , (param 213) = [type='IN', class='java.lang.Double', value='100380.0', sqltype='CF_SQL_FLOAT'] , (param 214) = [type='IN', class='java.lang.Double', value='109324.0', sqltype='CF_SQL_FLOAT'] , (param 215) = [type='IN', class='java.lang.Double', value='80505.0', sqltype='CF_SQL_FLOAT'] , (param 216) = [type='IN', class='java.lang.Double', value='50880.0', sqltype='CF_SQL_FLOAT'] , (param 217) = [type='IN', class='java.lang.Double', value='105095.0', sqltype='CF_SQL_FLOAT'] , (param 218) = [type='IN', class='java.lang.Double', value='51604.0', sqltype='CF_SQL_FLOAT'] , (param 219) = [type='IN', class='java.lang.Double', value='44212.0', sqltype='CF_SQL_FLOAT'] , (param 220) = [type='IN', class='java.lang.Double', value='109323.0', sqltype='CF_SQL_FLOAT'] , (param 221) = [type='IN', class='java.lang.Double', value='73063.0', sqltype='CF_SQL_FLOAT'] , (param 222) = [type='IN', class='java.lang.Double', value='109322.0', sqltype='CF_SQL_FLOAT'] , (param 223) = [type='IN', class='java.lang.Double', value='9099.0', sqltype='CF_SQL_FLOAT'] , (param 224) = [type='IN', class='java.lang.Double', value='107442.0', sqltype='CF_SQL_FLOAT'] , (param 225) = [type='IN', class='java.lang.Double', value='100746.0', sqltype='CF_SQL_FLOAT'] , (param 226) = [type='IN', class='java.lang.Double', value='30668.0', sqltype='CF_SQL_FLOAT'] , (param 227) = [type='IN', class='java.lang.Double', value='37153.0', sqltype='CF_SQL_FLOAT'] , (param 228) = [type='IN', class='java.lang.Double', value='60857.0', sqltype='CF_SQL_FLOAT'] , (param 229) = [type='IN', class='java.lang.Double', value='101682.0', sqltype='CF_SQL_FLOAT'] , (param 230) = [type='IN', class='java.lang.Double', value='60979.0', sqltype='CF_SQL_FLOAT'] , (param 231) = [type='IN', class='java.lang.Double', value='101633.0', sqltype='CF_SQL_FLOAT'] , (param 232) = [type='IN', class='java.lang.Double', value='105176.0', sqltype='CF_SQL_FLOAT'] , (param 233) = [type='IN', class='java.lang.Double', value='87887.0', sqltype='CF_SQL_FLOAT'] , (param 234) = [type='IN', class='java.lang.Double', value='32214.0', sqltype='CF_SQL_FLOAT'] , (param 235) = [type='IN', class='java.lang.Double', value='104711.0', sqltype='CF_SQL_FLOAT'] , (param 236) = [type='IN', class='java.lang.Double', value='59250.0', sqltype='CF_SQL_FLOAT'] , (param 237) = [type='IN', class='java.lang.Double', value='87145.0', sqltype='CF_SQL_FLOAT'] , (param 238) = [type='IN', class='java.lang.Double', value='108043.0', sqltype='CF_SQL_FLOAT'] , (param 239) = [type='IN', class='java.lang.Double', value='104113.0', sqltype='CF_SQL_FLOAT'] , (param 240) = [type='IN', class='java.lang.Double', value='59244.0', sqltype='CF_SQL_FLOAT'] , (param 241) = [type='IN', class='java.lang.Double', value='59246.0', sqltype='CF_SQL_FLOAT'] , (param 242) = [type='IN', class='java.lang.Double', value='42952.0', sqltype='CF_SQL_FLOAT'] , (param 243) = [type='IN', class='java.lang.Double', value='107207.0', sqltype='CF_SQL_FLOAT'] , (param 244) = [type='IN', class='java.lang.String', value='Shooting', sqltype='CF_SQL_VARCHAR'] , (param 245) = [type='IN', class='java.lang.String', value='Firearms', sqltype='CF_SQL_VARCHAR'] , (param 246) = [type='IN', class='java.lang.String', value='Shotguns', sqltype='CF_SQL_VARCHAR'] , (param 247) = [type='IN', class='java.lang.String', value='Semi-Auto Shotguns', sqltype='CF_SQL_VARCHAR'] , (param 248) = [type='IN', class='java.lang.String', value='12ga', sqltype='CF_SQL_VARCHAR']
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
struct
Cause
struct
ErrorCode 1205
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState 40001
StackTrace java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59) at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6) at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1095
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1059
RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 526
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2703
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 525
RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CFQUERY
LINE 1305
RAW_TRACE at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305)
TEMPLATE E:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 59
RAW_TRACE at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_CATEGORY
LINE 6
RAW_TRACE at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
20
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
22
struct
COLUMN 0
ID CFINCLUDE
LINE 220
RAW_TRACE at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220)
TEMPLATE E:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
DataSource koalasql
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
ErrorCode 40001
Exceptions
array
1
struct
class java.sql.SQLTransactionRollbackException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Message Error Executing Database Query.
NativeErrorCode 1205
RootCause
struct
ErrorCode 1205
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState 40001
StackTrace java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59) at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6) at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1095
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1059
RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 526
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2703
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 525
RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CFQUERY
LINE 1305
RAW_TRACE at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305)
TEMPLATE E:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 59
RAW_TRACE at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_CATEGORY
LINE 6
RAW_TRACE at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
20
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
22
struct
COLUMN 0
ID CFINCLUDE
LINE 220
RAW_TRACE at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220)
TEMPLATE E:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
SQLState 40001
Sql SELECT DISTINCT webstyle , max(style_id) as style_id , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage FROM [dbo].[web_all_products_stratus] WHERE 1=1 --AND pictureid is not null --Search Results AND style_id IN ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) , (param 70) , (param 71) , (param 72) , (param 73) , (param 74) , (param 75) , (param 76) , (param 77) , (param 78) , (param 79) , (param 80) , (param 81) , (param 82) , (param 83) , (param 84) , (param 85) , (param 86) , (param 87) , (param 88) , (param 89) , (param 90) , (param 91) , (param 92) , (param 93) , (param 94) , (param 95) , (param 96) , (param 97) , (param 98) , (param 99) , (param 100) , (param 101) , (param 102) , (param 103) , (param 104) , (param 105) , (param 106) , (param 107) , (param 108) , (param 109) , (param 110) , (param 111) , (param 112) , (param 113) , (param 114) , (param 115) , (param 116) , (param 117) , (param 118) , (param 119) , (param 120) , (param 121) , (param 122) , (param 123) , (param 124) , (param 125) , (param 126) , (param 127) , (param 128) , (param 129) , (param 130) , (param 131) , (param 132) , (param 133) , (param 134) , (param 135) , (param 136) , (param 137) , (param 138) , (param 139) , (param 140) , (param 141) , (param 142) , (param 143) , (param 144) , (param 145) , (param 146) , (param 147) , (param 148) , (param 149) , (param 150) , (param 151) , (param 152) , (param 153) , (param 154) , (param 155) , (param 156) , (param 157) , (param 158) , (param 159) , (param 160) , (param 161) , (param 162) , (param 163) , (param 164) , (param 165) , (param 166) , (param 167) , (param 168) , (param 169) , (param 170) , (param 171) , (param 172) , (param 173) , (param 174) , (param 175) , (param 176) , (param 177) , (param 178) , (param 179) , (param 180) , (param 181) , (param 182) , (param 183) , (param 184) , (param 185) , (param 186) , (param 187) , (param 188) , (param 189) , (param 190) , (param 191) , (param 192) , (param 193) , (param 194) , (param 195) , (param 196) , (param 197) , (param 198) , (param 199) , (param 200) , (param 201) , (param 202) , (param 203) , (param 204) , (param 205) , (param 206) , (param 207) , (param 208) , (param 209) , (param 210) , (param 211) , (param 212) , (param 213) , (param 214) , (param 215) , (param 216) , (param 217) , (param 218) , (param 219) , (param 220) , (param 221) , (param 222) , (param 223) , (param 224) , (param 225) , (param 226) , (param 227) , (param 228) , (param 229) , (param 230) , (param 231) , (param 232) , (param 233) , (param 234) , (param 235) , (param 236) , (param 237) , (param 238) , (param 239) , (param 240) , (param 241) , (param 242) , (param 243) ) and ltrim(rtrim(dept)) = (param 244) and ltrim(rtrim(typ)) = (param 245) and ltrim(rtrim(subtyp1)) = (param 246) and ltrim(rtrim(subtyp2)) = (param 247) and ltrim(rtrim(subtyp3)) = 'EMPTY' AND upper(Sale) = 'Y' AND ( 1=2 OR REPLACE(REPLACE(upper(OF1), '.', ' '), '+', ' ') like (param 248) ) GROUP BY WEBSTYLE
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59) at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6) at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) ... 74 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 1305
RAW_TRACE at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305)
TEMPLATE E:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 59
RAW_TRACE at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_CATEGORY
LINE 6
RAW_TRACE at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 220
RAW_TRACE at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220)
TEMPLATE E:\websites\stratusecommerce\application.cfc
TYPE CFML
7
struct
COLUMN 0
ID ??
LINE 1095
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1059
RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
18
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 526
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
19
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
20
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
21
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2703
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
22
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 525
RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
where (param 1) = [type='IN', class='java.lang.Double', value='109211.0', sqltype='CF_SQL_FLOAT'] , (param 2) = [type='IN', class='java.lang.Double', value='109220.0', sqltype='CF_SQL_FLOAT'] , (param 3) = [type='IN', class='java.lang.Double', value='24135.0', sqltype='CF_SQL_FLOAT'] , (param 4) = [type='IN', class='java.lang.Double', value='109241.0', sqltype='CF_SQL_FLOAT'] , (param 5) = [type='IN', class='java.lang.Double', value='102355.0', sqltype='CF_SQL_FLOAT'] , (param 6) = [type='IN', class='java.lang.Double', value='59056.0', sqltype='CF_SQL_FLOAT'] , (param 7) = [type='IN', class='java.lang.Double', value='66436.0', sqltype='CF_SQL_FLOAT'] , (param 8) = [type='IN', class='java.lang.Double', value='63958.0', sqltype='CF_SQL_FLOAT'] , (param 9) = [type='IN', class='java.lang.Double', value='103809.0', sqltype='CF_SQL_FLOAT'] , (param 10) = [type='IN', class='java.lang.Double', value='103853.0', sqltype='CF_SQL_FLOAT'] , (param 11) = [type='IN', class='java.lang.Double', value='104900.0', sqltype='CF_SQL_FLOAT'] , (param 12) = [type='IN', class='java.lang.Double', value='109137.0', sqltype='CF_SQL_FLOAT'] , (param 13) = [type='IN', class='java.lang.Double', value='71891.0', sqltype='CF_SQL_FLOAT'] , (param 14) = [type='IN', class='java.lang.Double', value='44090.0', sqltype='CF_SQL_FLOAT'] , (param 15) = [type='IN', class='java.lang.Double', value='109064.0', sqltype='CF_SQL_FLOAT'] , (param 16) = [type='IN', class='java.lang.Double', value='102357.0', sqltype='CF_SQL_FLOAT'] , (param 17) = [type='IN', class='java.lang.Double', value='105660.0', sqltype='CF_SQL_FLOAT'] , (param 18) = [type='IN', class='java.lang.Double', value='104470.0', sqltype='CF_SQL_FLOAT'] , (param 19) = [type='IN', class='java.lang.Double', value='98833.0', sqltype='CF_SQL_FLOAT'] , (param 20) = [type='IN', class='java.lang.Double', value='109035.0', sqltype='CF_SQL_FLOAT'] , (param 21) = [type='IN', class='java.lang.Double', value='57837.0', sqltype='CF_SQL_FLOAT'] , (param 22) = [type='IN', class='java.lang.Double', value='67635.0', sqltype='CF_SQL_FLOAT'] , (param 23) = [type='IN', class='java.lang.Double', value='102487.0', sqltype='CF_SQL_FLOAT'] , (param 24) = [type='IN', class='java.lang.Double', value='104708.0', sqltype='CF_SQL_FLOAT'] , (param 25) = [type='IN', class='java.lang.Double', value='103719.0', sqltype='CF_SQL_FLOAT'] , (param 26) = [type='IN', class='java.lang.Double', value='103720.0', sqltype='CF_SQL_FLOAT'] , (param 27) = [type='IN', class='java.lang.Double', value='87669.0', sqltype='CF_SQL_FLOAT'] , (param 28) = [type='IN', class='java.lang.Double', value='102748.0', sqltype='CF_SQL_FLOAT'] , (param 29) = [type='IN', class='java.lang.Double', value='104713.0', sqltype='CF_SQL_FLOAT'] , (param 30) = [type='IN', class='java.lang.Double', value='104717.0', sqltype='CF_SQL_FLOAT'] , (param 31) = [type='IN', class='java.lang.Double', value='108477.0', sqltype='CF_SQL_FLOAT'] , (param 32) = [type='IN', class='java.lang.Double', value='24139.0', sqltype='CF_SQL_FLOAT'] , (param 33) = [type='IN', class='java.lang.Double', value='103949.0', sqltype='CF_SQL_FLOAT'] , (param 34) = [type='IN', class='java.lang.Double', value='97756.0', sqltype='CF_SQL_FLOAT'] , (param 35) = [type='IN', class='java.lang.Double', value='103581.0', sqltype='CF_SQL_FLOAT'] , (param 36) = [type='IN', class='java.lang.Double', value='102363.0', sqltype='CF_SQL_FLOAT'] , (param 37) = [type='IN', class='java.lang.Double', value='103422.0', sqltype='CF_SQL_FLOAT'] , (param 38) = [type='IN', class='java.lang.Double', value='107572.0', sqltype='CF_SQL_FLOAT'] , (param 39) = [type='IN', class='java.lang.Double', value='107574.0', sqltype='CF_SQL_FLOAT'] , (param 40) = [type='IN', class='java.lang.Double', value='108589.0', sqltype='CF_SQL_FLOAT'] , (param 41) = [type='IN', class='java.lang.Double', value='52786.0', sqltype='CF_SQL_FLOAT'] , (param 42) = [type='IN', class='java.lang.Double', value='109295.0', sqltype='CF_SQL_FLOAT'] , (param 43) = [type='IN', class='java.lang.Double', value='105318.0', sqltype='CF_SQL_FLOAT'] , (param 44) = [type='IN', class='java.lang.Double', value='106316.0', sqltype='CF_SQL_FLOAT'] , (param 45) = [type='IN', class='java.lang.Double', value='107029.0', sqltype='CF_SQL_FLOAT'] , (param 46) = [type='IN', class='java.lang.Double', value='46051.0', sqltype='CF_SQL_FLOAT'] , (param 47) = [type='IN', class='java.lang.Double', value='107487.0', sqltype='CF_SQL_FLOAT'] , (param 48) = [type='IN', class='java.lang.Double', value='107573.0', sqltype='CF_SQL_FLOAT'] , (param 49) = [type='IN', class='java.lang.Double', value='101546.0', sqltype='CF_SQL_FLOAT'] , (param 50) = [type='IN', class='java.lang.Double', value='105128.0', sqltype='CF_SQL_FLOAT'] , (param 51) = [type='IN', class='java.lang.Double', value='106958.0', sqltype='CF_SQL_FLOAT'] , (param 52) = [type='IN', class='java.lang.Double', value='109274.0', sqltype='CF_SQL_FLOAT'] , (param 53) = [type='IN', class='java.lang.Double', value='24132.0', sqltype='CF_SQL_FLOAT'] , (param 54) = [type='IN', class='java.lang.Double', value='32159.0', sqltype='CF_SQL_FLOAT'] , (param 55) = [type='IN', class='java.lang.Double', value='50518.0', sqltype='CF_SQL_FLOAT'] , (param 56) = [type='IN', class='java.lang.Double', value='65139.0', sqltype='CF_SQL_FLOAT'] , (param 57) = [type='IN', class='java.lang.Double', value='108756.0', sqltype='CF_SQL_FLOAT'] , (param 58) = [type='IN', class='java.lang.Double', value='107483.0', sqltype='CF_SQL_FLOAT'] , (param 59) = [type='IN', class='java.lang.Double', value='108642.0', sqltype='CF_SQL_FLOAT'] , (param 60) = [type='IN', class='java.lang.Double', value='59656.0', sqltype='CF_SQL_FLOAT'] , (param 61) = [type='IN', class='java.lang.Double', value='60237.0', sqltype='CF_SQL_FLOAT'] , (param 62) = [type='IN', class='java.lang.Double', value='104125.0', sqltype='CF_SQL_FLOAT'] , (param 63) = [type='IN', class='java.lang.Double', value='108928.0', sqltype='CF_SQL_FLOAT'] , (param 64) = [type='IN', class='java.lang.Double', value='103504.0', sqltype='CF_SQL_FLOAT'] , (param 65) = [type='IN', class='java.lang.Double', value='101153.0', sqltype='CF_SQL_FLOAT'] , (param 66) = [type='IN', class='java.lang.Double', value='101423.0', sqltype='CF_SQL_FLOAT'] , (param 67) = [type='IN', class='java.lang.Double', value='59992.0', sqltype='CF_SQL_FLOAT'] , (param 68) = [type='IN', class='java.lang.Double', value='106733.0', sqltype='CF_SQL_FLOAT'] , (param 69) = [type='IN', class='java.lang.Double', value='103654.0', sqltype='CF_SQL_FLOAT'] , (param 70) = [type='IN', class='java.lang.Double', value='24136.0', sqltype='CF_SQL_FLOAT'] , (param 71) = [type='IN', class='java.lang.Double', value='9294.0', sqltype='CF_SQL_FLOAT'] , (param 72) = [type='IN', class='java.lang.Double', value='24153.0', sqltype='CF_SQL_FLOAT'] , (param 73) = [type='IN', class='java.lang.Double', value='51640.0', sqltype='CF_SQL_FLOAT'] , (param 74) = [type='IN', class='java.lang.Double', value='104194.0', sqltype='CF_SQL_FLOAT'] , (param 75) = [type='IN', class='java.lang.Double', value='107251.0', sqltype='CF_SQL_FLOAT'] , (param 76) = [type='IN', class='java.lang.Double', value='24130.0', sqltype='CF_SQL_FLOAT'] , (param 77) = [type='IN', class='java.lang.Double', value='108644.0', sqltype='CF_SQL_FLOAT'] , (param 78) = [type='IN', class='java.lang.Double', value='109277.0', sqltype='CF_SQL_FLOAT'] , (param 79) = [type='IN', class='java.lang.Double', value='24154.0', sqltype='CF_SQL_FLOAT'] , (param 80) = [type='IN', class='java.lang.Double', value='46133.0', sqltype='CF_SQL_FLOAT'] , (param 81) = [type='IN', class='java.lang.Double', value='105140.0', sqltype='CF_SQL_FLOAT'] , (param 82) = [type='IN', class='java.lang.Double', value='107612.0', sqltype='CF_SQL_FLOAT'] , (param 83) = [type='IN', class='java.lang.Double', value='105930.0', sqltype='CF_SQL_FLOAT'] , (param 84) = [type='IN', class='java.lang.Double', value='107486.0', sqltype='CF_SQL_FLOAT'] , (param 85) = [type='IN', class='java.lang.Double', value='63608.0', sqltype='CF_SQL_FLOAT'] , (param 86) = [type='IN', class='java.lang.Double', value='106328.0', sqltype='CF_SQL_FLOAT'] , (param 87) = [type='IN', class='java.lang.Double', value='106960.0', sqltype='CF_SQL_FLOAT'] , (param 88) = [type='IN', class='java.lang.Double', value='39407.0', sqltype='CF_SQL_FLOAT'] , (param 89) = [type='IN', class='java.lang.Double', value='60965.0', sqltype='CF_SQL_FLOAT'] , (param 90) = [type='IN', class='java.lang.Double', value='106959.0', sqltype='CF_SQL_FLOAT'] , (param 91) = [type='IN', class='java.lang.Double', value='39335.0', sqltype='CF_SQL_FLOAT'] , (param 92) = [type='IN', class='java.lang.Double', value='32330.0', sqltype='CF_SQL_FLOAT'] , (param 93) = [type='IN', class='java.lang.Double', value='101748.0', sqltype='CF_SQL_FLOAT'] , (param 94) = [type='IN', class='java.lang.Double', value='108641.0', sqltype='CF_SQL_FLOAT'] , (param 95) = [type='IN', class='java.lang.Double', value='49396.0', sqltype='CF_SQL_FLOAT'] , (param 96) = [type='IN', class='java.lang.Double', value='67686.0', sqltype='CF_SQL_FLOAT'] , (param 97) = [type='IN', class='java.lang.Double', value='62364.0', sqltype='CF_SQL_FLOAT'] , (param 98) = [type='IN', class='java.lang.Double', value='107445.0', sqltype='CF_SQL_FLOAT'] , (param 99) = [type='IN', class='java.lang.Double', value='36734.0', sqltype='CF_SQL_FLOAT'] , (param 100) = [type='IN', class='java.lang.Double', value='35745.0', sqltype='CF_SQL_FLOAT'] , (param 101) = [type='IN', class='java.lang.Double', value='44050.0', sqltype='CF_SQL_FLOAT'] , (param 102) = [type='IN', class='java.lang.Double', value='59063.0', sqltype='CF_SQL_FLOAT'] , (param 103) = [type='IN', class='java.lang.Double', value='63756.0', sqltype='CF_SQL_FLOAT'] , (param 104) = [type='IN', class='java.lang.Double', value='109437.0', sqltype='CF_SQL_FLOAT'] , (param 105) = [type='IN', class='java.lang.Double', value='109438.0', sqltype='CF_SQL_FLOAT'] , (param 106) = [type='IN', class='java.lang.Double', value='108711.0', sqltype='CF_SQL_FLOAT'] , (param 107) = [type='IN', class='java.lang.Double', value='45638.0', sqltype='CF_SQL_FLOAT'] , (param 108) = [type='IN', class='java.lang.Double', value='55722.0', sqltype='CF_SQL_FLOAT'] , (param 109) = [type='IN', class='java.lang.Double', value='109055.0', sqltype='CF_SQL_FLOAT'] , (param 110) = [type='IN', class='java.lang.Double', value='87726.0', sqltype='CF_SQL_FLOAT'] , (param 111) = [type='IN', class='java.lang.Double', value='66484.0', sqltype='CF_SQL_FLOAT'] , (param 112) = [type='IN', class='java.lang.Double', value='107066.0', sqltype='CF_SQL_FLOAT'] , (param 113) = [type='IN', class='java.lang.Double', value='59173.0', sqltype='CF_SQL_FLOAT'] , (param 114) = [type='IN', class='java.lang.Double', value='59174.0', sqltype='CF_SQL_FLOAT'] , (param 115) = [type='IN', class='java.lang.Double', value='30550.0', sqltype='CF_SQL_FLOAT'] , (param 116) = [type='IN', class='java.lang.Double', value='58395.0', sqltype='CF_SQL_FLOAT'] , (param 117) = [type='IN', class='java.lang.Double', value='109020.0', sqltype='CF_SQL_FLOAT'] , (param 118) = [type='IN', class='java.lang.Double', value='108929.0', sqltype='CF_SQL_FLOAT'] , (param 119) = [type='IN', class='java.lang.Double', value='57289.0', sqltype='CF_SQL_FLOAT'] , (param 120) = [type='IN', class='java.lang.Double', value='109021.0', sqltype='CF_SQL_FLOAT'] , (param 121) = [type='IN', class='java.lang.Double', value='11336.0', sqltype='CF_SQL_FLOAT'] , (param 122) = [type='IN', class='java.lang.Double', value='89225.0', sqltype='CF_SQL_FLOAT'] , (param 123) = [type='IN', class='java.lang.Double', value='106030.0', sqltype='CF_SQL_FLOAT'] , (param 124) = [type='IN', class='java.lang.Double', value='100540.0', sqltype='CF_SQL_FLOAT'] , (param 125) = [type='IN', class='java.lang.Double', value='108973.0', sqltype='CF_SQL_FLOAT'] , (param 126) = [type='IN', class='java.lang.Double', value='101027.0', sqltype='CF_SQL_FLOAT'] , (param 127) = [type='IN', class='java.lang.Double', value='108968.0', sqltype='CF_SQL_FLOAT'] , (param 128) = [type='IN', class='java.lang.Double', value='57240.0', sqltype='CF_SQL_FLOAT'] , (param 129) = [type='IN', class='java.lang.Double', value='109321.0', sqltype='CF_SQL_FLOAT'] , (param 130) = [type='IN', class='java.lang.Double', value='11337.0', sqltype='CF_SQL_FLOAT'] , (param 131) = [type='IN', class='java.lang.Double', value='32412.0', sqltype='CF_SQL_FLOAT'] , (param 132) = [type='IN', class='java.lang.Double', value='101994.0', sqltype='CF_SQL_FLOAT'] , (param 133) = [type='IN', class='java.lang.Double', value='103094.0', sqltype='CF_SQL_FLOAT'] , (param 134) = [type='IN', class='java.lang.Double', value='103772.0', sqltype='CF_SQL_FLOAT'] , (param 135) = [type='IN', class='java.lang.Double', value='20946.0', sqltype='CF_SQL_FLOAT'] , (param 136) = [type='IN', class='java.lang.Double', value='87733.0', sqltype='CF_SQL_FLOAT'] , (param 137) = [type='IN', class='java.lang.Double', value='49389.0', sqltype='CF_SQL_FLOAT'] , (param 138) = [type='IN', class='java.lang.Double', value='107054.0', sqltype='CF_SQL_FLOAT'] , (param 139) = [type='IN', class='java.lang.Double', value='82654.0', sqltype='CF_SQL_FLOAT'] , (param 140) = [type='IN', class='java.lang.Double', value='87734.0', sqltype='CF_SQL_FLOAT'] , (param 141) = [type='IN', class='java.lang.Double', value='27881.0', sqltype='CF_SQL_FLOAT'] , (param 142) = [type='IN', class='java.lang.Double', value='102010.0', sqltype='CF_SQL_FLOAT'] , (param 143) = [type='IN', class='java.lang.Double', value='102515.0', sqltype='CF_SQL_FLOAT'] , (param 144) = [type='IN', class='java.lang.Double', value='8962.0', sqltype='CF_SQL_FLOAT'] , (param 145) = [type='IN', class='java.lang.Double', value='27883.0', sqltype='CF_SQL_FLOAT'] , (param 146) = [type='IN', class='java.lang.Double', value='20896.0', sqltype='CF_SQL_FLOAT'] , (param 147) = [type='IN', class='java.lang.Double', value='54194.0', sqltype='CF_SQL_FLOAT'] , (param 148) = [type='IN', class='java.lang.Double', value='30760.0', sqltype='CF_SQL_FLOAT'] , (param 149) = [type='IN', class='java.lang.Double', value='67724.0', sqltype='CF_SQL_FLOAT'] , (param 150) = [type='IN', class='java.lang.Double', value='106025.0', sqltype='CF_SQL_FLOAT'] , (param 151) = [type='IN', class='java.lang.Double', value='107546.0', sqltype='CF_SQL_FLOAT'] , (param 152) = [type='IN', class='java.lang.Double', value='103803.0', sqltype='CF_SQL_FLOAT'] , (param 153) = [type='IN', class='java.lang.Double', value='8940.0', sqltype='CF_SQL_FLOAT'] , (param 154) = [type='IN', class='java.lang.Double', value='20969.0', sqltype='CF_SQL_FLOAT'] , (param 155) = [type='IN', class='java.lang.Double', value='51923.0', sqltype='CF_SQL_FLOAT'] , (param 156) = [type='IN', class='java.lang.Double', value='56455.0', sqltype='CF_SQL_FLOAT'] , (param 157) = [type='IN', class='java.lang.Double', value='106005.0', sqltype='CF_SQL_FLOAT'] , (param 158) = [type='IN', class='java.lang.Double', value='103683.0', sqltype='CF_SQL_FLOAT'] , (param 159) = [type='IN', class='java.lang.Double', value='107702.0', sqltype='CF_SQL_FLOAT'] , (param 160) = [type='IN', class='java.lang.Double', value='105346.0', sqltype='CF_SQL_FLOAT'] , (param 161) = [type='IN', class='java.lang.Double', value='9105.0', sqltype='CF_SQL_FLOAT'] , (param 162) = [type='IN', class='java.lang.Double', value='109379.0', sqltype='CF_SQL_FLOAT'] , (param 163) = [type='IN', class='java.lang.Double', value='101029.0', sqltype='CF_SQL_FLOAT'] , (param 164) = [type='IN', class='java.lang.Double', value='101441.0', sqltype='CF_SQL_FLOAT'] , (param 165) = [type='IN', class='java.lang.Double', value='101558.0', sqltype='CF_SQL_FLOAT'] , (param 166) = [type='IN', class='java.lang.Double', value='105946.0', sqltype='CF_SQL_FLOAT'] , (param 167) = [type='IN', class='java.lang.Double', value='103579.0', sqltype='CF_SQL_FLOAT'] , (param 168) = [type='IN', class='java.lang.Double', value='47954.0', sqltype='CF_SQL_FLOAT'] , (param 169) = [type='IN', class='java.lang.Double', value='47955.0', sqltype='CF_SQL_FLOAT'] , (param 170) = [type='IN', class='java.lang.Double', value='63714.0', sqltype='CF_SQL_FLOAT'] , (param 171) = [type='IN', class='java.lang.Double', value='9104.0', sqltype='CF_SQL_FLOAT'] , (param 172) = [type='IN', class='java.lang.Double', value='8972.0', sqltype='CF_SQL_FLOAT'] , (param 173) = [type='IN', class='java.lang.Double', value='49250.0', sqltype='CF_SQL_FLOAT'] , (param 174) = [type='IN', class='java.lang.Double', value='107576.0', sqltype='CF_SQL_FLOAT'] , (param 175) = [type='IN', class='java.lang.Double', value='53136.0', sqltype='CF_SQL_FLOAT'] , (param 176) = [type='IN', class='java.lang.Double', value='56599.0', sqltype='CF_SQL_FLOAT'] , (param 177) = [type='IN', class='java.lang.Double', value='101621.0', sqltype='CF_SQL_FLOAT'] , (param 178) = [type='IN', class='java.lang.Double', value='101885.0', sqltype='CF_SQL_FLOAT'] , (param 179) = [type='IN', class='java.lang.Double', value='103680.0', sqltype='CF_SQL_FLOAT'] , (param 180) = [type='IN', class='java.lang.Double', value='98863.0', sqltype='CF_SQL_FLOAT'] , (param 181) = [type='IN', class='java.lang.Double', value='8959.0', sqltype='CF_SQL_FLOAT'] , (param 182) = [type='IN', class='java.lang.Double', value='20942.0', sqltype='CF_SQL_FLOAT'] , (param 183) = [type='IN', class='java.lang.Double', value='101104.0', sqltype='CF_SQL_FLOAT'] , (param 184) = [type='IN', class='java.lang.Double', value='48423.0', sqltype='CF_SQL_FLOAT'] , (param 185) = [type='IN', class='java.lang.Double', value='56596.0', sqltype='CF_SQL_FLOAT'] , (param 186) = [type='IN', class='java.lang.Double', value='56598.0', sqltype='CF_SQL_FLOAT'] , (param 187) = [type='IN', class='java.lang.Double', value='56477.0', sqltype='CF_SQL_FLOAT'] , (param 188) = [type='IN', class='java.lang.Double', value='103011.0', sqltype='CF_SQL_FLOAT'] , (param 189) = [type='IN', class='java.lang.Double', value='106998.0', sqltype='CF_SQL_FLOAT'] , (param 190) = [type='IN', class='java.lang.Double', value='106029.0', sqltype='CF_SQL_FLOAT'] , (param 191) = [type='IN', class='java.lang.Double', value='83843.0', sqltype='CF_SQL_FLOAT'] , (param 192) = [type='IN', class='java.lang.Double', value='71871.0', sqltype='CF_SQL_FLOAT'] , (param 193) = [type='IN', class='java.lang.Double', value='61251.0', sqltype='CF_SQL_FLOAT'] , (param 194) = [type='IN', class='java.lang.Double', value='9116.0', sqltype='CF_SQL_FLOAT'] , (param 195) = [type='IN', class='java.lang.Double', value='38530.0', sqltype='CF_SQL_FLOAT'] , (param 196) = [type='IN', class='java.lang.Double', value='57991.0', sqltype='CF_SQL_FLOAT'] , (param 197) = [type='IN', class='java.lang.Double', value='59516.0', sqltype='CF_SQL_FLOAT'] , (param 198) = [type='IN', class='java.lang.Double', value='101622.0', sqltype='CF_SQL_FLOAT'] , (param 199) = [type='IN', class='java.lang.Double', value='59546.0', sqltype='CF_SQL_FLOAT'] , (param 200) = [type='IN', class='java.lang.Double', value='105092.0', sqltype='CF_SQL_FLOAT'] , (param 201) = [type='IN', class='java.lang.Double', value='49131.0', sqltype='CF_SQL_FLOAT'] , (param 202) = [type='IN', class='java.lang.Double', value='9114.0', sqltype='CF_SQL_FLOAT'] , (param 203) = [type='IN', class='java.lang.Double', value='104419.0', sqltype='CF_SQL_FLOAT'] , (param 204) = [type='IN', class='java.lang.Double', value='8964.0', sqltype='CF_SQL_FLOAT'] , (param 205) = [type='IN', class='java.lang.Double', value='101091.0', sqltype='CF_SQL_FLOAT'] , (param 206) = [type='IN', class='java.lang.Double', value='59362.0', sqltype='CF_SQL_FLOAT'] , (param 207) = [type='IN', class='java.lang.Double', value='101559.0', sqltype='CF_SQL_FLOAT'] , (param 208) = [type='IN', class='java.lang.Double', value='50884.0', sqltype='CF_SQL_FLOAT'] , (param 209) = [type='IN', class='java.lang.Double', value='56479.0', sqltype='CF_SQL_FLOAT'] , (param 210) = [type='IN', class='java.lang.Double', value='104053.0', sqltype='CF_SQL_FLOAT'] , (param 211) = [type='IN', class='java.lang.Double', value='9098.0', sqltype='CF_SQL_FLOAT'] , (param 212) = [type='IN', class='java.lang.Double', value='9112.0', sqltype='CF_SQL_FLOAT'] , (param 213) = [type='IN', class='java.lang.Double', value='100380.0', sqltype='CF_SQL_FLOAT'] , (param 214) = [type='IN', class='java.lang.Double', value='109324.0', sqltype='CF_SQL_FLOAT'] , (param 215) = [type='IN', class='java.lang.Double', value='80505.0', sqltype='CF_SQL_FLOAT'] , (param 216) = [type='IN', class='java.lang.Double', value='50880.0', sqltype='CF_SQL_FLOAT'] , (param 217) = [type='IN', class='java.lang.Double', value='105095.0', sqltype='CF_SQL_FLOAT'] , (param 218) = [type='IN', class='java.lang.Double', value='51604.0', sqltype='CF_SQL_FLOAT'] , (param 219) = [type='IN', class='java.lang.Double', value='44212.0', sqltype='CF_SQL_FLOAT'] , (param 220) = [type='IN', class='java.lang.Double', value='109323.0', sqltype='CF_SQL_FLOAT'] , (param 221) = [type='IN', class='java.lang.Double', value='73063.0', sqltype='CF_SQL_FLOAT'] , (param 222) = [type='IN', class='java.lang.Double', value='109322.0', sqltype='CF_SQL_FLOAT'] , (param 223) = [type='IN', class='java.lang.Double', value='9099.0', sqltype='CF_SQL_FLOAT'] , (param 224) = [type='IN', class='java.lang.Double', value='107442.0', sqltype='CF_SQL_FLOAT'] , (param 225) = [type='IN', class='java.lang.Double', value='100746.0', sqltype='CF_SQL_FLOAT'] , (param 226) = [type='IN', class='java.lang.Double', value='30668.0', sqltype='CF_SQL_FLOAT'] , (param 227) = [type='IN', class='java.lang.Double', value='37153.0', sqltype='CF_SQL_FLOAT'] , (param 228) = [type='IN', class='java.lang.Double', value='60857.0', sqltype='CF_SQL_FLOAT'] , (param 229) = [type='IN', class='java.lang.Double', value='101682.0', sqltype='CF_SQL_FLOAT'] , (param 230) = [type='IN', class='java.lang.Double', value='60979.0', sqltype='CF_SQL_FLOAT'] , (param 231) = [type='IN', class='java.lang.Double', value='101633.0', sqltype='CF_SQL_FLOAT'] , (param 232) = [type='IN', class='java.lang.Double', value='105176.0', sqltype='CF_SQL_FLOAT'] , (param 233) = [type='IN', class='java.lang.Double', value='87887.0', sqltype='CF_SQL_FLOAT'] , (param 234) = [type='IN', class='java.lang.Double', value='32214.0', sqltype='CF_SQL_FLOAT'] , (param 235) = [type='IN', class='java.lang.Double', value='104711.0', sqltype='CF_SQL_FLOAT'] , (param 236) = [type='IN', class='java.lang.Double', value='59250.0', sqltype='CF_SQL_FLOAT'] , (param 237) = [type='IN', class='java.lang.Double', value='87145.0', sqltype='CF_SQL_FLOAT'] , (param 238) = [type='IN', class='java.lang.Double', value='108043.0', sqltype='CF_SQL_FLOAT'] , (param 239) = [type='IN', class='java.lang.Double', value='104113.0', sqltype='CF_SQL_FLOAT'] , (param 240) = [type='IN', class='java.lang.Double', value='59244.0', sqltype='CF_SQL_FLOAT'] , (param 241) = [type='IN', class='java.lang.Double', value='59246.0', sqltype='CF_SQL_FLOAT'] , (param 242) = [type='IN', class='java.lang.Double', value='42952.0', sqltype='CF_SQL_FLOAT'] , (param 243) = [type='IN', class='java.lang.Double', value='107207.0', sqltype='CF_SQL_FLOAT'] , (param 244) = [type='IN', class='java.lang.String', value='Shooting', sqltype='CF_SQL_VARCHAR'] , (param 245) = [type='IN', class='java.lang.String', value='Firearms', sqltype='CF_SQL_VARCHAR'] , (param 246) = [type='IN', class='java.lang.String', value='Shotguns', sqltype='CF_SQL_VARCHAR'] , (param 247) = [type='IN', class='java.lang.String', value='Semi-Auto Shotguns', sqltype='CF_SQL_VARCHAR'] , (param 248) = [type='IN', class='java.lang.String', value='12ga', sqltype='CF_SQL_VARCHAR']
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59) at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6) at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1) at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 40 more Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 166) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) ... 74 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 1305
RAW_TRACE at cfcategory2ecfc1955080380$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(E:\websites\stratusecommerce\functions\category.cfc:1305)
TEMPLATE E:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 59
RAW_TRACE at cfcategory2ecfm2123179797._factor6(E:\websites\stratusecommerce\category.cfm:59)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_CATEGORY
LINE 6
RAW_TRACE at cfcategory2ecfm2123179797._factor12(E:\websites\stratusecommerce\category.cfm:6)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797._factor13(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm2123179797.runPage(E:\websites\stratusecommerce\category.cfm:1)
TEMPLATE E:\websites\stratusecommerce\category.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 220
RAW_TRACE at cfapplication2ecfc1458786127$funcONREQUEST.runFunction(E:\websites\stratusecommerce\application.cfc:220)
TEMPLATE E:\websites\stratusecommerce\application.cfc
TYPE CFML
7
struct
COLUMN 0
ID ??
LINE 1095
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1059
RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
18
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 526
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
19
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
20
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
21
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2703
RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
22
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 525
RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
Type Database
name onRequest