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 151) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in D:/sites/maccasmaster_orion1/orionclient/model/dashboards/DashboardGateway.cfc: line 303
Called from D:/sites/maccasmaster_orion1/orionclient/dashboards/welcomeBooking.cfm: line 4
Called from D:/sites/maccasmaster_orion1/orion/view/tags/shared/pageNew.cfm: line 66
Called from D:/sites/maccasmaster_orion1/orion/public/index.cfm: line 968
Called from D:/sites/maccasmaster_orion1/orion/public/index.cfm: line 941
Called from D:/sites/maccasmaster_orion1/orionclient/model/dashboards/DashboardGateway.cfc: line 303
Called from D:/sites/maccasmaster_orion1/orionclient/dashboards/welcomeBooking.cfm: line 4
Called from D:/sites/maccasmaster_orion1/orion/view/tags/shared/pageNew.cfm: line 66
Called from D:/sites/maccasmaster_orion1/orion/public/index.cfm: line 968
Called from D:/sites/maccasmaster_orion1/orion/public/index.cfm: line 941
301 : 				and interviewBooking != 0
302 : 				and isb.interviewSlotBookingId is null
303 : 				and jal.lastStatusUpdateDate >= '#HIRED_STATUS_UPDATE_DATE#'
304 : 				group by jal.jobApplicationId
305 : 			</cfquery>

VENDORERRORCODE   1205
SQLSTATE   40001
SQL    select distinct jal.jobApplicationId from jobapplicationlocation jal inner join jobApplication ja on jal.jobApplicationId = ja.jobApplicationId inner join dbo.position p on jal.jobPositionId = p.positionId inner join dbo.jobWorkflowState jws on jal.jobStateId = jws.jobStateId left join dbo.interviewSlotBooking isb on jal.jobApplicationLocationId = isb.jobApplicationLocationId and jal.jobStateId = isb.jobStateId and jws.jobWorkflowId = ( case when ja.applicantType = 0 then p.externalWorkflowId else p.internalWorkflowId end ) where jal.userId = (param 1) and jal.jobStateId = (param 2) and interviewBooking != 0 and isb.interviewSlotBookingId is null and jal.lastStatusUpdateDate >= '2016-11-08 00:00:00.000' group by jal.jobApplicationId
DATASOURCE   orion_maccasmaster
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.84.182.112
Referrer  
Date/Time   23-Apr-19 09:02 AM
Stack Trace
at cfDashboardGateway2ecfc956630240$funcDISPLAYWELCOMEBOOKING.runFunction(D:/sites/maccasmaster_orion1/orionclient/model/dashboards/DashboardGateway.cfc:303) at cfwelcomeBooking2ecfm1393371675.runPage(D:/sites/maccasmaster_orion1/orionclient/dashboards/welcomeBooking.cfm:4) at cfpageNew2ecfm1571771225.runPage(D:/sites/maccasmaster_orion1/orion/view/tags/shared/pageNew.cfm:66) at cfindex2ecfm772623407._factor190(D:/sites/maccasmaster_orion1/orion/public/index.cfm:968) at cfindex2ecfm772623407.runPage(D:/sites/maccasmaster_orion1/orion/public/index.cfm:941) at cfDashboardGateway2ecfc956630240$funcDISPLAYWELCOMEBOOKING.runFunction(D:/sites/maccasmaster_orion1/orionclient/model/dashboards/DashboardGateway.cfc:303) at cfwelcomeBooking2ecfm1393371675.runPage(D:/sites/maccasmaster_orion1/orionclient/dashboards/welcomeBooking.cfm:4) at cfpageNew2ecfm1571771225.runPage(D:/sites/maccasmaster_orion1/orion/view/tags/shared/pageNew.cfm:66) at cfindex2ecfm772623407._factor190(D:/sites/maccasmaster_orion1/orion/public/index.cfm:968) at cfindex2ecfm772623407.runPage(D:/sites/maccasmaster_orion1/orion/public/index.cfm:941)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 151) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
	at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.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.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddf.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddf.execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddj.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1458)
	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 cfDashboardGateway2ecfc956630240$funcDISPLAYWELCOMEBOOKING.runFunction(D:\sites\maccasmaster_orion1\orionclient\model\dashboards\DashboardGateway.cfc:303)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2432)
	at cfwelcomeBooking2ecfm1393371675.runPage(D:\sites\maccasmaster_orion1\orionclient\dashboards\welcomeBooking.cfm:4)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cfpageNew2ecfm1571771225.runPage(D:\sites\maccasmaster_orion1\orion\view\tags\shared\pageNew.cfm:66)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
	at cfindex2ecfm772623407._factor190(D:\sites\maccasmaster_orion1\orion\public\index.cfm:968)
	at cfindex2ecfm772623407.runPage(D:\sites\maccasmaster_orion1\orion\public\index.cfm:941)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:428)
	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:46)
	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:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	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:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)