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]The connection to the host crabsql-1, named instance sql2017 has failed. Error: "Receive timed out". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.
 
The error occurred in C:/Webroot/Crabweb1a/Metrics/cfc/PreservationData.cfc: line 353
Called from C:/Webroot/Crabweb1a/Metrics/charts/preservation1.cfm: line 2
Called from C:/Webroot/Crabweb1a/Metrics/moreStuff.cfm: line 46
351 :             where [Year] between (select max(year) from v_Preservation_PSC_Summary)-4 and (select max(year) from v_Preservation_PSC_Summary)
352 :                 and countyID=<cfqueryPARAM value = "#arguments.countyID#"
353 :                 CFSQLType = 'CF_SQL_INTEGER'>
354 :             order by [year]
355 :         </cfquery>

SQLSTATE   08001
DATASOURCE   cfCountyTransMetrics
SQL    SELECT[Year] ,[CountyName] ,[CountyID] ,[PavedArterialMiles] ,[ExcellentPavedArterialMiles] ,[GoodPavedArterialMiles] ,[FairPavedArterialMiles] ,[PoorPavedArterialMiles] ,[FailedPavedArterialMiles] ,[UnratedPavedArterialMiles] ,PavedArterialNetworkAverage ,PercentFairBetter FROM v_Preservation_PSC_Summary where [Year] between (select max(year) from v_Preservation_PSC_Summary)-4 and (select max(year) from v_Preservation_PSC_Summary) and countyID= (param 1) order by [year]
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.237.186.116
Referrer  
Date/Time   21-Oct-20 12:47 AM
Stack Trace
at cfPreservationData2ecfc1574611150$funcGETPSCLASTFIVEYEARS.runFunction(C:/Webroot/Crabweb1a/Metrics/cfc/PreservationData.cfc:353) at cfpreservation12ecfm1165700391.runPage(C:/Webroot/Crabweb1a/Metrics/charts/preservation1.cfm:2) at cfmoreStuff2ecfm1867371617.runPage(C:/Webroot/Crabweb1a/Metrics/moreStuff.cfm:46)

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The connection to the host crabsql-1, named instance sql2017 has failed. Error: "Receive timed out".  Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.
	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.ddc.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddc.<init>(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.k(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseDriver.connect(Unknown Source)
	at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:634)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:745)