Sunday, December 15, 2019
10:31:04 AM

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]There is already an object named 'vw_points_envelope' in the database.
 
The error occurred in D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 263
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 215
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 177
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 85
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 1
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 263
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 215
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 177
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 85
Called from D:/DrWWW/citydata/NewDesign/snapshot.cfm: line 1
261 : SELECT *
262 : FROM tbl_prcl_points
263 : WHERE ((point_x >= #xmin# AND point_x <= #xmax#) AND (point_y >= #ymin# AND point_y <= #ymax#))
264 : </CFQUERY>
265 : 

VENDORERRORCODE   2714
SQLSTATE   42S01
SQL    CREATE VIEW vw_points_envelope AS SELECT * FROM tbl_prcl_points WHERE ((point_x >= 892892.259193 AND point_x <= 896963.570258) AND (point_y >= 1015250.22382 AND point_y <= 1019517.38594))
DATASOURCE   citydata
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   192.168.232.3
Referrer  
Date/Time   15-Dec-19 10:31 AM
Stack Trace
at cfsnapshot2ecfm2095831325._factor2(D:/DrWWW/citydata/NewDesign/snapshot.cfm:263) at cfsnapshot2ecfm2095831325._factor4(D:/DrWWW/citydata/NewDesign/snapshot.cfm:215) at cfsnapshot2ecfm2095831325._factor6(D:/DrWWW/citydata/NewDesign/snapshot.cfm:177) at cfsnapshot2ecfm2095831325._factor11(D:/DrWWW/citydata/NewDesign/snapshot.cfm:85) at cfsnapshot2ecfm2095831325.runPage(D:/DrWWW/citydata/NewDesign/snapshot.cfm:1) at cfsnapshot2ecfm2095831325._factor2(D:/DrWWW/citydata/NewDesign/snapshot.cfm:263) at cfsnapshot2ecfm2095831325._factor4(D:/DrWWW/citydata/NewDesign/snapshot.cfm:215) at cfsnapshot2ecfm2095831325._factor6(D:/DrWWW/citydata/NewDesign/snapshot.cfm:177) at cfsnapshot2ecfm2095831325._factor11(D:/DrWWW/citydata/NewDesign/snapshot.cfm:85) at cfsnapshot2ecfm2095831325.runPage(D:/DrWWW/citydata/NewDesign/snapshot.cfm:1)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named 'vw_points_envelope' in the database.
	at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.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.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfsnapshot2ecfm2095831325._factor2(D:\DrWWW\citydata\NewDesign\snapshot.cfm:263)
	at cfsnapshot2ecfm2095831325._factor4(D:\DrWWW\citydata\NewDesign\snapshot.cfm:215)
	at cfsnapshot2ecfm2095831325._factor6(D:\DrWWW\citydata\NewDesign\snapshot.cfm:177)
	at cfsnapshot2ecfm2095831325._factor11(D:\DrWWW\citydata\NewDesign\snapshot.cfm:85)
	at cfsnapshot2ecfm2095831325.runPage(D:\DrWWW\citydata\NewDesign\snapshot.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:201)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)