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]Connection reset by peer: socket write error
 
The error occurred in D:/webs/jayssportinggoods.com/queries/grandgetproducts.cfm: line 142
Called from D:/webs/jayssportinggoods.com/Application.cfm: line 450
Called from D:/webs/jayssportinggoods.com/queries/grandgetproducts.cfm: line 142
Called from D:/webs/jayssportinggoods.com/Application.cfm: line 450
140 : 		a.picture_id IS NOT NULL <!---and c.store_id<>95 and e.category_style<>'OLD CATEGORY' and e.category_style<>'INACTIVE'
141 : --->
142 : 			and c.store_id=#qoh_store#
143 :             and a.web_product='Y'
144 : 			and a.brand = 'TURKEY FAN'

SQLSTATE   08S01
SQL    SELECT distinct b.sku_id, (d.styles_web_taxonomy_id) as styles_web_taxonomy_id ,max(a.style_id) as style_id ,max(a.picture_id) ,max(a.style) as style , max(CASE WHEN a.web_style IS NULL OR a.web_style = '' THEN CAST(a.style_id AS VARCHAR(20)) ELSE a.web_style END) as web_style ,min(j.price) as min_price, max(j.sugg_price) as max_price, max(j.price) as sugg_price1 ,max(c.qoh) as qoh ,sum(c.qoh) as totalqoh ,max(c.qs) as qs ,max(c.qc) as qc ,max(a.web_desc) as web_desc ,max(a.description) as description ,max(a.web_long_desc) as web_long_desc ,max(a.picture_id) as picture_id ,max(e.dept) as dept ,max(e.typ) as typ ,max(e.subtyp_1) as subtyp_1 ,max(e.subtyp_2) as subtyp_2 ,max(e.subtyp_3) as subtyp_3 ,max(e.category_style) as category_style ,max(e.web_url) as web_url ,max(e.sort_position) as sort_position ,max(e.web_taxonomy_id) as web_taxonomy_id ,max(e.sort_position) as sort_position ,max(CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE CASE WHEN z.web_text = 'NO SHOW' THEN '' ELSE z.web_text END END) as brand ,max(a.of1) as of1 ,MAX(c.sugg_price) AS max_sugg_price ,max(a.web_product) as web_product ,max(g.attr1_alias) as attr1 ,max(a.of7) as of7 ,max(g.attr1_entry_id) as attr1_entry_id ,max(f.siz) as siz ,max(f.scale_entry_id) as scale_entry_id ,max(a.of3) as of3 ,max(a.of4) as of4 ,max(a.of14) as of14 ,max(a.of15) as of15 FROM tb_styles a WITH (NOLOCK) INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_size_entries f WITH (NOLOCK) ON (f.scale_entry_id = b.scale_entry_id) LEFT JOIN tb_attr1_entries g WITH (NOLOCK) ON (g.attr1_entry_id = b.attr1_entry_id) INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id) INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style) INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id) LEFT JOIN dbo.tb_sku_buckets j WITH (NOLOCK) ON (b.sku_id = j.sku_id and j.store_id = 1) LEFT JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text) WHERE a.picture_id IS NOT NULL and c.store_id=1 and a.web_product='Y' and a.brand = 'TURKEY FAN' and e.sort_position <> 'NO' GROUP BY b.sku_id,d.styles_web_taxonomy_id
DATASOURCE   celerantsql
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.198.208.159
Referrer  
Date/Time   26-May-16 06:38 AM
Stack Trace
at cfgrandgetproducts2ecfm779487719.runPage(D:/webs/jayssportinggoods.com/queries/grandgetproducts.cfm:142) at cfApplication2ecfm1830499730.runPage(D:/webs/jayssportinggoods.com/Application.cfm:450) at cfgrandgetproducts2ecfm779487719.runPage(D:/webs/jayssportinggoods.com/queries/grandgetproducts.cfm:142) at cfApplication2ecfm1830499730.runPage(D:/webs/jayssportinggoods.com/Application.cfm:450)

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
	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.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddg.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.h(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.r(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 cfgrandgetproducts2ecfm779487719.runPage(D:\webs\jayssportinggoods.com\queries\grandgetproducts.cfm:142)
	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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2991)
	at cfApplication2ecfm1830499730.runPage(D:\webs\jayssportinggoods.com\Application.cfm:450)
	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.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:388)
	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:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
	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)