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]Transaction (Process ID 168) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in C:/inetsrv/template/reales/re_query.cfm: line 528
Called from C:/inetsrv/template/reales/re_query.cfm: line 317
Called from C:/inetsrv/template/reales/re_query.cfm: line 1
Called from C:/inetsrv/template/reales/re_query.cfm: line 528
Called from C:/inetsrv/template/reales/re_query.cfm: line 317
Called from C:/inetsrv/template/reales/re_query.cfm: line 1
526 : 			</cfif>
527 : 		</cfif>
528 : 		<cfif isDefined("rental")>
529 : 			and agentuserid in (select u.user_id FROM users u, usergroups ug WHERE u.user_id = ug.user_id and group_id = 40)		
530 : 		</cfif>

VENDORERRORCODE   1205
SQLSTATE   40001
SQL    select count(*) reccount from users u, reales re, cities ci, companies cp where re.agentuserid = u.user_id and u.comp_id = cp.comp_id and re.city_id = ci.city_id and (nopublic <> 'x' or nopublic is null) and (re.adstatus in ('p','b') or (re.adstatus = 'a' and expiredate >= getdate())) and u.user_id in (select user_id from userpreferences where pid = 507) and EXISTS (select ug.user_id from usergroups ug where group_id = 22 and u.user_id = ug.user_id) and (re.city_id in (1711) or (re.mailing_city_id in (1711) and re.mailing_city_id is not null)) and (alt_name = '' or alt_name is null) and (sqfeet <= 999999 or sqfeet is null) and idx is null
DATASOURCE   cf_forums
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.167.159.180
Referrer  
Date/Time   01-Mar-17 02:57 PM
Stack Trace
at cfre_query2ecfm1487780181._factor10(C:/inetsrv/template/reales/re_query.cfm:528) at cfre_query2ecfm1487780181._factor33(C:/inetsrv/template/reales/re_query.cfm:317) at cfre_query2ecfm1487780181.runPage(C:/inetsrv/template/reales/re_query.cfm:1) at cfre_query2ecfm1487780181._factor10(C:/inetsrv/template/reales/re_query.cfm:528) at cfre_query2ecfm1487780181._factor33(C:/inetsrv/template/reales/re_query.cfm:317) at cfre_query2ecfm1487780181.runPage(C:/inetsrv/template/reales/re_query.cfm:1)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 168) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
	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.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1451)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfre_query2ecfm1487780181._factor10(C:\inetsrv\template\reales\re_query.cfm:528)
	at cfre_query2ecfm1487780181._factor33(C:\inetsrv\template\reales\re_query.cfm:317)
	at cfre_query2ecfm1487780181.runPage(C:\inetsrv\template\reales\re_query.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	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)