Home > Apparel > Men`s > Hunting > Big Game > Fanatic Bib (Item #50086)


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 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in C:/websites/defaultWebsite/products.cfm: line 142
Called from C:/websites/defaultWebsite/products.cfm: line 91
Called from C:/websites/defaultWebsite/products.cfm: line 5
Called from C:/websites/defaultWebsite/products.cfm: line 1
Called from C:/websites/defaultWebsite/products.cfm: line 142
Called from C:/websites/defaultWebsite/products.cfm: line 91
Called from C:/websites/defaultWebsite/products.cfm: line 5
Called from C:/websites/defaultWebsite/products.cfm: line 1
140 :             in (select LL.LOOKUP from  TB_SKU_LOOKUPS LL 
141 :                join TB_SKUS SS with(nolock) on SS.SKU_ID = LL.SKU_ID and LL.PRIME = 'Y'
142 :                join TB_STYLES STT with(nolock) on STT.STYLE_ID = SS.STYLE_ID and  STT.STYLE_ID = #getproducts.style_id#)
143 :      </cfquery>
144 :         

SQLSTATE   40001
DATASOURCE   celerantSQL
VENDORERRORCODE   1205
SQL    Select '/shop/' + lower(replace(ST.BRAND,' ','-')) + '/-' + cast(ST.STYLE_ID as varchar) as PACKAGEURL ,(select max(realname) from web_all_retail_products PP where PP.style_id = S.STYLE_ID) as realname ,S.STYLE_ID from TB_SKU_LOOKUPS L Left Join TB_PACKAGE_ITEM PKI with(nolock) on PKI.SKU_ID = L.SKU_ID Left Join TB_PACKAGE_GROUP PG with(nolock) on PG.PACKAGE_GROUP_ID = PKI.PACKAGE_GROUP_ID LEFT join TB_PACKAGE P with(nolock) on P.PACKAGE_ID = PG.PACKAGE_ID Left Join TB_SKUS S with(nolock) On S.SKU_ID = P.SKU_ID Left Join TB_STYLES ST with(nolock) on ST.STYLE_ID = S.STYLE_ID where L.LOOKUP in (select LL.LOOKUP from TB_SKU_LOOKUPS LL join TB_SKUS SS with(nolock) on SS.SKU_ID = LL.SKU_ID and LL.PRIME = 'Y' join TB_STYLES STT with(nolock) on STT.STYLE_ID = SS.STYLE_ID and STT.STYLE_ID = 255252)
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.147.244.157
Referrer  
Date/Time   20-Jan-17 06:11 PM
Stack Trace
at cfproducts2ecfm1432208818._factor10(C:/websites/defaultWebsite/products.cfm:142) at cfproducts2ecfm1432208818._factor18(C:/websites/defaultWebsite/products.cfm:91) at cfproducts2ecfm1432208818._factor20(C:/websites/defaultWebsite/products.cfm:5) at cfproducts2ecfm1432208818.runPage(C:/websites/defaultWebsite/products.cfm:1) at cfproducts2ecfm1432208818._factor10(C:/websites/defaultWebsite/products.cfm:142) at cfproducts2ecfm1432208818._factor18(C:/websites/defaultWebsite/products.cfm:91) at cfproducts2ecfm1432208818._factor20(C:/websites/defaultWebsite/products.cfm:5) at cfproducts2ecfm1432208818.runPage(C:/websites/defaultWebsite/products.cfm:1)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 123) 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:1479)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1159)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1185)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:814)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:767)
	at cfproducts2ecfm1432208818._factor10(C:\websites\defaultWebsite\products.cfm:142)
	at cfproducts2ecfm1432208818._factor18(C:\websites\defaultWebsite\products.cfm:91)
	at cfproducts2ecfm1432208818._factor20(C:\websites\defaultWebsite\products.cfm:5)
	at cfproducts2ecfm1432208818.runPage(C:\websites\defaultWebsite\products.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	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:487)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:142)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	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:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	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)