struct
Cause	struct ErrorCode 1205 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 83) 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 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfvehicleService2ecfc1150482003$funcGETSTYLEINVENTORY.runFunction(C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc:529) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4139) at cfresults2dby2dstate2ecfm305727816._factor3(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:63) at cfresults2dby2dstate2ecfm305727816.runPage(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfApplication2ecfc2186886$funcONREQUEST.runFunction(C:\home\shop.promotivecar.com\wwwroot\Application.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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:834) Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID ?? LINE 1095 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 2 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 980 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 3 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1124 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 4 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 193 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 5 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1153 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 6 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4126 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 7 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1059 RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 8 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4275 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 9 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2035 RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 10 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 632 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 11 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2699 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 12 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 526 RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 13 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2508 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 14 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1358 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 15 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2703 RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 16 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 525 RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 17 struct COLUMN 0 ID CFQUERY LINE 529 RAW_TRACE at cfvehicleService2ecfc1150482003$funcGETSTYLEINVENTORY.runFunction(C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc:529) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 63 RAW_TRACE at cfresults2dby2dstate2ecfm305727816._factor3(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:63) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm TYPE CFML 19 struct COLUMN 0 ID CF_RESULTS-BY-STATE LINE 1 RAW_TRACE at cfresults2dby2dstate2ecfm305727816.runPage(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:1) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm TYPE CFML 20 struct COLUMN 0 ID CFINCLUDE LINE 121 RAW_TRACE at cfApplication2ecfc2186886$funcONREQUEST.runFunction(C:\home\shop.promotivecar.com\wwwroot\Application.cfc:121) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\Application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException
DataSource	ProMotive
Detail	[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 83) 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 83) 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 83) 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 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfvehicleService2ecfc1150482003$funcGETSTYLEINVENTORY.runFunction(C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc:529) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4139) at cfresults2dby2dstate2ecfm305727816._factor3(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:63) at cfresults2dby2dstate2ecfm305727816.runPage(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfApplication2ecfc2186886$funcONREQUEST.runFunction(C:\home\shop.promotivecar.com\wwwroot\Application.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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:834) Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID ?? LINE 1095 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 2 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 980 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 3 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1124 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 4 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 193 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 5 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1153 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 6 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4126 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 7 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1059 RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 8 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4275 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 9 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2035 RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 10 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 632 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 11 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2699 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 12 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 526 RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 13 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2508 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 14 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1358 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 15 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2703 RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 16 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 525 RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 17 struct COLUMN 0 ID CFQUERY LINE 529 RAW_TRACE at cfvehicleService2ecfc1150482003$funcGETSTYLEINVENTORY.runFunction(C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc:529) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc TYPE CFML 18 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 63 RAW_TRACE at cfresults2dby2dstate2ecfm305727816._factor3(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:63) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm TYPE CFML 19 struct COLUMN 0 ID CF_RESULTS-BY-STATE LINE 1 RAW_TRACE at cfresults2dby2dstate2ecfm305727816.runPage(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:1) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm TYPE CFML 20 struct COLUMN 0 ID CFINCLUDE LINE 121 RAW_TRACE at cfApplication2ecfc2186886$funcONREQUEST.runFunction(C:\home\shop.promotivecar.com\wwwroot\Application.cfc:121) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\Application.cfc TYPE CFML Type java.sql.SQLTransactionRollbackException
SQLState	40001
Sql	declare @cntPerPage int = 10; declare @startRow int = ((1-1)*@cntPerPage)+1; declare @endRow int = 1*@cntPerPage; DECLARE @typeZip VARCHAR(50) = ''; SELECT temp.VIN, temp.DealerName, temp.City, temp.State, temp.Zip, temp.Mileage,temp.NewUsed,temp.PhotoURLS,temp.PhotoURLPromotive,temp.EstimatedPayment, temp.promotivecarprice, temp.CityStateLink, temp.CarTrim, temp.ProMotiveCarVDP, temp.Phone, temp.DownPayment, temp.CarNameLink, temp.CarName, temp.CityState, temp.make, temp.model, temp.year, temp.vehicletype, temp.Latitude, temp.Longitude,temp.PaymentCustomerID,temp.total,temp.rowNum, temp.dealerSiteURL, temp.DealerID FROM ( SELECT TOP 500 D.DealerID, MI.VIN, D.DealerName, MI.City, MI.State, MI.Zip, MI.Mileage,MI.NewUsed,MI.PhotoURLS,MI.PhotoURLPromotive,MI.EstimatedPayment, MI.promotivecarprice, MI.CarTrim, MI.ProMotiveCarVDP, MI.Phone, MI.DownPayment, MI.CarNameLink, MI.CarName, MI.make, MI.model, MI.year, MI.vehicletype,IDL.Latitude, IDL.Longitude,CPI.PaymentCustomerID, MI.City + '-' + MI.State AS CityStateLink, MI.City + ',' + MI.State AS CityState , ( SELECT TOP 1 dealerSiteURL FROM dealers WHERE phone = D.phone ) as dealerSiteURL ,ROW_NUMBER() OVER (order by zip asc ) as rowNum ,0 AS total FROM dbo.MyInventory AS MI LEFT OUTER JOIN dbo.Dealers AS D ON MI.Phone = D.Phone OR D.PhoneNumbers <> '' AND D.Phone <> '' AND D.PhoneNumbers LIKE '%' + MI.Phone + '%' INNER JOIN dbo.users AS U On U.Email = D.EMail LEFT OUTER JOIN dbo.CustomerPaymentInfo as CPI ON CPI.PaymentCustomerID = U.UserID INNER JOIN dbo.qry_inventory_dealer_latlng AS IDL ON MI.Zip = IDL.ZipCode WHERE 1=1 AND MI.PhotoUrls <> '' AND MI.year > '1999' AND MI.State = (param 1) AND MI.city = (param 2) ) as temp
StackTrace	coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfvehicleService2ecfc1150482003$funcGETSTYLEINVENTORY.runFunction(C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc:529) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4139) at cfresults2dby2dstate2ecfm305727816._factor3(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:63) at cfresults2dby2dstate2ecfm305727816.runPage(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211) at cfApplication2ecfc2186886$funcONREQUEST.runFunction(C:\home\shop.promotivecar.com\wwwroot\Application.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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:834) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1629) at coldfusion.sql.Executive.executeQuery(Executive.java:1355) at coldfusion.sql.Executive.executeQuery(Executive.java:1285) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) ... 72 more
Suppressed	array[empty]
TagContext	array 1 struct COLUMN 0 ID CFQUERY LINE 529 RAW_TRACE at cfvehicleService2ecfc1150482003$funcGETSTYLEINVENTORY.runFunction(C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc:529) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\models\vehicleService.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 63 RAW_TRACE at cfresults2dby2dstate2ecfm305727816._factor3(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:63) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm TYPE CFML 3 struct COLUMN 0 ID CF_RESULTS-BY-STATE LINE 1 RAW_TRACE at cfresults2dby2dstate2ecfm305727816.runPage(C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm:1) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\results-by-state.cfm TYPE CFML 4 struct COLUMN 0 ID CFINCLUDE LINE 121 RAW_TRACE at cfApplication2ecfc2186886$funcONREQUEST.runFunction(C:\home\shop.promotivecar.com\wwwroot\Application.cfc:121) TEMPLATE C:\home\shop.promotivecar.com\wwwroot\Application.cfc TYPE CFML 5 struct COLUMN 0 ID ?? LINE 1095 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 6 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 980 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 7 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1124 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 8 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 193 RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 9 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1153 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 10 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4126 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 11 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1059 RAW_TRACE at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 12 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 4275 RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 13 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2035 RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 14 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 632 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 15 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2699 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 16 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 526 RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 17 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2508 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 18 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 1358 RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 19 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 2703 RAW_TRACE at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML 20 struct COLUMN 0 ID CF_|SQLSERVER|6.0.0 LINE 525 RAW_TRACE at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) TEMPLATE |SQLServer|6.0.0.1282| TYPE CFML
Type	Database
queryError	[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
where	(param 1) = [type='IN', class='java.lang.String', value='PA', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.String', value='MECHANICSBURG', sqltype='cf_sql_varchar']