MY ACCOUNT PAY INVOICE

Website Site Map
Home
Home Page
    Benefits of Shopping Online at our e-store

Products
    Browse Products by Type

Pool Equipment
    Hayward Pool Equipment
    Browse Products by Brand
    Raypak Pool Heaters
    Pentair Pool Equipment
    Clear Blue Ionizer System
    DetaUV Sanitation Systems
    Titan Heat Pumps

Pool Supplies & Accessories
    IPG Water Treatment
    HPI Pool & Spa Covers
    Feherguard Solar Cover Rollers
    Swimline Inflatables & Loungers
    Game Pool Accessories
    GLI Winter & Leaf Covers
    Midwest Canvas Solar Covers
    WaterTech Vacuums
    AquaChek Water Testing
    Olympic Pool Maintenance

Pools
    Select your Dream Pool
    Above Ground Pools
        - Above Ground Pools by Trendium
        - Above Ground Pool Sales Inquiries
    Pool Financing Services
    Is it a Great Pool Day?
    Pool Party Invite System

Hot Tubs
    Hot Tubs and Spas
    Sunrise Spas
    Order Custom Hot Tub Cover
    Hot Tub & Spa Inquiries
    Hot Tub Financing Services

Service
    Need Service? How can we help?
    Pool Service
    Pool Maintenance Packages
    Pool Renovations
    Hot Tub Service
    Request Pool Renovations Form

Promotions
    Above Ground Salt Pool Sale
    Hot Tub Sale
    Coupons
    Rebates
    Big Year End Draw
    Google Review

Resources
    Company History
    Pay your invoice online
    Diplomat Splash Blog
    Our Newsletter
    Careers
    Customer Testimonials
    Careers
    Return Policy
    Member of LeisureScapes
    Member of the Elite Pool Group
    Online Client Services
    Privacy Policy
    Website Terms of Use

Contact
    Locations & Hours
    Customer Concerns
    Ask the Experts
    Client Satisfaction Survey
    Join our Mailing List

My Account Portal
    My Account Portal

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]String or binary data would be truncated.
 
The error occurred in C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 46
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 15
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 1
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 450
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 1
Called from C:/web/diplomatpools.com/config/footer2.cfm: line 20
Called from C:/web/diplomatpools.com/sitemap.cfm: line 1125
Called from |SQLServer|6.0.0.1282|: line 1055
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2032
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from |SQLServer|6.0.0.1282|: line 1055
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2032
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 46
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 15
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 1
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 450
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 1
Called from C:/web/diplomatpools.com/config/footer2.cfm: line 20
Called from C:/web/diplomatpools.com/sitemap.cfm: line 1125
 
44 : 					<cfif getmoreInfo.postal IS NOT "">,postal = '#getAllUnassignedLeads.postal#'</cfif> 
45 : 					<cfif getmoreInfo.province IS NOT "">,province = '#getAllUnassignedLeads.province#'</cfif>
46 : 				where email = '#getAllUnassignedLeads.email#'
47 : 			</cfquery>
48 : 		</cfif>
SQLSTATE   22001
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   diplomat
VENDORERRORCODE   8152
SQL   update LG_Contacts set email = 'mmjefery@gmail.com' ,name = 'BEST RECOVERY EXPERT FOR LOST CRYPTOCURRENCY ASSETS; HIRE CYBER CONSTABLE INTELLIGENCE' where email = 'mmjefery@gmail.com'
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   216.73.216.50
Referrer  
Date/Time   30-Jun-25 05:36 PM
Stack Trace
at cfsq_autoAssign2ecfm222736250._factor11(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:46) at cfsq_autoAssign2ecfm222736250._factor14(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:15) at cfsq_autoAssign2ecfm222736250.runPage(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:1) at cftriggers2ecfm806448206._factor42(C:/web/diplomatpools.com/config/triggers.cfm:450) at cftriggers2ecfm806448206.runPage(C:/web/diplomatpools.com/config/triggers.cfm:1) at cffooter22ecfm47597563.runPage(C:/web/diplomatpools.com/config/footer2.cfm:20) at cfsitemap2ecfm1755939153.runPage(C:/web/diplomatpools.com/sitemap.cfm:1125) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at cfsq_autoAssign2ecfm222736250._factor11(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:46) at cfsq_autoAssign2ecfm222736250._factor14(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:15) at cfsq_autoAssign2ecfm222736250.runPage(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:1) at cftriggers2ecfm806448206._factor42(C:/web/diplomatpools.com/config/triggers.cfm:450) at cftriggers2ecfm806448206.runPage(C:/web/diplomatpools.com/config/triggers.cfm:1) at cffooter22ecfm47597563.runPage(C:/web/diplomatpools.com/config/footer2.cfm:20) at cfsitemap2ecfm1755939153.runPage(C:/web/diplomatpools.com/sitemap.cfm:1125) 

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032)
	at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
	at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
	at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
	at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
	at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1649)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1391)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1321)
	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 cfsq_autoAssign2ecfm222736250._factor11(C:\web\diplomatpools.com\crm\gateway\sq_autoAssign.cfm:46)
	at cfsq_autoAssign2ecfm222736250._factor14(C:\web\diplomatpools.com\crm\gateway\sq_autoAssign.cfm:15)
	at cfsq_autoAssign2ecfm222736250.runPage(C:\web\diplomatpools.com\crm\gateway\sq_autoAssign.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:5083)
	at cftriggers2ecfm806448206._factor42(C:\web\diplomatpools.com\config\triggers.cfm:450)
	at cftriggers2ecfm806448206.runPage(C:\web\diplomatpools.com\config\triggers.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:5083)
	at cffooter22ecfm47597563.runPage(C:\web\diplomatpools.com\config\footer2.cfm:20)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:5083)
	at cfsitemap2ecfm1755939153.runPage(C:\web\diplomatpools.com\sitemap.cfm:1125)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	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:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	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:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	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:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:833)