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]Invalid object name 'TMP_CLIENT_REFERRAL_M'.
 
The error occurred in E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm: line 54
Called from E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm: line 1
Called from E:/dynamicworks/clients/_common/ma/45/ma/include/web/_header.cfm: line 14
Called from E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm: line 1
Called from E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm: line 1
Called from E:/dynamicworks/clients/gbema/www/easyconsole.cfm: line 60
Called from E:/dynamicworks/clients/gbema/www/application.cfc: line 167
Called from E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm: line 54
Called from E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm: line 1
Called from E:/dynamicworks/clients/_common/ma/45/ma/include/web/_header.cfm: line 14
Called from E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm: line 1
Called from E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm: line 1
Called from E:/dynamicworks/clients/gbema/www/easyconsole.cfm: line 60
Called from E:/dynamicworks/clients/gbema/www/application.cfc: line 167
52 : 				    SELECT c_id
53 : 				    FROM TMP_CLIENT_REFERRAL_M
54 : 				    WHERE link_id = '#url.linkid#'
55 : 				), '')
56 : 				)

SQLSTATE   42S02
DATASOURCE   gbecrm
VENDORERRORCODE   208
SQL    SELECT customer_no, referral_id FROM easy_nl_contact WHERE c_id IN (isNull( ( SELECT c_id FROM TMP_CLIENT_REFERRAL_M WHERE link_id = 'live1539' ), '') )
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   172.69.63.51
Referrer  
Date/Time   22-Mar-19 09:09 PM
Stack Trace
at cf_init_referrals2ecfm401245176._factor0(E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm:54) at cf_init_referrals2ecfm401245176.runPage(E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm:1) at cf_header2ecfm1069362561.runPage(E:/dynamicworks/clients/_common/ma/45/ma/include/web/_header.cfm:14) at cf_signup_22ecfm1668132776._factor24(E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm:1) at cf_signup_22ecfm1668132776.runPage(E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm:1) at cfeasyconsole2ecfm1356323065.runPage(E:/dynamicworks/clients/gbema/www/easyconsole.cfm:60) at cfapplication2ecfc1472137335$funcONREQUEST.runFunction(E:/dynamicworks/clients/gbema/www/application.cfc:167) at cf_init_referrals2ecfm401245176._factor0(E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm:54) at cf_init_referrals2ecfm401245176.runPage(E:/dynamicworks/clients/_common/ma/45/ma/include/web/_init_referrals.cfm:1) at cf_header2ecfm1069362561.runPage(E:/dynamicworks/clients/_common/ma/45/ma/include/web/_header.cfm:14) at cf_signup_22ecfm1668132776._factor24(E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm:1) at cf_signup_22ecfm1668132776.runPage(E:/dynamicworks/clients/_common/ma/45/ma/templates/_signup_2.cfm:1) at cfeasyconsole2ecfm1356323065.runPage(E:/dynamicworks/clients/gbema/www/easyconsole.cfm:60) at cfapplication2ecfc1472137335$funcONREQUEST.runFunction(E:/dynamicworks/clients/gbema/www/application.cfc:167)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TMP_CLIENT_REFERRAL_M'.
	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.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(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:1531)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1281)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1211)
	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 cf_init_referrals2ecfm401245176._factor0(E:\dynamicworks\clients\_common\ma\45\ma\include\web\_init_referrals.cfm:54)
	at cf_init_referrals2ecfm401245176.runPage(E:\dynamicworks\clients\_common\ma\45\ma\include\web\_init_referrals.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)
	at cf_header2ecfm1069362561.runPage(E:\dynamicworks\clients\_common\ma\45\ma\include\web\_header.cfm:14)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)
	at cf_signup_22ecfm1668132776._factor24(E:\dynamicworks\clients\_common\ma\45\ma\templates\_signup_2.cfm:1)
	at cf_signup_22ecfm1668132776.runPage(E:\dynamicworks\clients\_common\ma\45\ma\templates\_signup_2.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)
	at cfeasyconsole2ecfm1356323065.runPage(E:\dynamicworks\clients\gbema\www\easyconsole.cfm:60)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)
	at cfapplication2ecfc1472137335$funcONREQUEST.runFunction(E:\dynamicworks\clients\gbema\www\application.cfc:167)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
	at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
	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.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: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:219)
	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:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)