JOIN OUR VIP INSIDERS CLUB
Welcome to the Insiders Club!
Here are just a few of the benefits of joining our mailing list:

  • Receive new product notifications
  • Be notified of upcoming product promotions and sales
  • Receive our newsletter
  • Obtain coupons
  • Receive our digital product flyers
  • Enter for contests
  • Access a vast  knowledge base
  • Get event invitations

Add us to your Email White-list please!

Some clients have reported that we have not responded to them or that they have not been receiving our emails, only to find it in a Junk/Spam Folder afterwards.  Please add @xxx @elitepoolgroup.com to your safe senders list to ensure you receive all of our communication in your inbox. It only takes 30 seconds!


NOT SURE HOW? No Problem!

Are you Gmail User? 
Watch this video  

Are you a Yahoo Mail User? 
Watch this video  

Are you a Outlook.com / Hotmail User? 
Watch this video  

Do you use Outlook Desktop Email? 
Watch this video  

* = Required
Name *
Email *
Mobile


Enter above value to submit form used to stop form spam

I approve Blue Haven to send me correspondence through email regarding their promotions, products & services


 



More online client services than any other Pool/Spa Dealer

Discover Now
x

Join our VIP Insider Program

As a member of our VIP insider program you will receive monthly savings coupons, vouchers and exclusive insider promotions.
We'll also keep you up to date on exclusive rebate offers!

No thanks, I'm not interested in saving money on my chemicals and select accessories.

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]Cannot create a row of size 8062 which is greater than the allowable maximum row size of 8060.
 
The error occurred in C:/home/bluehaven.ca/config/triggers.cfm: line 914
Called from C:/home/bluehaven.ca/config/footer2.cfm: line 144
Called from C:/home/bluehaven.ca/forms/index.cfm: line 254
Called from C:/home/bluehaven.ca/config/triggers.cfm: line 914
Called from C:/home/bluehaven.ca/config/footer2.cfm: line 144
Called from C:/home/bluehaven.ca/forms/index.cfm: line 254
 
912 : 	update EM_SR_Bookings
913 : 	set ccn = 'xxxx xxxx xxxx xxxx'
914 : 	where (DATEDIFF(day, bookingdate, <CFQUERYPARAM Value="#CreateODBCDateTime(now())#" cfsqltype="CF_SQL_TIMESTAMP">) > 5)
915 : </cfquery>
916 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#">
SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   bluehavenca09
VENDORERRORCODE   511
SQL   update EM_SR_Bookings set ccn = 'xxxx xxxx xxxx xxxx' where (DATEDIFF(day, bookingdate, (param 1) ) > 5)
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.145.131.238
Referrer  
Date/Time   07-May-24 03:50 AM
Stack Trace
at cftriggers2ecfm1439799004.runPage(C:/home/bluehaven.ca/config/triggers.cfm:914) at cffooter22ecfm1127191027.runPage(C:/home/bluehaven.ca/config/footer2.cfm:144) at cfindex2ecfm373829260.runPage(C:/home/bluehaven.ca/forms/index.cfm:254) at cftriggers2ecfm1439799004.runPage(C:/home/bluehaven.ca/config/triggers.cfm:914) at cffooter22ecfm1127191027.runPage(C:/home/bluehaven.ca/config/footer2.cfm:144) at cfindex2ecfm373829260.runPage(C:/home/bluehaven.ca/forms/index.cfm:254) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot create a row of size 8062 which is greater than the allowable maximum row size of 8060.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
	at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
	at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
	at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
	at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892)
	at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
	at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
	at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
	at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1639)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1365)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1295)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cftriggers2ecfm1439799004.runPage(C:\home\bluehaven.ca\config\triggers.cfm:914)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cffooter22ecfm1127191027.runPage(C:\home\bluehaven.ca\config\footer2.cfm:144)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfindex2ecfm373829260.runPage(C:\home\bluehaven.ca\forms\index.cfm:254)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	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:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)