Sun Protection Apparel

27 ITEMS

24 / 48 / 72 / 96 / ALL Per Page

Patagonia Men's Capilene Cool Sun Hoody AQBX

Patagonia Men's Capilene Cool Sun Hoody Our Price: $89.00

Patagonia Men's Capilene Cool Sun Hoody TBIX

Patagonia Men's Capilene Cool Sun Hoody Our Price: $89.00

Patagonia Men's Long-Sleeved Capilene Cool Sun Shirt AQBX

Patagonia Men's Long- Sleeved Capilene Cool Sun Shirt Our Price: $79.00

Patagonia Men's Long-Sleeved Capilene Cool Sun Shirt TBIX

Patagonia Men's Long- Sleeved Capilene Cool Sun Shirt Our Price: $79.00

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 187) 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 656
Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 94
Called from E:/websites/GeigersEcommerce/category.cfm: line 120
Called from E:/websites/GeigersEcommerce/functions/itemdetails.cfc: line 656
Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 94
Called from E:/websites/GeigersEcommerce/category.cfm: line 120

654 : 		<cfif application.ALLOW_SHOW_OUT_OF_STOCK IS "NO" and not showOutOfStockSizes> AND e.qoh > 0</cfif>
655 : 		<cfif isDefined("arguments.attr1") and len(arguments.ATTR1) AND arguments.ATTR1 neq "NULL"> AND a.attr1_entry_id = #val(arguments.attr1)#</cfif>
656 : 		<cfif isDefined("arguments.attr2") and len(arguments.ATTR2) AND arguments.ATTR2 neq "NULL"> AND a.attr2_entry_id = #val(arguments.attr2)#</cfif>
657 : 
658 : 		GROUP BY b.siz

SQLSTATE	40001
DATASOURCE	celerantSQL
VENDORERRORCODE	1205
SQL	SELECT distinct(b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh+e.qc) as qoh FROM tb_skus a LEFT JOIN tb_size_entries b on (b.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_sku_buckets e on (e.sku_id = a.sku_id) WHERE a.style_id = (param 1) and b.siz <> 'N/A' GROUP BY b.siz ORDER BY max(a.scale_entry_id)

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	216.73.216.2
Referrer
Date/Time	25-Mar-26 10:33 AM

Stack Trace

at cfitemdetails2ecfc639694310$funcGETSIZES.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:656) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:94) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:120) at cfitemdetails2ecfc639694310$funcGETSIZES.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:656) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:94) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:120)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 187) 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$funcGETSIZES.runFunction(E:\websites\GeigersEcommerce\functions\itemdetails.cfc:656)
	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:94)
	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:120)
	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)