VISIT OUR MUSEUMS

Home Page
    • Logout
    • Billing
    • Shipping
    • View Orders
    • Track Your Order
  • TOYS & GAMES
    • EDUCATIONAL
    • CLASSICS
    • CRAFTS
    • PUZZLES & CARDS
    • PLUSH
      • struct
      EVENTNAME onRequest
      EXCEPTION
      struct
      Cause
      struct
      Cause
      struct
      ErrorCode 1205
      Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) 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 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
      Suppressed
      array[empty]
      TagContext
      array
      1
      struct
      COLUMN 0
      ID ??
      LINE 1095
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      2
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 980
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      3
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1124
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      4
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 193
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      5
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1153
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      6
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4126
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      7
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1059
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      8
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4275
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      9
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2035
      RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      10
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 632
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      11
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2699
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      12
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 526
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      13
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2508
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      14
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1358
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      15
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2703
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      16
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 525
      RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      17
      struct
      COLUMN 0
      ID CFQUERY
      LINE 1094
      RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094)
      TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
      TYPE CFML
      18
      struct
      COLUMN 0
      ID CF_TEMPLATEPROXY
      LINE 389
      RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389)
      TEMPLATE C:\websites\stratusecommerce\includes\header.cfm
      TYPE CFML
      19
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 2
      RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2)
      TEMPLATE C:\websites\stratusecommerce\category.cfm
      TYPE CFML
      20
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 224
      RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224)
      TEMPLATE C:\websites\stratusecommerce\application.cfc
      TYPE CFML
      Type java.sql.SQLTransactionRollbackException
      DataSource koalasql
      Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) 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 142) 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 142) 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 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
      Suppressed
      array[empty]
      TagContext
      array
      1
      struct
      COLUMN 0
      ID ??
      LINE 1095
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      2
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 980
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      3
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1124
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      4
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 193
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      5
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1153
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      6
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4126
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      7
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1059
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      8
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4275
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      9
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2035
      RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      10
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 632
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      11
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2699
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      12
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 526
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      13
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2508
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      14
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1358
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      15
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2703
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      16
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 525
      RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      17
      struct
      COLUMN 0
      ID CFQUERY
      LINE 1094
      RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094)
      TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
      TYPE CFML
      18
      struct
      COLUMN 0
      ID CF_TEMPLATEPROXY
      LINE 389
      RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389)
      TEMPLATE C:\websites\stratusecommerce\includes\header.cfm
      TYPE CFML
      19
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 2
      RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2)
      TEMPLATE C:\websites\stratusecommerce\category.cfm
      TYPE CFML
      20
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 224
      RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224)
      TEMPLATE C:\websites\stratusecommerce\application.cfc
      TYPE CFML
      Type java.sql.SQLTransactionRollbackException
      SQLState 40001
      Sql SELECT DISTINCT style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage, max(pictureid) as pictureid FROM web_all_products WHERE 1=1 --AND pictureid is not null and dept = (param 1) and len(realName)>0 GROUP BY STYLE_ID ORDER BY max(sortposition)
      StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 72 more
      Suppressed
      array[empty]
      TagContext
      array
      1
      struct
      COLUMN 0
      ID CFQUERY
      LINE 1094
      RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094)
      TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
      TYPE CFML
      2
      struct
      COLUMN 0
      ID CF_TEMPLATEPROXY
      LINE 389
      RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389)
      TEMPLATE C:\websites\stratusecommerce\includes\header.cfm
      TYPE CFML
      3
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 2
      RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2)
      TEMPLATE C:\websites\stratusecommerce\category.cfm
      TYPE CFML
      4
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 224
      RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224)
      TEMPLATE C:\websites\stratusecommerce\application.cfc
      TYPE CFML
      5
      struct
      COLUMN 0
      ID ??
      LINE 1095
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      6
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 980
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      7
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1124
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      8
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 193
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      9
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1153
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      10
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4126
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      11
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1059
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      12
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4275
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      13
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2035
      RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      14
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 632
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      15
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2699
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      16
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 526
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      17
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2508
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      18
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1358
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      19
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2703
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      20
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 525
      RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      Type Database
      queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
      where (param 1) = [type='IN', class='java.lang.String', value='TOYS & GAMES', sqltype='CF_SQL_LONGVARCHAR']
      Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
      Message Event handler exception.
      RootCause
      struct
      Cause
      struct
      ErrorCode 1205
      Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) 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 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
      Suppressed
      array[empty]
      TagContext
      array
      1
      struct
      COLUMN 0
      ID ??
      LINE 1095
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      2
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 980
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      3
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1124
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      4
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 193
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      5
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1153
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      6
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4126
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      7
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1059
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      8
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4275
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      9
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2035
      RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      10
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 632
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      11
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2699
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      12
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 526
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      13
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2508
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      14
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1358
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      15
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2703
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      16
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 525
      RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      17
      struct
      COLUMN 0
      ID CFQUERY
      LINE 1094
      RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094)
      TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
      TYPE CFML
      18
      struct
      COLUMN 0
      ID CF_TEMPLATEPROXY
      LINE 389
      RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389)
      TEMPLATE C:\websites\stratusecommerce\includes\header.cfm
      TYPE CFML
      19
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 2
      RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2)
      TEMPLATE C:\websites\stratusecommerce\category.cfm
      TYPE CFML
      20
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 224
      RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224)
      TEMPLATE C:\websites\stratusecommerce\application.cfc
      TYPE CFML
      Type java.sql.SQLTransactionRollbackException
      DataSource koalasql
      Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) 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 142) 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 142) 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 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
      Suppressed
      array[empty]
      TagContext
      array
      1
      struct
      COLUMN 0
      ID ??
      LINE 1095
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      2
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 980
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      3
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1124
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      4
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 193
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      5
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1153
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      6
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4126
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      7
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1059
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      8
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4275
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      9
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2035
      RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      10
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 632
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      11
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2699
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      12
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 526
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      13
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2508
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      14
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1358
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      15
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2703
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      16
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 525
      RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      17
      struct
      COLUMN 0
      ID CFQUERY
      LINE 1094
      RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094)
      TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
      TYPE CFML
      18
      struct
      COLUMN 0
      ID CF_TEMPLATEPROXY
      LINE 389
      RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389)
      TEMPLATE C:\websites\stratusecommerce\includes\header.cfm
      TYPE CFML
      19
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 2
      RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2)
      TEMPLATE C:\websites\stratusecommerce\category.cfm
      TYPE CFML
      20
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 224
      RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224)
      TEMPLATE C:\websites\stratusecommerce\application.cfc
      TYPE CFML
      Type java.sql.SQLTransactionRollbackException
      SQLState 40001
      Sql SELECT DISTINCT style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage, max(pictureid) as pictureid FROM web_all_products WHERE 1=1 --AND pictureid is not null and dept = (param 1) and len(realName)>0 GROUP BY STYLE_ID ORDER BY max(sortposition)
      StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 72 more
      Suppressed
      array[empty]
      TagContext
      array
      1
      struct
      COLUMN 0
      ID CFQUERY
      LINE 1094
      RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094)
      TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
      TYPE CFML
      2
      struct
      COLUMN 0
      ID CF_TEMPLATEPROXY
      LINE 389
      RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389)
      TEMPLATE C:\websites\stratusecommerce\includes\header.cfm
      TYPE CFML
      3
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 2
      RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2)
      TEMPLATE C:\websites\stratusecommerce\category.cfm
      TYPE CFML
      4
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 224
      RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224)
      TEMPLATE C:\websites\stratusecommerce\application.cfc
      TYPE CFML
      5
      struct
      COLUMN 0
      ID ??
      LINE 1095
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      6
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 980
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      7
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1124
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      8
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 193
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      9
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1153
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      10
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4126
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      11
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1059
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      12
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4275
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      13
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2035
      RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      14
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 632
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      15
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2699
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      16
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 526
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      17
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2508
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      18
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1358
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      19
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2703
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      20
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 525
      RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      Type Database
      queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
      where (param 1) = [type='IN', class='java.lang.String', value='TOYS & GAMES', sqltype='CF_SQL_LONGVARCHAR']
      StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227) at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 36 more Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 142) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 72 more
      Suppressed
      array[empty]
      TagContext
      array
      1
      struct
      COLUMN 0
      ID CFQUERY
      LINE 1094
      RAW_TRACE at cfcategory2ecfc73142977$funcGETFEATUREDITEMS.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1094)
      TEMPLATE C:\websites\stratusecommerce\functions\category.cfc
      TYPE CFML
      2
      struct
      COLUMN 0
      ID CF_TEMPLATEPROXY
      LINE 389
      RAW_TRACE at cfheader2ecfm260908490.runPage(C:\websites\stratusecommerce\includes\header.cfm:389)
      TEMPLATE C:\websites\stratusecommerce\includes\header.cfm
      TYPE CFML
      3
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 2
      RAW_TRACE at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:2)
      TEMPLATE C:\websites\stratusecommerce\category.cfm
      TYPE CFML
      4
      struct
      COLUMN 0
      ID CFINCLUDE
      LINE 224
      RAW_TRACE at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:224)
      TEMPLATE C:\websites\stratusecommerce\application.cfc
      TYPE CFML
      5
      struct
      COLUMN 0
      ID ??
      LINE 1095
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      6
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 980
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      7
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1124
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      8
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 193
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      9
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1153
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      10
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4126
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      11
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1059
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      12
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 4275
      RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      13
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2035
      RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      14
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 632
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      15
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2699
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      16
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 526
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      17
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2508
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      18
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 1358
      RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      19
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 2703
      RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      20
      struct
      COLUMN 0
      ID CF_|SQLSERVER|6.0.0
      LINE 525
      RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525)
      TEMPLATE |SQLServer|6.0.0.1282|
      TYPE CFML
      Type Database
      name onRequest