500 - Internal server error.

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

Tuesday, July 16 | AARC Summer Forum 2013

American Association for Respiratory Care

AARC Summer Forum

View:

All TracksManager TrackEducator Track

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_13\tuesday.cfm: line 95
93 : 
94 : 
95 :              <cfquery name="fillmeeting" datasource="mtgs">
96 :                 SELECT   MTG_Event.Event_Type
97 :                             , 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.Code , 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.photonum as lphoto , SUBSTRING(MTG_Presenter.Photo_Filename, 7, (LEN(MTG_Presenter.Photo_Filename) )) as rphoto , MTG_Presenter.Logo_Caption as logocaption , MTG_Presenter.Photo_Caption , MTG_Presenter.Presiding AS presiding , MTG_Presenter.Prefered_Afiliation , MTG_Presenter.URL AS URL , MTG_Presenter.photonum AS photonum , MTG_Presenter.ConflictOfInterest , MTG_Presenter.BIO , 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 as 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 , MTG_Presentation.print_sessiontitle AS print_sessiontitle 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/16/2013' AND MTG_Symposia.Sym_Date <= '07/16/2013' Order by MTG_Symposia.ID_Symposia,MTG_Symposia.Sym_Date,MTG_Symposia.Start_Time,MTG_Presentation.Start_Time
DATASOURCE   mtgs
Resources:

Browser   claudebot
Remote Address   172.70.35.62
Referrer  
Date/Time   28-Mar-24 09:37 PM
Stack Trace
at cftuesday2ecfm410193010._factor10(C:\inetpub\wwwroot\AARCCLASSIC\education\meetings\summer_forum_13\tuesday.cfm:95) at cftuesday2ecfm410193010.runPage(C:\inetpub\wwwroot\AARCCLASSIC\education\meetings\summer_forum_13\tuesday.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)