Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]The app domain with specified version id (413331) 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)
AND z.CityName = (param 6)
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 |
162.158.78.225 |
Referrer |
|
Date/Time |
29-Mar-24 07:37 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 (413331) 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)
|
|