-
TOYS & GAMES
struct EVENTNAME onRequest EXCEPTION struct Cause struct Cause struct ErrorCode 1205 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 121) 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 121) 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.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) 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 cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) 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 cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) 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 cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) 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.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 1094 RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) TEMPLATE C:\websites\stratusecommerce\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 389 RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) TEMPLATE C:\websites\stratusecommerce\includes\header.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 2 RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) TEMPLATE C:\websites\stratusecommerce\category.cfm TYPE CFML 20 struct COLUMN 0 ID CFINCLUDE LINE 224 RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) TEMPLATE C:\websites\stratusecommerce\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException DataSource koalasql Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 121) 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 121) 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 121) 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 121) 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.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) 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 cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) 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 cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) 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 cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) 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.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 1094 RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) TEMPLATE C:\websites\stratusecommerce\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 389 RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) TEMPLATE C:\websites\stratusecommerce\includes\header.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 2 RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) TEMPLATE C:\websites\stratusecommerce\category.cfm TYPE CFML 20 struct COLUMN 0 ID CFINCLUDE LINE 224 RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) TEMPLATE C:\websites\stratusecommerce\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException SQLState 40001 Sql SELECT DISTINCT style_id , max(webstyle) as webstyle , 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, max(pictureid) as pictureid FROM web_all_products WHERE 1=1 --AND pictureid is not null and dept = (param 1) and len(realName)>0 GROUP BY STYLE_ID ORDER BY max(sortposition) 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$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) 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 cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) 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 cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) 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 cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) 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.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 121) 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.startQueryExecution(QueryTag.java:876) ... 72 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 1094 RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) TEMPLATE C:\websites\stratusecommerce\functions\category.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 389 RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) TEMPLATE C:\websites\stratusecommerce\includes\header.cfm TYPE CFML 3 struct COLUMN 0 ID CFINCLUDE LINE 2 RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) TEMPLATE C:\websites\stratusecommerce\category.cfm TYPE CFML 4 struct COLUMN 0 ID CFINCLUDE LINE 224 RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) TEMPLATE C:\websites\stratusecommerce\application.cfc TYPE CFML 5 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 6 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 7 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 8 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 9 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 10 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 11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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 20 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 121) 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='TOYS & GAMES', sqltype='CF_SQL_LONGVARCHAR'] 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 121) 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 121) 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.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) 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 cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) 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 cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) 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 cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) 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.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 1094 RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) TEMPLATE C:\websites\stratusecommerce\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 389 RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) TEMPLATE C:\websites\stratusecommerce\includes\header.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 2 RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) TEMPLATE C:\websites\stratusecommerce\category.cfm TYPE CFML 20 struct COLUMN 0 ID CFINCLUDE LINE 224 RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) TEMPLATE C:\websites\stratusecommerce\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException DataSource koalasql Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 121) 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 121) 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 121) 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 121) 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.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) 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 cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) 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 cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) 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 cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) 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.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 1094 RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) TEMPLATE C:\websites\stratusecommerce\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 389 RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) TEMPLATE C:\websites\stratusecommerce\includes\header.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 2 RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) TEMPLATE C:\websites\stratusecommerce\category.cfm TYPE CFML 20 struct COLUMN 0 ID CFINCLUDE LINE 224 RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) TEMPLATE C:\websites\stratusecommerce\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException SQLState 40001 Sql SELECT DISTINCT style_id , max(webstyle) as webstyle , 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, max(pictureid) as pictureid FROM web_all_products WHERE 1=1 --AND pictureid is not null and dept = (param 1) and len(realName)>0 GROUP BY STYLE_ID ORDER BY max(sortposition) 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$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) 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 cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) 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 cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) 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 cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) 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.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 121) 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.startQueryExecution(QueryTag.java:876) ... 72 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 1094 RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) TEMPLATE C:\websites\stratusecommerce\functions\category.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 389 RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) TEMPLATE C:\websites\stratusecommerce\includes\header.cfm TYPE CFML 3 struct COLUMN 0 ID CFINCLUDE LINE 2 RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) TEMPLATE C:\websites\stratusecommerce\category.cfm TYPE CFML 4 struct COLUMN 0 ID CFINCLUDE LINE 224 RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) TEMPLATE C:\websites\stratusecommerce\application.cfc TYPE CFML 5 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 6 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 7 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 8 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 9 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 10 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 11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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 20 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 121) 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='TOYS & GAMES', sqltype='CF_SQL_LONGVARCHAR'] 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$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) 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 cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) 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 cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) 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 cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) 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) ... 36 more Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 121) 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.startQueryExecution(QueryTag.java:876) ... 72 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 1094 RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) TEMPLATE C:\websites\stratusecommerce\functions\category.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 389 RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) TEMPLATE C:\websites\stratusecommerce\includes\header.cfm TYPE CFML 3 struct COLUMN 0 ID CFINCLUDE LINE 2 RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) TEMPLATE C:\websites\stratusecommerce\category.cfm TYPE CFML 4 struct COLUMN 0 ID CFINCLUDE LINE 224 RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) TEMPLATE C:\websites\stratusecommerce\application.cfc TYPE CFML 5 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 6 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 7 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 8 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 9 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 10 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 11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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 20 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