500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

AARC Summer Forum, July 13–15 | AARC Summer Meetings 2012

AARC Summer Forum

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]Error establishing socket. Unknown host: sqlserver.aarc.org
 
The error occurred in C:\inetpub\wwwroot\AARCCLASSIC\education\meetings\summer_forum\summer_forum.cfm: line 116
114 : 					<h1 class="top">Friday, July 13, 2012</h1> --->
115 : 					<cfset ID = "" >
116 : 					<cfquery name="fillmeeting" datasource="mtgs">
117 : 	SELECT     MTG_Event.Event_Type
118 : 		, MTG_Event.ID_Event AS ID_Event

SQLSTATE   08001
SQL    SELECT MTG_Event.Event_Type , MTG_Event.ID_Event AS ID_Event , MTG_Interest.Interest , MTG_Interest.ID_Interest , MTG_Symposia.ID_Symposia , CONVERT(VARCHAR(24),MTG_Symposia.Sym_Date, 109) as Sym_Date , MTG_Symposia.Session_Title , (SUBSTRING(CONVERT(VARCHAR(8),MTG_Symposia.Start_Time,100), 1, (LEN(CONVERT(VARCHAR(8),MTG_Symposia.Start_Time,100))-2))) + (' ' + LOWER(RIGHT(CONVERT(VARCHAR(8),MTG_Symposia.Start_Time,100),2))) as Start_Time , CONVERT(varchar(5),MTG_Symposia.End_Time) AS 'Day' , CASE WHEN DATEPART(hour,MTG_Symposia.End_Time) = 12 THEN '12:00 noon' END AS TranHour1 , (SUBSTRING(CONVERT(VARCHAR(8),MTG_Symposia.End_Time,100), 1, (LEN(CONVERT(VARCHAR(8),MTG_Symposia.End_Time,100))-2))) + (' ' + LOWER(RIGHT(CONVERT(VARCHAR(8),MTG_Symposia.End_Time,100),2))) as End_Time , MTG_Symposia.Start_Time AS AStart_Time , MTG_Symposia.End_Time AS AEnd_Time , MTG_Symposia.Title , MTG_Symposia.Description AS descriptionSym , MTG_Symposia.Control_ID , MTG_Symposia.Image_Name , MTG_Symposia.Is_Table , MTG_Person.ID_Role , MTG_Person.Name , MTG_Person.Credentials AS personcredentials , MTG_Person.Presiding AS personpresiding , MTG_Person.Email , MTG_Presentation.Session_Title as red_title , MTG_Presentation.PresentedBy as presentedby , MTG_Presenter.Name_Institution , MTG_Presenter.Fname , MTG_Presenter.Mname , MTG_Presenter.Lname , MTG_Presenter.Credentials AS credentials , MTG_Presenter.Address_1 , MTG_Presenter.Address_2 , MTG_Presenter.City AS City , MTG_Presenter.State , MTG_Presenter.Zip , MTG_Presenter.Country , MTG_Presenter.Logo_Filename as logo , MTG_Presenter.Photo_Filename , MTG_Presenter.Logo_Caption as logocaption , MTG_Presenter.Photo_Caption , MTG_Presenter.photonum as lphoto , (LEFT(MTG_Presenter.Photo_Filename, 6)) as lphoto , MTG_Presenter.Presiding AS presiding , MTG_Presenter.Prefered_Afiliation , MTG_Presenter.URL AS URL , MTG_Presenter.photonum AS photonum , MTG_Presenter.ConflictOfInterest , MTG_Presentation.ID_Presentation , MTG_Presentation.Date , MTG_Presentation.Title AS pTitle , (SUBSTRING(CONVERT(VARCHAR(8),MTG_Presentation.Start_Time,100), 1, (LEN(CONVERT(VARCHAR(8),MTG_Presentation.Start_Time,100))-2))) + (' ' + LOWER(RIGHT(CONVERT(VARCHAR(8),MTG_Presentation.Start_Time,100),2))) as pstart_time , CONVERT(varchar(5),MTG_Presentation.End_Time) AS 'Day2' , CASE WHEN DATEPART(hour,MTG_Presentation.End_Time) = 12 THEN '12:00 noon' END AS TranHour2 , (SUBSTRING(CONVERT(VARCHAR(8),MTG_Presentation.End_Time,100), 1, (LEN(CONVERT(VARCHAR(8),MTG_Presentation.End_Time,100))-2))) + (' ' + LOWER(RIGHT(CONVERT(VARCHAR(8),MTG_Presentation.End_Time,100),2))) as pend_time , DATEPART(HH,MTG_Presentation.Start_Time) as BStart_Time , MTG_Presentation.End_Time as BEnd_Time , MTG_Presentation.Description AS pdescription , MTG_Presentation.CRCE AS pcrce , MTG_Presentation.CRCE_Hours AS pcrce_hours , MTG_Presentation.ID_Person , MTG_Presentation.ID_Presenter , MTG_Presentation.ID_Event AS PID_Event , MTG_Presentation.ID_Symposia , MTG_Presentation.CRCE_Number AS pcrce_num , MTG_Presentation.Location AS plocation , MTG_Presentation.Description as pdescription , MTG_Presentation.Date AS pDate FROM MTG_Event INNER JOIN MTG_Interseccion ON MTG_Event.ID_Event = MTG_Interseccion.ID_Event INNER JOIN MTG_Interest ON MTG_Interseccion.ID_Interest = MTG_Interest.ID_Interest INNER JOIN MTG_Symposia ON MTG_Interseccion.ID_Symposia = MTG_Symposia.ID_Symposia INNER JOIN MTG_Presentation ON MTG_Interseccion.ID_Presentation = MTG_Presentation.ID_Presentation INNER JOIN MTG_Presenter ON MTG_Interseccion.ID_Presenter = MTG_Presenter.ID_Presenter AND MTG_Presentation.ID_Presenter = MTG_Presenter.ID_Presenter INNER JOIN MTG_Person ON MTG_Presentation.ID_Person = MTG_Person.ID_Person INNER JOIN MTG_Role ON MTG_Person.ID_Role = MTG_Role.ID_Role INNER JOIN MTG_Afiliation ON MTG_Person.ID_Afiliation = MTG_Afiliation.ID_Afiliation WHERE MTG_Symposia.Sym_Date >= '07/13/2012' AND MTG_Symposia.Sym_Date <= '07/15/2012' AND MTG_Event.Event_Type = 'Summer Forum' Order by MTG_Symposia.Sym_Date, MTG_Symposia.ID_Symposia asc
DATASOURCE   mtgs
Resources:

Browser   claudebot
Remote Address   172.70.174.252
Referrer  
Date/Time   29-Mar-24 08:04 AM
Stack Trace
at cfsummer_forum2ecfm1048901711._factor5(C:\inetpub\wwwroot\AARCCLASSIC\education\meetings\summer_forum\summer_forum.cfm:116) at cfsummer_forum2ecfm1048901711.runPage(C:\inetpub\wwwroot\AARCCLASSIC\education\meetings\summer_forum\summer_forum.cfm:1)

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: sqlserver.aarc.org
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.doConnect(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.connect(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.setupImplConnection(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.open(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:593)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:619)