Completed Projects 2010 - Present

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/programs/rap/completed/completedProjectList.cfm: line 46
44 :   <div class="affinity-row">
45 :     <div class="column-content">
46 :     <cfquery name="complete" datasource="cfRead-RAP">
47 : SELECT ProjectID, Region, LegislativeDistrict, CountyName, RoadName, ProjectNumber,Paid, TRC, ActiveContractStatus,EndDate, ProjectType, Paid, EstCost, Authorized
48 : FROM dbo.v_cf_AllProjectList

SQLSTATE   08001
DATASOURCE   cfRead-RAP
SQL    SELECT ProjectID, Region, LegislativeDistrict, CountyName, RoadName, ProjectNumber,Paid, TRC, ActiveContractStatus,EndDate, ProjectType, Paid, EstCost, Authorized FROM dbo.v_cf_AllProjectList WHERE status ='Complete' and endDate between '01-01-2008' and '12-31-2024' ORDER BY EndDate desc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.237.186.116
Referrer  
Date/Time   21-Oct-20 12:06 AM
Stack Trace
at cfcompletedProjectList2ecfm484955295.runPage(C:/Webroot/Crabweb1a/programs/rap/completed/completedProjectList.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)