[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 144) 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 144) 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:1658)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14848)
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
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.LicenseFilter.invoke(LicenseFilter.java:30)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
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:842)
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
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
20
struct
COLUMN
0
ID
CFINCLUDE
LINE
212
RAW_TRACE
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
21
struct
COLUMN
0
ID
CF_CATEGORY
LINE
5
RAW_TRACE
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
22
struct
COLUMN
0
ID
CF_CATEGORY
LINE
1
RAW_TRACE
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
23
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
TEMPLATE
C:\websites\simmons\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 144) 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 144) 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 144) 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 144) 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:1658)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14848)
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
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.LicenseFilter.invoke(LicenseFilter.java:30)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
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:842)
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
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
20
struct
COLUMN
0
ID
CFINCLUDE
LINE
212
RAW_TRACE
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
21
struct
COLUMN
0
ID
CF_CATEGORY
LINE
5
RAW_TRACE
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
22
struct
COLUMN
0
ID
CF_CATEGORY
LINE
1
RAW_TRACE
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
23
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
TEMPLATE
C:\websites\simmons\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 1=1 AND ( 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) ) ) GROUP BY dept) b ON (upper(replace(a.dept,'''','')) = b.dept) WHERE a.dept > ' ' AND a.dept <> 'EMPTY' AND a.typ = 'EMPTY' 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:930)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14848)
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
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.LicenseFilter.invoke(LicenseFilter.java:30)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
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:842)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 144) 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:1658)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
... 74 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
212
RAW_TRACE
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_CATEGORY
LINE
5
RAW_TRACE
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_CATEGORY
LINE
1
RAW_TRACE
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
TEMPLATE
C:\websites\simmons\application.cfc
TYPE
CFML
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
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
18
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
19
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
20
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
21
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
22
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
23
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 144) 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 144) 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 144) 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:1658)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14848)
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
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.LicenseFilter.invoke(LicenseFilter.java:30)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
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:842)
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
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
20
struct
COLUMN
0
ID
CFINCLUDE
LINE
212
RAW_TRACE
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
21
struct
COLUMN
0
ID
CF_CATEGORY
LINE
5
RAW_TRACE
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
22
struct
COLUMN
0
ID
CF_CATEGORY
LINE
1
RAW_TRACE
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
23
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
TEMPLATE
C:\websites\simmons\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 144) 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 144) 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 144) 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 144) 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:1658)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14848)
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
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.LicenseFilter.invoke(LicenseFilter.java:30)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
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:842)
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
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
20
struct
COLUMN
0
ID
CFINCLUDE
LINE
212
RAW_TRACE
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
21
struct
COLUMN
0
ID
CF_CATEGORY
LINE
5
RAW_TRACE
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
22
struct
COLUMN
0
ID
CF_CATEGORY
LINE
1
RAW_TRACE
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
23
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
TEMPLATE
C:\websites\simmons\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 1=1 AND ( 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) ) ) GROUP BY dept) b ON (upper(replace(a.dept,'''','')) = b.dept) WHERE a.dept > ' ' AND a.dept <> 'EMPTY' AND a.typ = 'EMPTY' 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:930)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14848)
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
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.LicenseFilter.invoke(LicenseFilter.java:30)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
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:842)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 144) 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:1658)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
... 74 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\simmons\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CFINCLUDE
LINE
212
RAW_TRACE
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CF_CATEGORY
LINE
5
RAW_TRACE
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CF_CATEGORY
LINE
1
RAW_TRACE
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
TEMPLATE
C:\websites\simmons\category.cfm
TYPE
CFML
7
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
TEMPLATE
C:\websites\simmons\application.cfc
TYPE
CFML
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
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
18
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
19
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
20
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
21
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
22
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
23
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 144) 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.LicenseFilter.invoke(LicenseFilter.java:30)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
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:842)
Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930)
at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)
at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:14848)
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfsidenav2ecfm1523470106._factor22(C:\websites\simmons\includes\sidenav.cfm:102)
at cfsidenav2ecfm1523470106.runPage(C:\websites\simmons\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfcategory2ecfm1767977478._factor8(C:\websites\simmons\category.cfm:212)
at cfcategory2ecfm1767977478._factor9(C:\websites\simmons\category.cfm:5)
at cfcategory2ecfm1767977478.runPage(C:\websites\simmons\category.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfapplication2ecfc951857131$funcONREQUEST.runFunction(C:\websites\simmons\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
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)
... 41 more
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 144) 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:1658)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
... 74 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CF_CFPAGE
LINE
85
RAW_TRACE
at cfdepartments2ecfm499754773.runPage(C:\websites\simmons\includes\views\departments.cfm:85)