Error Occurred While Processing Request
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 153) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
The error occurred in E:/websites/GeigersEcommerce/functions/itemdetails.cfc: line 728 Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 82 Called from E:/websites/GeigersEcommerce/category.cfm: line 116 Called from E:/websites/GeigersEcommerce/functions/itemdetails.cfc: line 728 Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 82 Called from E:/websites/GeigersEcommerce/category.cfm: line 116
726 :
727 : GROUP BY b.attr1
728 : ORDER BY CASE WHEN max(b.attr1_entry_id) = #val(arguments.attr1)# THEN 1 ELSE 2 END
729 :
730 : </cfquery>
SQLSTATE
40001
DATASOURCE
celerantSQL
VENDORERRORCODE
1205
SQL
SELECT b.attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh
FROM tb_skus a
LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id)
LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
WHERE a.style_id= (param 1) and b.attr1 <> 'N/A'
AND isNull(a.sell_web,'Y') <> 'N'
GROUP BY b.attr1
ORDER BY CASE WHEN max(b.attr1_entry_id) = 0 THEN 1 ELSE 2 END
at cfitemdetails2ecfc639694310$funcGETCOLORS.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:728) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:82) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:116)
at cfitemdetails2ecfc639694310$funcGETCOLORS.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:728) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:82) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:116)
java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 153) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1501)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfitemdetails2ecfc639694310$funcGETCOLORS.runFunction(E:\websites\GeigersEcommerce\functions\itemdetails.cfc:728)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489)
at cfthumbnails2ecfm435612791.runPage(E:\websites\GeigersEcommerce\includes\views\thumbnails.cfm:82)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfcategory2ecfm908738381.runPage(E:\websites\GeigersEcommerce\category.cfm:116)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
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:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)