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/SafetyData.cfc: line 93
Called from C:/Webroot/Crabweb1a/Metrics/charts/safety4.cfm: line 1
Called from C:/Webroot/Crabweb1a/Metrics/moreStuff.cfm: line 46
91 :                 FROM v_Safety_Fatal_SeriousInjury_Summary
92 :             WHERE [Year] between (select max(year) from v_Safety_Fatal_SeriousInjury_Summary)-4 and (select max(year) from v_Safety_Fatal_SeriousInjury_Summary)
93 :             	and countyID = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.countyID#">
94 :             order by [Year]        
95 :         </cfquery>

SQLSTATE   08001
DATASOURCE   cfCountyTransMetrics
SQL    SELECT [Year], [CountyID] ,[CountyName] ,[NbrFatalCollisions] ,[NbrFatalities] ,[NbrSeriousInjuryCollisions] ,[NbrSeriousInjuries] ,[APMVMAll] ,[APMVMFatalSerious] FROM v_Safety_Fatal_SeriousInjury_Summary WHERE [Year] between (select max(year) from v_Safety_Fatal_SeriousInjury_Summary)-4 and (select max(year) from v_Safety_Fatal_SeriousInjury_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:30 AM
Stack Trace
at cfSafetyData2ecfc120456824$funcSUMMARY_GETFATALITIESANDSERIOUSLASTFIVEYEARS.runFunction(C:/Webroot/Crabweb1a/Metrics/cfc/SafetyData.cfc:93) at cfsafety42ecfm1189294802.runPage(C:/Webroot/Crabweb1a/Metrics/charts/safety4.cfm:1) 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)