struct
EVENTNAME	onRequest
EXCEPTION	struct Cause struct Cause struct ErrorCode 1205 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 184) 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 184) 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 cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) 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 cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) 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 cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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 1597 RAW_TRACE at cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) TEMPLATE C:\websites\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 71 RAW_TRACE at cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) TEMPLATE C:\websites\defaultwebsite\category.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 226 RAW_TRACE at cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) TEMPLATE C:\websites\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException DataSource celerantSQL Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 184) 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 184) 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 184) 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 184) 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 cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) 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 cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) 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 cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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 1597 RAW_TRACE at cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) TEMPLATE C:\websites\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 71 RAW_TRACE at cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) TEMPLATE C:\websites\defaultwebsite\category.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 226 RAW_TRACE at cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) TEMPLATE C:\websites\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException SQLState 40001 Sql SELECT distinct style_id , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , min(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(hexLIST) as hexLIST , max(famList) as famList , max(sizelist) as sizelist , max(name) as name , max(of8) as of8Value ,(select max(bx.web_text) from TB_INET_NAMES as bx where bx.field_name='OF8' and bx.ORIG_TEXT=max(OF8)) as of8 , max(gender) as gender , max(agerange) as agerange , max(picture_id) as picture_id , 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 FROM [dbo].[web_all_products] WHERE pictureid is not null --Search Results AND style_id IN ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) , (param 70) , (param 71) , (param 72) , (param 73) , (param 74) , (param 75) , (param 76) , (param 77) , (param 78) , (param 79) , (param 80) , (param 81) , (param 82) , (param 83) , (param 84) , (param 85) , (param 86) , (param 87) , (param 88) , (param 89) , (param 90) , (param 91) , (param 92) , (param 93) , (param 94) , (param 95) , (param 96) , (param 97) , (param 98) , (param 99) , (param 100) , (param 101) , (param 102) , (param 103) , (param 104) , (param 105) , (param 106) , (param 107) , (param 108) , (param 109) , (param 110) ) and rtrim(ltrim(gender))= 'unisex' and rtrim(ltrim(agerange))= 'kids' and upper(gender)='UNISEX' and upper(agerange)='KIDS' GROUP BY STYLE_ID ORDER BY picture_id desc 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 cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) 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 cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) 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 cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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 184) 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) ... 68 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 1597 RAW_TRACE at cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) TEMPLATE C:\websites\functions\category.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 71 RAW_TRACE at cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) TEMPLATE C:\websites\defaultwebsite\category.cfm TYPE CFML 3 struct COLUMN 0 ID CFINCLUDE LINE 226 RAW_TRACE at cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) TEMPLATE C:\websites\application.cfc TYPE CFML 4 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 5 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 6 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 7 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 8 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 9 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 10 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 11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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 184) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. where (param 1) = [type='IN', class='java.lang.Double', value='178342.0', sqltype='CF_SQL_FLOAT'] , (param 2) = [type='IN', class='java.lang.Double', value='185603.0', sqltype='CF_SQL_FLOAT'] , (param 3) = [type='IN', class='java.lang.Double', value='89192.0', sqltype='CF_SQL_FLOAT'] , (param 4) = [type='IN', class='java.lang.Double', value='193182.0', sqltype='CF_SQL_FLOAT'] , (param 5) = [type='IN', class='java.lang.Double', value='193183.0', sqltype='CF_SQL_FLOAT'] , (param 6) = [type='IN', class='java.lang.Double', value='5416.0', sqltype='CF_SQL_FLOAT'] , (param 7) = [type='IN', class='java.lang.Double', value='131937.0', sqltype='CF_SQL_FLOAT'] , (param 8) = [type='IN', class='java.lang.Double', value='193185.0', sqltype='CF_SQL_FLOAT'] , (param 9) = [type='IN', class='java.lang.Double', value='4785.0', sqltype='CF_SQL_FLOAT'] , (param 10) = [type='IN', class='java.lang.Double', value='3757.0', sqltype='CF_SQL_FLOAT'] , (param 11) = [type='IN', class='java.lang.Double', value='158377.0', sqltype='CF_SQL_FLOAT'] , (param 12) = [type='IN', class='java.lang.Double', value='5417.0', sqltype='CF_SQL_FLOAT'] , (param 13) = [type='IN', class='java.lang.Double', value='3756.0', sqltype='CF_SQL_FLOAT'] , (param 14) = [type='IN', class='java.lang.Double', value='188403.0', sqltype='CF_SQL_FLOAT'] , (param 15) = [type='IN', class='java.lang.Double', value='3753.0', sqltype='CF_SQL_FLOAT'] , (param 16) = [type='IN', class='java.lang.Double', value='185832.0', sqltype='CF_SQL_FLOAT'] , (param 17) = [type='IN', class='java.lang.Double', value='4942.0', sqltype='CF_SQL_FLOAT'] , (param 18) = [type='IN', class='java.lang.Double', value='119677.0', sqltype='CF_SQL_FLOAT'] , (param 19) = [type='IN', class='java.lang.Double', value='187441.0', sqltype='CF_SQL_FLOAT'] , (param 20) = [type='IN', class='java.lang.Double', value='3863.0', sqltype='CF_SQL_FLOAT'] , (param 21) = [type='IN', class='java.lang.Double', value='154505.0', sqltype='CF_SQL_FLOAT'] , (param 22) = [type='IN', class='java.lang.Double', value='191855.0', sqltype='CF_SQL_FLOAT'] , (param 23) = [type='IN', class='java.lang.Double', value='89205.0', sqltype='CF_SQL_FLOAT'] , (param 24) = [type='IN', class='java.lang.Double', value='3862.0', sqltype='CF_SQL_FLOAT'] , (param 25) = [type='IN', class='java.lang.Double', value='115948.0', sqltype='CF_SQL_FLOAT'] , (param 26) = [type='IN', class='java.lang.Double', value='173236.0', sqltype='CF_SQL_FLOAT'] , (param 27) = [type='IN', class='java.lang.Double', value='181664.0', sqltype='CF_SQL_FLOAT'] , (param 28) = [type='IN', class='java.lang.Double', value='182528.0', sqltype='CF_SQL_FLOAT'] , (param 29) = [type='IN', class='java.lang.Double', value='185243.0', sqltype='CF_SQL_FLOAT'] , (param 30) = [type='IN', class='java.lang.Double', value='190838.0', sqltype='CF_SQL_FLOAT'] , (param 31) = [type='IN', class='java.lang.Double', value='199858.0', sqltype='CF_SQL_FLOAT'] , (param 32) = [type='IN', class='java.lang.Double', value='199857.0', sqltype='CF_SQL_FLOAT'] , (param 33) = [type='IN', class='java.lang.Double', value='4412.0', sqltype='CF_SQL_FLOAT'] , (param 34) = [type='IN', class='java.lang.Double', value='89200.0', sqltype='CF_SQL_FLOAT'] , (param 35) = [type='IN', class='java.lang.Double', value='3998.0', sqltype='CF_SQL_FLOAT'] , (param 36) = [type='IN', class='java.lang.Double', value='130885.0', sqltype='CF_SQL_FLOAT'] , (param 37) = [type='IN', class='java.lang.Double', value='4886.0', sqltype='CF_SQL_FLOAT'] , (param 38) = [type='IN', class='java.lang.Double', value='173239.0', sqltype='CF_SQL_FLOAT'] , (param 39) = [type='IN', class='java.lang.Double', value='188735.0', sqltype='CF_SQL_FLOAT'] , (param 40) = [type='IN', class='java.lang.Double', value='193180.0', sqltype='CF_SQL_FLOAT'] , (param 41) = [type='IN', class='java.lang.Double', value='198062.0', sqltype='CF_SQL_FLOAT'] , (param 42) = [type='IN', class='java.lang.Double', value='89297.0', sqltype='CF_SQL_FLOAT'] , (param 43) = [type='IN', class='java.lang.Double', value='4413.0', sqltype='CF_SQL_FLOAT'] , (param 44) = [type='IN', class='java.lang.Double', value='4935.0', sqltype='CF_SQL_FLOAT'] , (param 45) = [type='IN', class='java.lang.Double', value='89190.0', sqltype='CF_SQL_FLOAT'] , (param 46) = [type='IN', class='java.lang.Double', value='130891.0', sqltype='CF_SQL_FLOAT'] , (param 47) = [type='IN', class='java.lang.Double', value='130882.0', sqltype='CF_SQL_FLOAT'] , (param 48) = [type='IN', class='java.lang.Double', value='130883.0', sqltype='CF_SQL_FLOAT'] , (param 49) = [type='IN', class='java.lang.Double', value='161854.0', sqltype='CF_SQL_FLOAT'] , (param 50) = [type='IN', class='java.lang.Double', value='170515.0', sqltype='CF_SQL_FLOAT'] , (param 51) = [type='IN', class='java.lang.Double', value='176771.0', sqltype='CF_SQL_FLOAT'] , (param 52) = [type='IN', class='java.lang.Double', value='181661.0', sqltype='CF_SQL_FLOAT'] , (param 53) = [type='IN', class='java.lang.Double', value='181662.0', sqltype='CF_SQL_FLOAT'] , (param 54) = [type='IN', class='java.lang.Double', value='181665.0', sqltype='CF_SQL_FLOAT'] , (param 55) = [type='IN', class='java.lang.Double', value='181666.0', sqltype='CF_SQL_FLOAT'] , (param 56) = [type='IN', class='java.lang.Double', value='181667.0', sqltype='CF_SQL_FLOAT'] , (param 57) = [type='IN', class='java.lang.Double', value='181668.0', sqltype='CF_SQL_FLOAT'] , (param 58) = [type='IN', class='java.lang.Double', value='191040.0', sqltype='CF_SQL_FLOAT'] , (param 59) = [type='IN', class='java.lang.Double', value='191243.0', sqltype='CF_SQL_FLOAT'] , (param 60) = [type='IN', class='java.lang.Double', value='193181.0', sqltype='CF_SQL_FLOAT'] , (param 61) = [type='IN', class='java.lang.Double', value='191558.0', sqltype='CF_SQL_FLOAT'] , (param 62) = [type='IN', class='java.lang.Double', value='195630.0', sqltype='CF_SQL_FLOAT'] , (param 63) = [type='IN', class='java.lang.Double', value='197929.0', sqltype='CF_SQL_FLOAT'] , (param 64) = [type='IN', class='java.lang.Double', value='89216.0', sqltype='CF_SQL_FLOAT'] , (param 65) = [type='IN', class='java.lang.Double', value='4945.0', sqltype='CF_SQL_FLOAT'] , (param 66) = [type='IN', class='java.lang.Double', value='136823.0', sqltype='CF_SQL_FLOAT'] , (param 67) = [type='IN', class='java.lang.Double', value='145313.0', sqltype='CF_SQL_FLOAT'] , (param 68) = [type='IN', class='java.lang.Double', value='157316.0', sqltype='CF_SQL_FLOAT'] , (param 69) = [type='IN', class='java.lang.Double', value='167968.0', sqltype='CF_SQL_FLOAT'] , (param 70) = [type='IN', class='java.lang.Double', value='168265.0', sqltype='CF_SQL_FLOAT'] , (param 71) = [type='IN', class='java.lang.Double', value='137928.0', sqltype='CF_SQL_FLOAT'] , (param 72) = [type='IN', class='java.lang.Double', value='169647.0', sqltype='CF_SQL_FLOAT'] , (param 73) = [type='IN', class='java.lang.Double', value='176772.0', sqltype='CF_SQL_FLOAT'] , (param 74) = [type='IN', class='java.lang.Double', value='89222.0', sqltype='CF_SQL_FLOAT'] , (param 75) = [type='IN', class='java.lang.Double', value='4573.0', sqltype='CF_SQL_FLOAT'] , (param 76) = [type='IN', class='java.lang.Double', value='3861.0', sqltype='CF_SQL_FLOAT'] , (param 77) = [type='IN', class='java.lang.Double', value='178379.0', sqltype='CF_SQL_FLOAT'] , (param 78) = [type='IN', class='java.lang.Double', value='182583.0', sqltype='CF_SQL_FLOAT'] , (param 79) = [type='IN', class='java.lang.Double', value='182686.0', sqltype='CF_SQL_FLOAT'] , (param 80) = [type='IN', class='java.lang.Double', value='184501.0', sqltype='CF_SQL_FLOAT'] , (param 81) = [type='IN', class='java.lang.Double', value='185951.0', sqltype='CF_SQL_FLOAT'] , (param 82) = [type='IN', class='java.lang.Double', value='190811.0', sqltype='CF_SQL_FLOAT'] , (param 83) = [type='IN', class='java.lang.Double', value='196861.0', sqltype='CF_SQL_FLOAT'] , (param 84) = [type='IN', class='java.lang.Double', value='197931.0', sqltype='CF_SQL_FLOAT'] , (param 85) = [type='IN', class='java.lang.Double', value='4790.0', sqltype='CF_SQL_FLOAT'] , (param 86) = [type='IN', class='java.lang.Double', value='3860.0', sqltype='CF_SQL_FLOAT'] , (param 87) = [type='IN', class='java.lang.Double', value='177668.0', sqltype='CF_SQL_FLOAT'] , (param 88) = [type='IN', class='java.lang.Double', value='185244.0', sqltype='CF_SQL_FLOAT'] , (param 89) = [type='IN', class='java.lang.Double', value='188404.0', sqltype='CF_SQL_FLOAT'] , (param 90) = [type='IN', class='java.lang.Double', value='197930.0', sqltype='CF_SQL_FLOAT'] , (param 91) = [type='IN', class='java.lang.Double', value='145310.0', sqltype='CF_SQL_FLOAT'] , (param 92) = [type='IN', class='java.lang.Double', value='145311.0', sqltype='CF_SQL_FLOAT'] , (param 93) = [type='IN', class='java.lang.Double', value='162924.0', sqltype='CF_SQL_FLOAT'] , (param 94) = [type='IN', class='java.lang.Double', value='178377.0', sqltype='CF_SQL_FLOAT'] , (param 95) = [type='IN', class='java.lang.Double', value='180785.0', sqltype='CF_SQL_FLOAT'] , (param 96) = [type='IN', class='java.lang.Double', value='188601.0', sqltype='CF_SQL_FLOAT'] , (param 97) = [type='IN', class='java.lang.Double', value='197018.0', sqltype='CF_SQL_FLOAT'] , (param 98) = [type='IN', class='java.lang.Double', value='89291.0', sqltype='CF_SQL_FLOAT'] , (param 99) = [type='IN', class='java.lang.Double', value='120777.0', sqltype='CF_SQL_FLOAT'] , (param 100) = [type='IN', class='java.lang.Double', value='89290.0', sqltype='CF_SQL_FLOAT'] , (param 101) = [type='IN', class='java.lang.Double', value='157314.0', sqltype='CF_SQL_FLOAT'] , (param 102) = [type='IN', class='java.lang.Double', value='197595.0', sqltype='CF_SQL_FLOAT'] , (param 103) = [type='IN', class='java.lang.Double', value='176773.0', sqltype='CF_SQL_FLOAT'] , (param 104) = [type='IN', class='java.lang.Double', value='176774.0', sqltype='CF_SQL_FLOAT'] , (param 105) = [type='IN', class='java.lang.Double', value='148566.0', sqltype='CF_SQL_FLOAT'] , (param 106) = [type='IN', class='java.lang.Double', value='178380.0', sqltype='CF_SQL_FLOAT'] , (param 107) = [type='IN', class='java.lang.Double', value='55150.0', sqltype='CF_SQL_FLOAT'] , (param 108) = [type='IN', class='java.lang.Double', value='55149.0', sqltype='CF_SQL_FLOAT'] , (param 109) = [type='IN', class='java.lang.Double', value='55152.0', sqltype='CF_SQL_FLOAT'] , (param 110) = [type='IN', class='java.lang.Double', value='55148.0', sqltype='CF_SQL_FLOAT'] 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 184) 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 184) 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 cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) 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 cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) 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 cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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 1597 RAW_TRACE at cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) TEMPLATE C:\websites\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 71 RAW_TRACE at cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) TEMPLATE C:\websites\defaultwebsite\category.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 226 RAW_TRACE at cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) TEMPLATE C:\websites\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException DataSource celerantSQL Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 184) 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 184) 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 184) 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 184) 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 cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) 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 cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) 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 cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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 1597 RAW_TRACE at cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) TEMPLATE C:\websites\functions\category.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 71 RAW_TRACE at cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) TEMPLATE C:\websites\defaultwebsite\category.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 226 RAW_TRACE at cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) TEMPLATE C:\websites\application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException SQLState 40001 Sql SELECT distinct style_id , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , min(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(hexLIST) as hexLIST , max(famList) as famList , max(sizelist) as sizelist , max(name) as name , max(of8) as of8Value ,(select max(bx.web_text) from TB_INET_NAMES as bx where bx.field_name='OF8' and bx.ORIG_TEXT=max(OF8)) as of8 , max(gender) as gender , max(agerange) as agerange , max(picture_id) as picture_id , 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 FROM [dbo].[web_all_products] WHERE pictureid is not null --Search Results AND style_id IN ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) , (param 70) , (param 71) , (param 72) , (param 73) , (param 74) , (param 75) , (param 76) , (param 77) , (param 78) , (param 79) , (param 80) , (param 81) , (param 82) , (param 83) , (param 84) , (param 85) , (param 86) , (param 87) , (param 88) , (param 89) , (param 90) , (param 91) , (param 92) , (param 93) , (param 94) , (param 95) , (param 96) , (param 97) , (param 98) , (param 99) , (param 100) , (param 101) , (param 102) , (param 103) , (param 104) , (param 105) , (param 106) , (param 107) , (param 108) , (param 109) , (param 110) ) and rtrim(ltrim(gender))= 'unisex' and rtrim(ltrim(agerange))= 'kids' and upper(gender)='UNISEX' and upper(agerange)='KIDS' GROUP BY STYLE_ID ORDER BY picture_id desc 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 cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) 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 cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) 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 cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) 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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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 184) 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) ... 68 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 1597 RAW_TRACE at cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) TEMPLATE C:\websites\functions\category.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 71 RAW_TRACE at cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) TEMPLATE C:\websites\defaultwebsite\category.cfm TYPE CFML 3 struct COLUMN 0 ID CFINCLUDE LINE 226 RAW_TRACE at cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) TEMPLATE C:\websites\application.cfc TYPE CFML 4 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 5 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 6 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 7 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 8 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 9 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 10 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 11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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 184) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. where (param 1) = [type='IN', class='java.lang.Double', value='178342.0', sqltype='CF_SQL_FLOAT'] , (param 2) = [type='IN', class='java.lang.Double', value='185603.0', sqltype='CF_SQL_FLOAT'] , (param 3) = [type='IN', class='java.lang.Double', value='89192.0', sqltype='CF_SQL_FLOAT'] , (param 4) = [type='IN', class='java.lang.Double', value='193182.0', sqltype='CF_SQL_FLOAT'] , (param 5) = [type='IN', class='java.lang.Double', value='193183.0', sqltype='CF_SQL_FLOAT'] , (param 6) = [type='IN', class='java.lang.Double', value='5416.0', sqltype='CF_SQL_FLOAT'] , (param 7) = [type='IN', class='java.lang.Double', value='131937.0', sqltype='CF_SQL_FLOAT'] , (param 8) = [type='IN', class='java.lang.Double', value='193185.0', sqltype='CF_SQL_FLOAT'] , (param 9) = [type='IN', class='java.lang.Double', value='4785.0', sqltype='CF_SQL_FLOAT'] , (param 10) = [type='IN', class='java.lang.Double', value='3757.0', sqltype='CF_SQL_FLOAT'] , (param 11) = [type='IN', class='java.lang.Double', value='158377.0', sqltype='CF_SQL_FLOAT'] , (param 12) = [type='IN', class='java.lang.Double', value='5417.0', sqltype='CF_SQL_FLOAT'] , (param 13) = [type='IN', class='java.lang.Double', value='3756.0', sqltype='CF_SQL_FLOAT'] , (param 14) = [type='IN', class='java.lang.Double', value='188403.0', sqltype='CF_SQL_FLOAT'] , (param 15) = [type='IN', class='java.lang.Double', value='3753.0', sqltype='CF_SQL_FLOAT'] , (param 16) = [type='IN', class='java.lang.Double', value='185832.0', sqltype='CF_SQL_FLOAT'] , (param 17) = [type='IN', class='java.lang.Double', value='4942.0', sqltype='CF_SQL_FLOAT'] , (param 18) = [type='IN', class='java.lang.Double', value='119677.0', sqltype='CF_SQL_FLOAT'] , (param 19) = [type='IN', class='java.lang.Double', value='187441.0', sqltype='CF_SQL_FLOAT'] , (param 20) = [type='IN', class='java.lang.Double', value='3863.0', sqltype='CF_SQL_FLOAT'] , (param 21) = [type='IN', class='java.lang.Double', value='154505.0', sqltype='CF_SQL_FLOAT'] , (param 22) = [type='IN', class='java.lang.Double', value='191855.0', sqltype='CF_SQL_FLOAT'] , (param 23) = [type='IN', class='java.lang.Double', value='89205.0', sqltype='CF_SQL_FLOAT'] , (param 24) = [type='IN', class='java.lang.Double', value='3862.0', sqltype='CF_SQL_FLOAT'] , (param 25) = [type='IN', class='java.lang.Double', value='115948.0', sqltype='CF_SQL_FLOAT'] , (param 26) = [type='IN', class='java.lang.Double', value='173236.0', sqltype='CF_SQL_FLOAT'] , (param 27) = [type='IN', class='java.lang.Double', value='181664.0', sqltype='CF_SQL_FLOAT'] , (param 28) = [type='IN', class='java.lang.Double', value='182528.0', sqltype='CF_SQL_FLOAT'] , (param 29) = [type='IN', class='java.lang.Double', value='185243.0', sqltype='CF_SQL_FLOAT'] , (param 30) = [type='IN', class='java.lang.Double', value='190838.0', sqltype='CF_SQL_FLOAT'] , (param 31) = [type='IN', class='java.lang.Double', value='199858.0', sqltype='CF_SQL_FLOAT'] , (param 32) = [type='IN', class='java.lang.Double', value='199857.0', sqltype='CF_SQL_FLOAT'] , (param 33) = [type='IN', class='java.lang.Double', value='4412.0', sqltype='CF_SQL_FLOAT'] , (param 34) = [type='IN', class='java.lang.Double', value='89200.0', sqltype='CF_SQL_FLOAT'] , (param 35) = [type='IN', class='java.lang.Double', value='3998.0', sqltype='CF_SQL_FLOAT'] , (param 36) = [type='IN', class='java.lang.Double', value='130885.0', sqltype='CF_SQL_FLOAT'] , (param 37) = [type='IN', class='java.lang.Double', value='4886.0', sqltype='CF_SQL_FLOAT'] , (param 38) = [type='IN', class='java.lang.Double', value='173239.0', sqltype='CF_SQL_FLOAT'] , (param 39) = [type='IN', class='java.lang.Double', value='188735.0', sqltype='CF_SQL_FLOAT'] , (param 40) = [type='IN', class='java.lang.Double', value='193180.0', sqltype='CF_SQL_FLOAT'] , (param 41) = [type='IN', class='java.lang.Double', value='198062.0', sqltype='CF_SQL_FLOAT'] , (param 42) = [type='IN', class='java.lang.Double', value='89297.0', sqltype='CF_SQL_FLOAT'] , (param 43) = [type='IN', class='java.lang.Double', value='4413.0', sqltype='CF_SQL_FLOAT'] , (param 44) = [type='IN', class='java.lang.Double', value='4935.0', sqltype='CF_SQL_FLOAT'] , (param 45) = [type='IN', class='java.lang.Double', value='89190.0', sqltype='CF_SQL_FLOAT'] , (param 46) = [type='IN', class='java.lang.Double', value='130891.0', sqltype='CF_SQL_FLOAT'] , (param 47) = [type='IN', class='java.lang.Double', value='130882.0', sqltype='CF_SQL_FLOAT'] , (param 48) = [type='IN', class='java.lang.Double', value='130883.0', sqltype='CF_SQL_FLOAT'] , (param 49) = [type='IN', class='java.lang.Double', value='161854.0', sqltype='CF_SQL_FLOAT'] , (param 50) = [type='IN', class='java.lang.Double', value='170515.0', sqltype='CF_SQL_FLOAT'] , (param 51) = [type='IN', class='java.lang.Double', value='176771.0', sqltype='CF_SQL_FLOAT'] , (param 52) = [type='IN', class='java.lang.Double', value='181661.0', sqltype='CF_SQL_FLOAT'] , (param 53) = [type='IN', class='java.lang.Double', value='181662.0', sqltype='CF_SQL_FLOAT'] , (param 54) = [type='IN', class='java.lang.Double', value='181665.0', sqltype='CF_SQL_FLOAT'] , (param 55) = [type='IN', class='java.lang.Double', value='181666.0', sqltype='CF_SQL_FLOAT'] , (param 56) = [type='IN', class='java.lang.Double', value='181667.0', sqltype='CF_SQL_FLOAT'] , (param 57) = [type='IN', class='java.lang.Double', value='181668.0', sqltype='CF_SQL_FLOAT'] , (param 58) = [type='IN', class='java.lang.Double', value='191040.0', sqltype='CF_SQL_FLOAT'] , (param 59) = [type='IN', class='java.lang.Double', value='191243.0', sqltype='CF_SQL_FLOAT'] , (param 60) = [type='IN', class='java.lang.Double', value='193181.0', sqltype='CF_SQL_FLOAT'] , (param 61) = [type='IN', class='java.lang.Double', value='191558.0', sqltype='CF_SQL_FLOAT'] , (param 62) = [type='IN', class='java.lang.Double', value='195630.0', sqltype='CF_SQL_FLOAT'] , (param 63) = [type='IN', class='java.lang.Double', value='197929.0', sqltype='CF_SQL_FLOAT'] , (param 64) = [type='IN', class='java.lang.Double', value='89216.0', sqltype='CF_SQL_FLOAT'] , (param 65) = [type='IN', class='java.lang.Double', value='4945.0', sqltype='CF_SQL_FLOAT'] , (param 66) = [type='IN', class='java.lang.Double', value='136823.0', sqltype='CF_SQL_FLOAT'] , (param 67) = [type='IN', class='java.lang.Double', value='145313.0', sqltype='CF_SQL_FLOAT'] , (param 68) = [type='IN', class='java.lang.Double', value='157316.0', sqltype='CF_SQL_FLOAT'] , (param 69) = [type='IN', class='java.lang.Double', value='167968.0', sqltype='CF_SQL_FLOAT'] , (param 70) = [type='IN', class='java.lang.Double', value='168265.0', sqltype='CF_SQL_FLOAT'] , (param 71) = [type='IN', class='java.lang.Double', value='137928.0', sqltype='CF_SQL_FLOAT'] , (param 72) = [type='IN', class='java.lang.Double', value='169647.0', sqltype='CF_SQL_FLOAT'] , (param 73) = [type='IN', class='java.lang.Double', value='176772.0', sqltype='CF_SQL_FLOAT'] , (param 74) = [type='IN', class='java.lang.Double', value='89222.0', sqltype='CF_SQL_FLOAT'] , (param 75) = [type='IN', class='java.lang.Double', value='4573.0', sqltype='CF_SQL_FLOAT'] , (param 76) = [type='IN', class='java.lang.Double', value='3861.0', sqltype='CF_SQL_FLOAT'] , (param 77) = [type='IN', class='java.lang.Double', value='178379.0', sqltype='CF_SQL_FLOAT'] , (param 78) = [type='IN', class='java.lang.Double', value='182583.0', sqltype='CF_SQL_FLOAT'] , (param 79) = [type='IN', class='java.lang.Double', value='182686.0', sqltype='CF_SQL_FLOAT'] , (param 80) = [type='IN', class='java.lang.Double', value='184501.0', sqltype='CF_SQL_FLOAT'] , (param 81) = [type='IN', class='java.lang.Double', value='185951.0', sqltype='CF_SQL_FLOAT'] , (param 82) = [type='IN', class='java.lang.Double', value='190811.0', sqltype='CF_SQL_FLOAT'] , (param 83) = [type='IN', class='java.lang.Double', value='196861.0', sqltype='CF_SQL_FLOAT'] , (param 84) = [type='IN', class='java.lang.Double', value='197931.0', sqltype='CF_SQL_FLOAT'] , (param 85) = [type='IN', class='java.lang.Double', value='4790.0', sqltype='CF_SQL_FLOAT'] , (param 86) = [type='IN', class='java.lang.Double', value='3860.0', sqltype='CF_SQL_FLOAT'] , (param 87) = [type='IN', class='java.lang.Double', value='177668.0', sqltype='CF_SQL_FLOAT'] , (param 88) = [type='IN', class='java.lang.Double', value='185244.0', sqltype='CF_SQL_FLOAT'] , (param 89) = [type='IN', class='java.lang.Double', value='188404.0', sqltype='CF_SQL_FLOAT'] , (param 90) = [type='IN', class='java.lang.Double', value='197930.0', sqltype='CF_SQL_FLOAT'] , (param 91) = [type='IN', class='java.lang.Double', value='145310.0', sqltype='CF_SQL_FLOAT'] , (param 92) = [type='IN', class='java.lang.Double', value='145311.0', sqltype='CF_SQL_FLOAT'] , (param 93) = [type='IN', class='java.lang.Double', value='162924.0', sqltype='CF_SQL_FLOAT'] , (param 94) = [type='IN', class='java.lang.Double', value='178377.0', sqltype='CF_SQL_FLOAT'] , (param 95) = [type='IN', class='java.lang.Double', value='180785.0', sqltype='CF_SQL_FLOAT'] , (param 96) = [type='IN', class='java.lang.Double', value='188601.0', sqltype='CF_SQL_FLOAT'] , (param 97) = [type='IN', class='java.lang.Double', value='197018.0', sqltype='CF_SQL_FLOAT'] , (param 98) = [type='IN', class='java.lang.Double', value='89291.0', sqltype='CF_SQL_FLOAT'] , (param 99) = [type='IN', class='java.lang.Double', value='120777.0', sqltype='CF_SQL_FLOAT'] , (param 100) = [type='IN', class='java.lang.Double', value='89290.0', sqltype='CF_SQL_FLOAT'] , (param 101) = [type='IN', class='java.lang.Double', value='157314.0', sqltype='CF_SQL_FLOAT'] , (param 102) = [type='IN', class='java.lang.Double', value='197595.0', sqltype='CF_SQL_FLOAT'] , (param 103) = [type='IN', class='java.lang.Double', value='176773.0', sqltype='CF_SQL_FLOAT'] , (param 104) = [type='IN', class='java.lang.Double', value='176774.0', sqltype='CF_SQL_FLOAT'] , (param 105) = [type='IN', class='java.lang.Double', value='148566.0', sqltype='CF_SQL_FLOAT'] , (param 106) = [type='IN', class='java.lang.Double', value='178380.0', sqltype='CF_SQL_FLOAT'] , (param 107) = [type='IN', class='java.lang.Double', value='55150.0', sqltype='CF_SQL_FLOAT'] , (param 108) = [type='IN', class='java.lang.Double', value='55149.0', sqltype='CF_SQL_FLOAT'] , (param 109) = [type='IN', class='java.lang.Double', value='55152.0', sqltype='CF_SQL_FLOAT'] , (param 110) = [type='IN', class='java.lang.Double', value='55148.0', sqltype='CF_SQL_FLOAT'] StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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 cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) 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 cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) 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 cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) 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) ... 37 more Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 184) 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) ... 68 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 1597 RAW_TRACE at cfcategory2ecfc1249146366$funcGETPRODUCTSFROMOVERALLQUERY.runFunction(C:\websites\functions\category.cfc:1597) TEMPLATE C:\websites\functions\category.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 71 RAW_TRACE at cfcategory2ecfm824199980.runPage(C:\websites\defaultwebsite\category.cfm:71) TEMPLATE C:\websites\defaultwebsite\category.cfm TYPE CFML 3 struct COLUMN 0 ID CFINCLUDE LINE 226 RAW_TRACE at cfapplication2ecfc1804277682$funcONREQUEST.runFunction(C:\websites\application.cfc:226) TEMPLATE C:\websites\application.cfc TYPE CFML 4 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 5 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 6 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 7 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 8 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 9 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 10 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 11 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 12 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 13 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 14 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 15 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 16 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 17 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 18 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 19 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