[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) 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 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
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.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
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:5201)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
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:5201)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
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:5201)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
3
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
160
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
231
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) 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 123) 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 123) 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 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
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.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
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:5201)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
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:5201)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
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:5201)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
3
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
160
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
231
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
SQLState
40001
Sql
SELECT a.dept as tax_name, a.web_url, sum(b.taxCount) as itemCount, 0 as active FROM tb_web_taxonomy a WITH (NOLOCK) INNER JOIN (SELECT dept, count(style_id) as taxCount FROM web_all_products WHERE ( 2000 < (param 1) OR style_id IN ( (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) ) ) GROUP BY dept) b ON (upper(replace(a.dept,'''','')) = b.dept) WHERE (a.active<>0 OR a.dept='SEARCH' OR upper(a.dept)='GIFT CARDS') AND isNull(a.sort_position,'')<>'NO' AND len(a.web_url)>0 AND a.site = 1 AND a.dept > ' ' AND a.dept <> 'EMPTY' AND a.typ = 'EMPTY' COLLATE SQL_Latin1_General_CP1_CS_AS GROUP BY a.dept, a.web_url ORDER BY min(a.sort_position)
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
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:5201)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
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:5201)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
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:5201)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
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)
... 71 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
3
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
160
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
231
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
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 123) 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 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
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.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
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:5201)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
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:5201)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
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:5201)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
3
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
160
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
231
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) 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 123) 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 123) 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 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
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.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
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:5201)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
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:5201)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
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:5201)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
3
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
160
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
231
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
SQLState
40001
Sql
SELECT a.dept as tax_name, a.web_url, sum(b.taxCount) as itemCount, 0 as active FROM tb_web_taxonomy a WITH (NOLOCK) INNER JOIN (SELECT dept, count(style_id) as taxCount FROM web_all_products WHERE ( 2000 < (param 1) OR style_id IN ( (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) ) ) GROUP BY dept) b ON (upper(replace(a.dept,'''','')) = b.dept) WHERE (a.active<>0 OR a.dept='SEARCH' OR upper(a.dept)='GIFT CARDS') AND isNull(a.sort_position,'')<>'NO' AND len(a.web_url)>0 AND a.site = 1 AND a.dept > ' ' AND a.dept <> 'EMPTY' AND a.typ = 'EMPTY' COLLATE SQL_Latin1_General_CP1_CS_AS GROUP BY a.dept, a.web_url ORDER BY min(a.sort_position)
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
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:5201)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
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:5201)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
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:5201)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
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)
... 71 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
3
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
160
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
231
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
coldfusion.runtime.EventHandlerException: Event handler exception.
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)
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:5201)
at cfsidenav2ecfm48817863._factor25(C:\websites\stratusecommerce\includes\sidenav.cfm:17)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:3)
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:5201)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:160)
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:5201)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:231)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
... 40 more
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
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)
... 71 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:85)