The page cannot be displayed because an internal server error has occurred.

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]The app domain with specified version id (278680) was unloaded due to memory pressure and could not be found.
 
The error occurred in C:/www/LocalNursingHomes/v4/cfc/dao/nursingHome.cfc: line 306
Called from C:/www/LocalNursingHomes/v4/cfc/nursingHome.cfc: line 41
Called from C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc: line 230
Called from C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc: line 25
Called from C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc: line 24
Called from c:/www/LocalNursingHomes/v4/www/nursinghomes.cfm: line 33
Called from C:/www/LocalNursingHomes/v4/cfc/dao/nursingHome.cfc: line 306
Called from C:/www/LocalNursingHomes/v4/cfc/nursingHome.cfc: line 41
Called from C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc: line 230
Called from C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc: line 25
Called from C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc: line 24
Called from c:/www/LocalNursingHomes/v4/www/nursinghomes.cfm: line 33
304 : 				<cfif arguments.listingOptions.getMedicaid() EQ "1">
305 : 					AND categoryDescription IN ('Medicaid','Medicare and Medicaid')
306 : 				<cfelseif arguments.listingOptions.getMedicaid() EQ "0">
307 : 					AND categoryDescription NOT IN ('Medicaid','Medicare and Medicaid')
308 : 				</cfif>

SQLSTATE   HY000
DATASOURCE   LNH201308
VENDORERRORCODE   10316
SQL    DECLARE @maxResults Int = (param 1) DECLARE @radius SmallInt = (param 2) DECLARE @page SmallInt = (param 3) DECLARE @perPage SmallInt = (param 4) DECLARE @startRow INT = ((@page - 1) * @perPage) + 1 DECLARE @endRow INT = @startRow + @perPage - 1 DECLARE @metersPerMile Decimal(7,3) = 1609.344; DECLARE @radiusMeters Decimal(12,3) = (@radius + 1) * @metersPerMile; DECLARE @baseZips TABLE ( zipCode CHAR(5) NOT NULL, geo GEOGRAPHY NOT NULL ) INSERT INTO @baseZips SELECT z.ZipCode, z.Geo FROM [ZipCodes]..[ZipCodes] z WITH(NOLOCK) WHERE 1=1 AND z.StateName = (param 5) DECLARE @nearZips TABLE ( zipCode CHAR(5) NOT NULL ) INSERT INTO @nearZips SELECT bz.ZipCode FROM @baseZips bz UNION ALL SELECT DISTINCT nz.ZipCode FROM [ZipCodes]..[ZipCodes] nz WITH(NOLOCK) CROSS JOIN @baseZips bz WHERE @radius > 0 AND nz.Geo.STDistance(bz.Geo) < @radiusMeters SELECT * FROM ( SELECT rowNum = Row_Number()OVER(ORDER BY name ASC, nh.provNum ASC) , numResults = COUNT(*) OVER() , nh.* , ra.* , distance = null FROM vNursingHomes nh WITH(NOLOCK) LEFT JOIN ( SELECT uid , userRating = cast(isNull(ratingAvg, 0) AS decimal(2,1)) , userRatingCount = ISNULL(ratingCount, 0) , userRatingNewest = ISNULL(ratingNewest, '1900-01-01') , hasUserRating = cast(isNull(ratingAvg,0) AS bit) , userReview = cast(isNull(reviewAvg, 0) AS decimal(2,1)) , userReviewCount = ISNULL(reviewcount, 0) , userReviewNewest = ISNULL(reviewNewest, '1900-01-01') , hasUserReview = cast(isNull(reviewAvg,0) AS bit) FROM [Logging]..[VIEW_RatingsAggregate] WITH(NOLOCK) WHERE siteId = 1 ) ra ON ra.uid = nh.ProvNum WHERE EXISTS (SELECT NULL FROM @nearZips nz WHERE nh.zipCode = nz.zipCode) )x WHERE RowNum BETWEEN @startRow AND @endRow ORDER BY RowNum
Resources:

Browser   claudebot
Remote Address   172.70.42.96
Referrer  
Date/Time   19-Mar-24 01:35 AM
Stack Trace
at cfnursingHome2ecfc996129222$funcGETSTATICBYLISTINGOPTIONS.runFunction(C:/www/LocalNursingHomes/v4/cfc/dao/nursingHome.cfc:306) at cfnursingHome2ecfc1990211868$funcGETSTATICBYLISTINGOPTIONS.runFunction(C:/www/LocalNursingHomes/v4/cfc/nursingHome.cfc:41) at cfhomesByRadius2ecfc1565215586$funcSETFACILITIES.runFunction(C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc:230) at cfhomesByRadius2ecfc1565215586$funcINIT._factor0(C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc:25) at cfhomesByRadius2ecfc1565215586$funcINIT.runFunction(C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc:24) at cfnursinghomes2ecfm1065966710.runPage(c:/www/LocalNursingHomes/v4/www/nursinghomes.cfm:33) at cfnursingHome2ecfc996129222$funcGETSTATICBYLISTINGOPTIONS.runFunction(C:/www/LocalNursingHomes/v4/cfc/dao/nursingHome.cfc:306) at cfnursingHome2ecfc1990211868$funcGETSTATICBYLISTINGOPTIONS.runFunction(C:/www/LocalNursingHomes/v4/cfc/nursingHome.cfc:41) at cfhomesByRadius2ecfc1565215586$funcSETFACILITIES.runFunction(C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc:230) at cfhomesByRadius2ecfc1565215586$funcINIT._factor0(C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc:25) at cfhomesByRadius2ecfc1565215586$funcINIT.runFunction(C:/www/LocalNursingHomes/v4/models/directories/nursinghomes/homesByRadius.cfc:24) at cfnursinghomes2ecfm1065966710.runPage(c:/www/LocalNursingHomes/v4/www/nursinghomes.cfm:33)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The app domain with specified version id (278680) was unloaded due to memory pressure and could not be found.
	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.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1100)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:807)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cfnursingHome2ecfc996129222$funcGETSTATICBYLISTINGOPTIONS.runFunction(C:\www\LocalNursingHomes\v4\cfc\dao\nursingHome.cfc:306)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144)
	at cfnursingHome2ecfc1990211868$funcGETSTATICBYLISTINGOPTIONS.runFunction(C:\www\LocalNursingHomes\v4\cfc\nursingHome.cfc:41)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144)
	at cfhomesByRadius2ecfc1565215586$funcSETFACILITIES.runFunction(C:\www\LocalNursingHomes\v4\models\directories\nursinghomes\homesByRadius.cfc:230)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3697)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3677)
	at cfhomesByRadius2ecfc1565215586$funcINIT._factor0(C:\www\LocalNursingHomes\v4\models\directories\nursinghomes\homesByRadius.cfc:25)
	at cfhomesByRadius2ecfc1565215586$funcINIT.runFunction(C:\www\LocalNursingHomes\v4\models\directories\nursinghomes\homesByRadius.cfc:24)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468)
	at coldfusion.runtime.CFPage.___createObjectInternal(CFPage.java:11851)
	at coldfusion.runtime.CFPage._createObject(CFPage.java:11829)
	at cfnursinghomes2ecfm1065966710.runPage(c:\www\LocalNursingHomes\v4\www\nursinghomes.cfm:33)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:484)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:223)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:170)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:225)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)