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][SQLServer]Cannot open database "HL7PageLoads" requested by the login. The login failed.

20 : 	**********************--->
21 : 	<!--- Query the database to see if the current IP address is on the block list --->
22 : 	<cfquery name="qDenialOfService" datasource="HL7PageLoads" cachedwithin="#CreateTimeSpan(0,0,3,0)#">
23 : 		SELECT RTRIM(remote_addr) AS remote_addr
24 : 		FROM denialOfService

SQLSTATE	08001
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	HL7PageLoads
VENDORERRORCODE	4060
SQL	SELECT RTRIM(remote_addr) AS remote_addr FROM denialOfService WHERE block = 1

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	216.73.216.110
Referrer
Date/Time	17-Oct-26 04:08 AM

Stack Trace

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "HL7PageLoads" requested by the login. The login failed.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1045)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.j.a(|SQLServer|6.0.0.1282|:1082)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.tds.j.b(|SQLServer|6.0.0.1282|:296)
	at macromedia.jdbc.sqlserver.SQLServerImplConnection.open(|SQLServer|6.0.0.1282|:1505)
	at macromedia.jdbc.sqlserver.base.BaseConnection.c(|SQLServer|6.0.0.1282|:5090)
	at macromedia.jdbc.sqlserver.base.BaseConnection.dB(|SQLServer|6.0.0.1282|:1566)
	at macromedia.jdbc.sqlserver.base.BaseConnection.f(|SQLServer|6.0.0.1282|:1488)
	at macromedia.jdbc.sqlserver.base.BaseConnection.a(|SQLServer|6.0.0.1282|:1016)
	at macromedia.jdbc.sqlserver.base.BaseDriver.connect(|SQLServer|6.0.0.1282|:331)
	at macromedia.jdbc.MacromediaDriver.connect(MacromediaDriver.java:256)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:666)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.base/java.lang.Thread.run(Thread.java:834)

Debugging Information

ColdFusion Server Developer	2021,0,22,330451
Template	/implement/certificationdirectory.cfm
Time Stamp	17-Oct-26 04:08 AM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	216.73.216.110
Host Name	216.73.216.110

Execution Time

Total Time	Avg Time	Count	Template
7482 ms	7482 ms	1	C:/inetpub/wwwroot/hl7/Application.cfm
7481 ms	7481 ms	1	C:/inetpub/wwwroot/hl7/Tools/checkHackingAttempt.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/hl7/env.cfm
15 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
7497 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

04:08:12.012 - Database Exception - in C:/inetpub/wwwroot/hl7/Tools/checkHackingAttempt.cfm : line 22

	    Error Executing Database Query.

04:08:12.012 - Expression Exception - in /WEB-INF/exception/detail.cfm : line 226

	    Complex object types cannot be converted to simple values.

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=3072
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=YR2
CERT_SERVER_SUBJECT=CN=dev3.hl7.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\hl7\implement\certificationdirectory.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=3072
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=YR2
HTTPS_SERVER_SUBJECT=CN=dev3.hl7.org
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=dev3.hl7.org
HTTP_REFERER=
HTTP_URL=/implement/certificationdirectory.cfm?offset=4441&sortBy=country_description&sortDirection=desc
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.63.80
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\hl7\implement\certificationdirectory.cfm
QUERY_STRING=offset=4441&sortBy=country_description&sortDirection=desc
REMOTE_ADDR=216.73.216.110
REMOTE_HOST=216.73.216.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/implement/certificationdirectory.cfm
SERVER_NAME=dev3.hl7.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Request Parameters:
environment=fullsandbox
isdevelopment=true
passedhackingcheck=False
samesite_value=
samlresponse=SalesForce_Dev3

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

URL Parameters:
offset=4441
sortBy=country_description
sortDirection=desc

Debug Rendering Time: 4 ms