struct
Cause	struct ErrorCode 1205 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 69) 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 69) 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.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.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.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1642) 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.QueryTag.doEndTag(QueryTag.java:822) at cfhead2ecfm491598400._factor13(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:366) at cfhead2ecfm491598400._factor14(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:328) at cfhead2ecfm491598400._factor87(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:297) at cfhead2ecfm491598400._factor88(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:117) at cfhead2ecfm491598400.runPage(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cffind2ecfm82085996._factor18(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:14) at cffind2ecfm82085996._factor20(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:3) at cffind2ecfm82085996.runPage(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) 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:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) 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:481) 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:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) 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:833) 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 4275 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 8 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 9 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 10 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 11 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 12 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 13 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4478 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 14 struct COLUMN 0 ID CFQUERY LINE 366 RAW_TRACE at cfhead2ecfm491598400._factor13(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:366) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 15 struct COLUMN 0 ID CF_HEAD LINE 328 RAW_TRACE at cfhead2ecfm491598400._factor14(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:328) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 16 struct COLUMN 0 ID CF_HEAD LINE 297 RAW_TRACE at cfhead2ecfm491598400._factor87(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:297) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 17 struct COLUMN 0 ID CF_HEAD LINE 117 RAW_TRACE at cfhead2ecfm491598400._factor88(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:117) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 18 struct COLUMN 0 ID CF_HEAD LINE 1 RAW_TRACE at cfhead2ecfm491598400.runPage(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:1) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 14 RAW_TRACE at cffind2ecfm82085996._factor18(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:14) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML 20 struct COLUMN 0 ID CF_FIND LINE 3 RAW_TRACE at cffind2ecfm82085996._factor20(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:3) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML 21 struct COLUMN 0 ID CF_FIND LINE 1 RAW_TRACE at cffind2ecfm82085996.runPage(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:1) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML Type java.sql.SQLTransactionRollbackException
DataSource	hatland
Detail	[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 69) 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 69) 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 69) 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 69) 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.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.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.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1642) 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.QueryTag.doEndTag(QueryTag.java:822) at cfhead2ecfm491598400._factor13(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:366) at cfhead2ecfm491598400._factor14(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:328) at cfhead2ecfm491598400._factor87(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:297) at cfhead2ecfm491598400._factor88(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:117) at cfhead2ecfm491598400.runPage(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cffind2ecfm82085996._factor18(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:14) at cffind2ecfm82085996._factor20(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:3) at cffind2ecfm82085996.runPage(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) 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:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) 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:481) 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:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) 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:833) 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 4275 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 8 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 9 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 10 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 11 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 12 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 13 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4478 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 14 struct COLUMN 0 ID CFQUERY LINE 366 RAW_TRACE at cfhead2ecfm491598400._factor13(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:366) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 15 struct COLUMN 0 ID CF_HEAD LINE 328 RAW_TRACE at cfhead2ecfm491598400._factor14(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:328) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 16 struct COLUMN 0 ID CF_HEAD LINE 297 RAW_TRACE at cfhead2ecfm491598400._factor87(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:297) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 17 struct COLUMN 0 ID CF_HEAD LINE 117 RAW_TRACE at cfhead2ecfm491598400._factor88(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:117) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 18 struct COLUMN 0 ID CF_HEAD LINE 1 RAW_TRACE at cfhead2ecfm491598400.runPage(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:1) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 19 struct COLUMN 0 ID CFINCLUDE LINE 14 RAW_TRACE at cffind2ecfm82085996._factor18(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:14) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML 20 struct COLUMN 0 ID CF_FIND LINE 3 RAW_TRACE at cffind2ecfm82085996._factor20(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:3) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML 21 struct COLUMN 0 ID CF_FIND LINE 1 RAW_TRACE at cffind2ecfm82085996.runPage(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:1) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML Type java.sql.SQLTransactionRollbackException
SQLState	40001
Sql	SELECT prodid FROM products where active=1 and ((name like '%2019%') or (description like '%2019%') or (code like '%2019%') or (brand like '%2019%') or (sport like '%2019%') or (home like '%2019%')) and ((name like '%fathers%') or (description like '%fathers%') or (code like '%fathers%') or (brand like '%fathers%') or (sport like '%fathers%') or (home like '%fathers%')) and ((name like '%day%') or (description like '%day%') or (code like '%day%') or (brand like '%day%') or (sport like '%day%') or (home like '%day%')) ORDER BY pddate DESC, code
StackTrace	coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfhead2ecfm491598400._factor13(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:366) at cfhead2ecfm491598400._factor14(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:328) at cfhead2ecfm491598400._factor87(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:297) at cfhead2ecfm491598400._factor88(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:117) at cfhead2ecfm491598400.runPage(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cffind2ecfm82085996._factor18(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:14) at cffind2ecfm82085996._factor20(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:3) at cffind2ecfm82085996.runPage(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) 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:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) 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:481) 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:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) 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:833) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 69) 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.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.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.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1642) 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) ... 57 more
Suppressed	array[empty]
TagContext	array 1 struct COLUMN 0 ID CFQUERY LINE 366 RAW_TRACE at cfhead2ecfm491598400._factor13(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:366) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 2 struct COLUMN 0 ID CF_HEAD LINE 328 RAW_TRACE at cfhead2ecfm491598400._factor14(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:328) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 3 struct COLUMN 0 ID CF_HEAD LINE 297 RAW_TRACE at cfhead2ecfm491598400._factor87(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:297) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 4 struct COLUMN 0 ID CF_HEAD LINE 117 RAW_TRACE at cfhead2ecfm491598400._factor88(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:117) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 5 struct COLUMN 0 ID CF_HEAD LINE 1 RAW_TRACE at cfhead2ecfm491598400.runPage(C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm:1) TEMPLATE C:\inetpub\wwwroot\clients\hatland3.com\template\head.cfm TYPE CFML 6 struct COLUMN 0 ID CFINCLUDE LINE 14 RAW_TRACE at cffind2ecfm82085996._factor18(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:14) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML 7 struct COLUMN 0 ID CF_FIND LINE 3 RAW_TRACE at cffind2ecfm82085996._factor20(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:3) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML 8 struct COLUMN 0 ID CF_FIND LINE 1 RAW_TRACE at cffind2ecfm82085996.runPage(C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm:1) TEMPLATE C:\Inetpub\wwwroot\Clients\hatland3.com\find.cfm TYPE CFML 9 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 10 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 11 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 12 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 13 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 14 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 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 2508 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 20 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 21 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4478 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML
Type	Database
queryError	[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
where	[empty string]