Please verify that you are not a robot.

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 186) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in D:/Websites/functions/itemDetails.cfc: line 1004
Called from D:/Websites/defaultWebsite/products.cfm: line 236
Called from D:/Websites/defaultWebsite/products.cfm: line 119
Called from D:/Websites/defaultWebsite/products.cfm: line 1
Called from D:/Websites/defaultWebsite/products.cfm: line 1
Called from D:/Websites/functions/itemDetails.cfc: line 1004
Called from D:/Websites/defaultWebsite/products.cfm: line 236
Called from D:/Websites/defaultWebsite/products.cfm: line 119
Called from D:/Websites/defaultWebsite/products.cfm: line 1
Called from D:/Websites/defaultWebsite/products.cfm: line 1
1002 : 		<cfif application.ALLOW_SHOW_OUT_OF_STOCK eq "NO"> AND (e.qoh+e.qc) > 0</cfif>
1003 : 		<cfif isDefined("arguments.url.siz") and len(arguments.URL.SIZ) AND arguments.URL.SIZ neq "NULL"> AND a.scale_entry_id = #val(arguments.URL.SIZ)#</cfif>
1004 : 		<cfif isDefined("arguments.url.attr2") and len(arguments.URL.ATTR2) AND arguments.URL.ATTR2 neq "NULL"> AND a.attr2_entry_id = #val(arguments.URL.attr2)#</cfif>
1005 : 
1006 : 		GROUP BY b.attr1

SQLSTATE   40001
DATASOURCE   celerantSQL
VENDORERRORCODE   1205
SQL    SELECT distinct(b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(a.sku_of1) as rgb FROM tb_skus a LEFT JOIN tb_attr1_entries b on (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e on (e.sku_id = a.sku_id) WHERE a.style_id = 57289 and e.price>0 AND a.sell_web <> 'N' AND e.store_id=8004 AND (e.qoh+e.qc) > 0 GROUP BY b.attr1 ORDER BY max(b.attr1_entry_id)
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.167.112.42
Referrer  
Date/Time   16-Nov-18 02:35 AM
Stack Trace
at cfitemDetails2ecfc2086082739$funcGETATTR1BYSTYLEID.runFunction(D:/Websites/functions/itemDetails.cfc:1004) at cfproducts2ecfm507695861._factor12(D:/Websites/defaultWebsite/products.cfm:236) at cfproducts2ecfm507695861._factor17(D:/Websites/defaultWebsite/products.cfm:119) at cfproducts2ecfm507695861._factor18(D:/Websites/defaultWebsite/products.cfm:1) at cfproducts2ecfm507695861.runPage(D:/Websites/defaultWebsite/products.cfm:1) at cfitemDetails2ecfc2086082739$funcGETATTR1BYSTYLEID.runFunction(D:/Websites/functions/itemDetails.cfc:1004) at cfproducts2ecfm507695861._factor12(D:/Websites/defaultWebsite/products.cfm:236) at cfproducts2ecfm507695861._factor17(D:/Websites/defaultWebsite/products.cfm:119) at cfproducts2ecfm507695861._factor18(D:/Websites/defaultWebsite/products.cfm:1) at cfproducts2ecfm507695861.runPage(D:/Websites/defaultWebsite/products.cfm:1)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 186) 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.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.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1531)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1281)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1211)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cfitemDetails2ecfc2086082739$funcGETATTR1BYSTYLEID.runFunction(D:\Websites\functions\itemDetails.cfc:1004)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3097)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3074)
	at cfproducts2ecfm507695861._factor12(D:\Websites\defaultWebsite\products.cfm:236)
	at cfproducts2ecfm507695861._factor17(D:\Websites\defaultWebsite\products.cfm:119)
	at cfproducts2ecfm507695861._factor18(D:\Websites\defaultWebsite\products.cfm:1)
	at cfproducts2ecfm507695861.runPage(D:\Websites\defaultWebsite\products.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	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: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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	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:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:363)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:507)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	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)