Home KIDS

23 ITEMS

24  / 48  / 72  / 96  / ALL Per Page

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

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.218.234.83
Referrer  
Date/Time   03-May-24 11:06 AM
Stack Trace
at cfitemdetails2ecfc639694310$funcGETSIZES.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:656) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:81) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:114) at cfitemdetails2ecfc639694310$funcGETSIZES.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:656) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:81) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:114) 

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 173) 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:81)
	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:114)
	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)