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.

Timed out trying to establish connection
 
The error occurred in D:/inetpub/wwwroot/queries/grandgetproducts.cfm: line 65
Called from D:/inetpub/wwwroot/Application.cfm: line 283
Called from D:/inetpub/wwwroot/queries/grandgetproducts.cfm: line 65
Called from D:/inetpub/wwwroot/Application.cfm: line 283
63 : 		left join tb_attr1_entries g on (g.attr1_entry_id = b.attr1_entry_id)
64 : WHERE
65 : 	c.store_id = #store#
66 : 	
67 :     and

DATASOURCE   celerantsql
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 , min(c.price) as min_price , case when min(c.team_price) > 0 then min(c.team_price) else min(c.price) end as team_price , max(c.price) as max_price , max(c.first_price) as maxPrice , max(a.date_entered) as date_entered ,max(qoh) as qoh ,c.store_id as store_id , max(a.web_style) as web_style , max(a.web_desc) as web_desc , max(a.description) as description , 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(brand) as brand , MAX(c.sugg_price) AS max_sugg_price , max(date_entered) as date_entered ,max(of1) as of1 ,max(of2) as of2 ,max(of3) as of3 ,max(of4) as of4 ,max(of5) as of5 ,max(of6) as of6 ,max(of7) as of7 ,max(of8) as of8 ,sum(c.qoh) as qoh ,max(c.qs) as qs ,max(g.attr1) as attr1 ,max(g.attr1_alias) as attr1_alias ,max(g.attr1_entry_id) as attr1_entry_id ,max(f.siz) as siz ,max(f.scale_entry_id) as scale_entry_id ,max(f.siz_alias) as siz_alias FROM tb_styles a WITH (NOLOCK) INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_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 tb_size_entries f on (f.scale_entry_id = b.scale_entry_id) left join tb_attr1_entries g on (g.attr1_entry_id = b.attr1_entry_id) WHERE c.store_id = 3 and a.web_product= 'Y' GROUP BY b.sku_id,d.styles_web_taxonomy_id, c.store_id
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.237.249.90
Referrer  
Date/Time   16-Jul-19 02:02 AM
Stack Trace
at cfgrandgetproducts2ecfm1140842322.runPage(D:/inetpub/wwwroot/queries/grandgetproducts.cfm:65) at cfApplication2ecfm1978831585.runPage(D:/inetpub/wwwroot/Application.cfm:283) at cfgrandgetproducts2ecfm1140842322.runPage(D:/inetpub/wwwroot/queries/grandgetproducts.cfm:65) at cfApplication2ecfm1978831585.runPage(D:/inetpub/wwwroot/Application.cfm:283)

java.sql.SQLException: Timed out trying to establish connection
	at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:843)
	at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125)
	at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:137)
	at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:44)
	at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:156)
	at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:110)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:363)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1121)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:808)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfgrandgetproducts2ecfm1140842322.runPage(D:\inetpub\wwwroot\queries\grandgetproducts.cfm:65)
	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 cfApplication2ecfm1978831585.runPage(D:\inetpub\wwwroot\Application.cfm:283)
	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.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:391)
	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.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: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)