struct
EVENTNAME onRequest
EXCEPTION
struct
Cause
struct
Cause
struct
ErrorCode 1205
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 169) 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 169) 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:1640) at coldfusion.sql.Executive.executeQuery(Executive.java:1366) at coldfusion.sql.Executive.executeQuery(Executive.java:1296) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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:4327) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4290) at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294) 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:5274) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202) 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:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:592) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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.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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) 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 1371
RAW_TRACE at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371)
TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 295
RAW_TRACE at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_SIDENAV
LINE 294
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
20
struct
COLUMN 0
ID CFINCLUDE
LINE 202
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CFINCLUDE
LINE 236
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
DataSource koalasql
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 169) 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 169) 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 169) 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 169) 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:1640) at coldfusion.sql.Executive.executeQuery(Executive.java:1366) at coldfusion.sql.Executive.executeQuery(Executive.java:1296) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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:4327) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4290) at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294) 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:5274) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202) 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:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:592) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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.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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) 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 1371
RAW_TRACE at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371)
TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 295
RAW_TRACE at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_SIDENAV
LINE 294
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
20
struct
COLUMN 0
ID CFINCLUDE
LINE 202
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CFINCLUDE
LINE 236
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
SQLState 40001
Sql SELECT pricerange as filter_item, count(DISTINCT style_id) as itemCount,max(picture_id) as picture_id ,max(description) as description FROM [dbo].[web_all_products_stratus] WHERE 1=1 AND pictureid is not null and ltrim(rtrim(dept)) = (param 1) and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like (param 2) OR upper(brand) like (param 3) OR upper(brand) like (param 4) OR upper(brand) like (param 5) OR upper(brand) like (param 6) OR upper(brand) like (param 7) OR upper(brand) like (param 8) OR upper(brand) like (param 9) ) GROUP BY pricerange ORDER BY pricerange
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 cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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:4327) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4290) at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294) 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:5274) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202) 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:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:592) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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.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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 169) 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:1640) at coldfusion.sql.Executive.executeQuery(Executive.java:1366) at coldfusion.sql.Executive.executeQuery(Executive.java:1296) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 73 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 1371
RAW_TRACE at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371)
TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 295
RAW_TRACE at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SIDENAV
LINE 294
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 202
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 236
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
6
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
7
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
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
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
18
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
19
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
20
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
21
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 169) 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.String', value='WOMENS', sqltype='CF_SQL_VARCHAR'] , (param 2) = [type='IN', class='java.lang.String', value='%quicksilver%', sqltype='CF_SQL_VARCHAR'] , (param 3) = [type='IN', class='java.lang.String', value='%nitro%', sqltype='CF_SQL_VARCHAR'] , (param 4) = [type='IN', class='java.lang.String', value='%skea%', sqltype='CF_SQL_VARCHAR'] , (param 5) = [type='IN', class='java.lang.String', value='%save the duck%', sqltype='CF_SQL_VARCHAR'] , (param 6) = [type='IN', class='java.lang.String', value='%hydro flask%', sqltype='CF_SQL_VARCHAR'] , (param 7) = [type='IN', class='java.lang.String', value='%maui jim%', sqltype='CF_SQL_VARCHAR'] , (param 8) = [type='IN', class='java.lang.String', value='%descente%', sqltype='CF_SQL_VARCHAR'] , (param 9) = [type='IN', class='java.lang.String', value='%inphorm%', 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 169) 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 169) 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:1640) at coldfusion.sql.Executive.executeQuery(Executive.java:1366) at coldfusion.sql.Executive.executeQuery(Executive.java:1296) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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:4327) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4290) at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294) 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:5274) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202) 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:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:592) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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.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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) 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 1371
RAW_TRACE at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371)
TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 295
RAW_TRACE at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_SIDENAV
LINE 294
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
20
struct
COLUMN 0
ID CFINCLUDE
LINE 202
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CFINCLUDE
LINE 236
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
DataSource koalasql
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 169) 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 169) 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 169) 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 169) 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:1640) at coldfusion.sql.Executive.executeQuery(Executive.java:1366) at coldfusion.sql.Executive.executeQuery(Executive.java:1296) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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:4327) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4290) at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294) 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:5274) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202) 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:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:592) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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.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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) 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 1371
RAW_TRACE at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371)
TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
18
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 295
RAW_TRACE at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
19
struct
COLUMN 0
ID CF_SIDENAV
LINE 294
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
20
struct
COLUMN 0
ID CFINCLUDE
LINE 202
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
21
struct
COLUMN 0
ID CFINCLUDE
LINE 236
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
Type java.sql.SQLTransactionRollbackException
SQLState 40001
Sql SELECT pricerange as filter_item, count(DISTINCT style_id) as itemCount,max(picture_id) as picture_id ,max(description) as description FROM [dbo].[web_all_products_stratus] WHERE 1=1 AND pictureid is not null and ltrim(rtrim(dept)) = (param 1) and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like (param 2) OR upper(brand) like (param 3) OR upper(brand) like (param 4) OR upper(brand) like (param 5) OR upper(brand) like (param 6) OR upper(brand) like (param 7) OR upper(brand) like (param 8) OR upper(brand) like (param 9) ) GROUP BY pricerange ORDER BY pricerange
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 cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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:4327) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4290) at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294) 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:5274) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202) 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:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:592) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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.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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 169) 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:1640) at coldfusion.sql.Executive.executeQuery(Executive.java:1366) at coldfusion.sql.Executive.executeQuery(Executive.java:1296) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 73 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 1371
RAW_TRACE at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371)
TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 295
RAW_TRACE at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SIDENAV
LINE 294
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 202
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 236
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
6
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
7
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
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
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
18
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
19
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
20
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
21
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 169) 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.String', value='WOMENS', sqltype='CF_SQL_VARCHAR'] , (param 2) = [type='IN', class='java.lang.String', value='%quicksilver%', sqltype='CF_SQL_VARCHAR'] , (param 3) = [type='IN', class='java.lang.String', value='%nitro%', sqltype='CF_SQL_VARCHAR'] , (param 4) = [type='IN', class='java.lang.String', value='%skea%', sqltype='CF_SQL_VARCHAR'] , (param 5) = [type='IN', class='java.lang.String', value='%save the duck%', sqltype='CF_SQL_VARCHAR'] , (param 6) = [type='IN', class='java.lang.String', value='%hydro flask%', sqltype='CF_SQL_VARCHAR'] , (param 7) = [type='IN', class='java.lang.String', value='%maui jim%', sqltype='CF_SQL_VARCHAR'] , (param 8) = [type='IN', class='java.lang.String', value='%descente%', sqltype='CF_SQL_VARCHAR'] , (param 9) = [type='IN', class='java.lang.String', value='%inphorm%', 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.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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:482) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) 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 cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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:4327) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4290) at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294) 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:5274) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202) 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:5274) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:662) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:592) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:555) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:471) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:445) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:317) 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) ... 36 more Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 169) 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:1640) at coldfusion.sql.Executive.executeQuery(Executive.java:1366) at coldfusion.sql.Executive.executeQuery(Executive.java:1296) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 73 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 1371
RAW_TRACE at cfcategory2ecfc73142977$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1371)
TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 295
RAW_TRACE at cfsidenav2ecfm48817863._factor18(C:\websites\stratusecommerce\includes\sidenav.cfm:295)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SIDENAV
LINE 294
RAW_TRACE at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:294)
TEMPLATE C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 202
RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:202)
TEMPLATE C:\websites\stratusecommerce\category.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 236
RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:236)
TEMPLATE C:\websites\stratusecommerce\application.cfc
TYPE CFML
6
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
7
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
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
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
18
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
19
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
20
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
21
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