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]Connection reset by peer: socket write error
 
The error occurred in C:/inetpub/wwwroot/heritagedata/historic/model/qry_propRecord.cfm: line 125
Called from C:/inetpub/wwwroot/heritagedata/historic/parsed/v.dsp_sitesummary.cfm: line 136
Called from C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm: line 433
Called from C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm: line 426
Called from C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm: line 1
Called from C:/inetpub/wwwroot/heritagedata/historic/index.cfm: line 23
Called from C:/inetpub/wwwroot/heritagedata/historic/model/qry_propRecord.cfm: line 125
Called from C:/inetpub/wwwroot/heritagedata/historic/parsed/v.dsp_sitesummary.cfm: line 136
Called from C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm: line 433
Called from C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm: line 426
Called from C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm: line 1
Called from C:/inetpub/wwwroot/heritagedata/historic/index.cfm: line 23
123 : 	FROM Resource INNER JOIN City ON Resource.city_ID = City.city_ID 
124 : 		INNER JOIN County ON Resource.county_ID = County.county_ID
125 : 	WHERE	Resource.resource_ID = <cfqueryparam value="#resultdisplay#" cfsqltype="cf_sql_integer">
126 : 	 AND	Resource.delete_record_flag = 0
127 : </cfquery>

SQLSTATE   08S01
SQL    SELECT Resource.resource_ID, Resource.historicName, Resource.otherNames, Resource.clusterName, Resource.approxAddr_flag, Resource.streetNbr_low, Resource.streetNbr_high, Resource.streetPreDir, Resource.streetName, Resource.streetSuffix, Resource.streetPostDir, Resource.locDescr, Resource.assocAddresses, Resource.city_ID, Resource.vctyFlag, Resource.county_ID, Resource.state, Resource.zip, Resource.addition, Resource.blockNbr, Resource.lotNbr, Resource.taxLotNbr, Resource.mapNbr, Resource.township, Resource.range, Resource.sect, Resource.qtrSection, Resource.architect, Resource.builder, Resource.primCircaFlag, Resource.primConstrYear, Resource.primConstrDesig, Resource.secCircaFlag, Resource.secConstrYear, Resource.secConstrDesig, Resource.resourceType, Resource.height, Resource.acreage, Resource.histFunction1, Resource.histFunction2, Resource.histFunction_descr, Resource.archClass1, Resource.archClass1_other, Resource.archClass2, Resource.archClass2_other, Resource.planType, Resource.primSiding, Resource.secSiding, Resource.siding_descr, Resource.nbrContrRscs, Resource.nbrNContrRscs, Resource.shpoEvaluation, Resource.physicalDescr, Resource.significance, Resource.Rsch_Title, Resource.Rsch_Sanborn, Resource.Rsch_Obituary, Resource.Rsch_CityDirectory, Resource.Rsch_Census, Resource.Rsch_Bios, Resource.Rsch_Newspapers, Resource.Rsch_Permits, Resource.Rsch_Tax, Resource.Rsch_SHPO, Resource.Rsch_StateArchives, Resource.Rsch_StateLibrary, Resource.Rsch_LocalHistories, Resource.Rsch_Interviews, Resource.Rsch_Photos, Resource.Rsch_LocalLibrary, Resource.Rsch_UnivLibrary, Resource.Rsch_HistSociety, Resource.Rsch_Other, Resource.bibliography, Resource.ILS_Date, Resource.RLS_Date, Resource.GenSurv_Date, Resource.notes, Resource.nr_status, Resource.nrNbr, Resource.dateListed, (Case When Resource.streetNbr_high is Null Then isNull(Cast(Resource.streetNbr_low as varchar(max)),'') + ' ' + Case When Resource.streetPredir is Null Then (isNull(Cast(Resource.streetName as varchar(max)),'') + ' ' + isNull(Cast(Resource.streetSuffix as varchar(max)),'') + ' ' + isNull(Cast(Resource.streetPostDir as varchar(max)),'')) Else (Cast(Resource.streetPreDir as varchar(max)) + ' ' + isNull(Cast(Resource.streetName as varchar(max)),'') + ' ' + isNull(Cast(Resource.streetSuffix as varchar(max)),'')) End Else Case When Resource.streetPredir is Null Then (isNull(Cast(Resource.streetNbr_low as varchar(max)),'') + '-' + Cast(Resource.streetNbr_high as varchar(max))+ ' ' + isNull(Cast(Resource.streetName as varchar(max)),'') + ' ' + isNull(Cast(Resource.streetSuffix as varchar(max)),'') + ' ' + isNull(Cast(Resource.streetPostDir as varchar(max)),'')) Else (isNull(Cast(Resource.streetNbr_low as varchar(max)),'') + '-' + isNull(Cast(Resource.streetNbr_high as varchar(max)),'')+ ' ' + (Cast(Resource.streetPreDir as varchar(max))) + ' ' + isNull(Cast(Resource.streetName as varchar(max)),'') + ' ' + isNull(Cast(Resource.streetSuffix as varchar(max)),'')) End End) as address, (Case When Resource.vctyFlag = 1 Then (City.cityName + ' vcty, ' + County.county_Name + ' County') Else (City.cityName + ', ' + County.county_Name + ' County') End) as cityCo FROM Resource INNER JOIN City ON Resource.city_ID = City.city_ID INNER JOIN County ON Resource.county_ID = County.county_ID WHERE Resource.resource_ID = (param 1) AND Resource.delete_record_flag = 0
DATASOURCE   Historic_web
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.166.105.24
Referrer  
Date/Time   20-Oct-14 02:39 AM
Stack Trace
at cfqry_propRecord2ecfm676122238.runPage(C:/inetpub/wwwroot/heritagedata/historic/model/qry_propRecord.cfm:125) at cfv2edsp_sitesummary2ecfm1916729006.runPage(C:/inetpub/wwwroot/heritagedata/historic/parsed/v.dsp_sitesummary.cfm:136) at cffusebox42eruntime2ecfmx2ecfm795991412._factor15(C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm:433) at cffusebox42eruntime2ecfmx2ecfm795991412._factor17(C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm:426) at cffusebox42eruntime2ecfmx2ecfm795991412.runPage(C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm:1) at cfindex2ecfm814588743.runPage(C:/inetpub/wwwroot/heritagedata/historic/index.cfm:23) at cfqry_propRecord2ecfm676122238.runPage(C:/inetpub/wwwroot/heritagedata/historic/model/qry_propRecord.cfm:125) at cfv2edsp_sitesummary2ecfm1916729006.runPage(C:/inetpub/wwwroot/heritagedata/historic/parsed/v.dsp_sitesummary.cfm:136) at cffusebox42eruntime2ecfmx2ecfm795991412._factor15(C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm:433) at cffusebox42eruntime2ecfmx2ecfm795991412._factor17(C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm:426) at cffusebox42eruntime2ecfmx2ecfm795991412.runPage(C:/inetpub/wwwroot/heritagedata/historic/fb41core/fusebox4.runtime.cfmx.cfm:1) at cfindex2ecfm814588743.runPage(C:/inetpub/wwwroot/heritagedata/historic/index.cfm:23)

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
	at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddo.e(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddn.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.h(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddf.execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddj.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1458)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfqry_propRecord2ecfm676122238.runPage(C:\inetpub\wwwroot\heritagedata\historic\model\qry_propRecord.cfm:125)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cfv2edsp_sitesummary2ecfm1916729006.runPage(C:\inetpub\wwwroot\heritagedata\historic\parsed\v.dsp_sitesummary.cfm:136)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cffusebox42eruntime2ecfmx2ecfm795991412._factor15(C:\inetpub\wwwroot\heritagedata\historic\fb41core\fusebox4.runtime.cfmx.cfm:433)
	at cffusebox42eruntime2ecfmx2ecfm795991412._factor17(C:\inetpub\wwwroot\heritagedata\historic\fb41core\fusebox4.runtime.cfmx.cfm:426)
	at cffusebox42eruntime2ecfmx2ecfm795991412.runPage(C:\inetpub\wwwroot\heritagedata\historic\fb41core\fusebox4.runtime.cfmx.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cfindex2ecfm814588743.runPage(C:\inetpub\wwwroot\heritagedata\historic\index.cfm:23)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:449)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	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:58)
	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:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	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:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)