Email Us

What can We Help You With?

Our experienced team shares a passion to serve our customers. Great Valley staff are ready to assist you with choosing the right products and services for your needs. We carry pool pumps, pool filters, pool heaters, pool cleaners, pool covers and much more. Sorry, we no longer offer tile patching or coping repair.

Pennsylvania's Premier Pool Service Provider

Great Valley has been servicing swimming pools for over 30 years. During those decades we've serviced and maintained thousands of pools. We no longer offer tile patch or coping repair.

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

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.

 
The error occurred in C:/home/greatvalleypool.com/config/triggers.cfm: line 706
Called from C:/home/greatvalleypool.com/config/triggers.cfm: line 667
Called from C:/home/greatvalleypool.com/config/triggers.cfm: line 1
Called from C:/home/greatvalleypool.com/config/footer3.cfm: line 35
Called from C:/home/greatvalleypool.com/index.cfm: line 144
Called from C:/home/greatvalleypool.com/index.cfm: line 140
Called from C:/home/greatvalleypool.com/index.cfm: line 1
704 : 			<cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#" name="getAProfile">
705 : 				insert into ARM_profiles(fname, lname, email, mainPurchase, repFname, repID, campaignID, pipelineID, rb)
706 : 				values(<cfqueryparam value="#FirstName#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#LastName#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#Email#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#getCampaignID.campaignType#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#repFname#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#repID#" cfsqltype="cf_sql_integer">, <cfqueryparam value="#getCampaignID.id#" cfsqltype="cf_sql_integer">, 0, 1)	
707 : 			</cfquery>
708 : 			<cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#" name="getProfileID">

Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   18.204.56.97
Referrer  
Date/Time   24-Sep-22 03:32 PM
Stack Trace
at cftriggers2ecfm1647911798._factor36(C:/home/greatvalleypool.com/config/triggers.cfm:706) at cftriggers2ecfm1647911798._factor40(C:/home/greatvalleypool.com/config/triggers.cfm:667) at cftriggers2ecfm1647911798.runPage(C:/home/greatvalleypool.com/config/triggers.cfm:1) at cffooter32ecfm434664034.runPage(C:/home/greatvalleypool.com/config/footer3.cfm:35) at cfindex2ecfm1616650619._factor6(C:/home/greatvalleypool.com/index.cfm:144) at cfindex2ecfm1616650619._factor9(C:/home/greatvalleypool.com/index.cfm:140) at cfindex2ecfm1616650619.runPage(C:/home/greatvalleypool.com/index.cfm:1)

coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:121)
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:70)
	at coldfusion.sql.Parameter.getMappingValues(Parameter.java:63)
	at coldfusion.sql.InParameter.setStatement(InParameter.java:72)
	at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1552)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cftriggers2ecfm1647911798._factor36(C:\home\greatvalleypool.com\config\triggers.cfm:706)
	at cftriggers2ecfm1647911798._factor40(C:\home\greatvalleypool.com\config\triggers.cfm:667)
	at cftriggers2ecfm1647911798.runPage(C:\home\greatvalleypool.com\config\triggers.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cffooter32ecfm434664034.runPage(C:\home\greatvalleypool.com\config\footer3.cfm:35)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cfindex2ecfm1616650619._factor6(C:\home\greatvalleypool.com\index.cfm:144)
	at cfindex2ecfm1616650619._factor9(C:\home\greatvalleypool.com\index.cfm:140)
	at cfindex2ecfm1616650619.runPage(C:\home\greatvalleypool.com\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	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: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:223)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)