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]Divide by zero error encountered.
 
The error occurred in C:/Web/PCL_NEW/staffing_new/display.cfm: line 54
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 4
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 1
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 54
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 4
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 1
 
52 : /PA1.A_BUDGET_WHPPD *100,2) as PERCENT_VARIANCE
53 : from P1ST_AUI PA JOIN P1ST_ACTUAL PA1 ON PA.ACTUAL_ID=PA1.ACTUAL_ID
54 : where (ID = #ID#) AND Hospital_Name = '#Name#' AND (Unit_Name = '#Unit#')
55 : order by OrderOfLines
56 : </CFQUERY>
SQLSTATE   22012
DATASOURCE   MHA
VENDORERRORCODE   8134
SQL    select PA.Add_Unit_Info, PA.WHPPD, PA1.A_BUDGET_WHPPD,PA1.A_PATIENT_DAYS, PA.Avg_Daily_Census, PA.OrderOfLines, round ((PA1.A_TOTAL_WH/PA1.A_TOTAL_PD),2) as WHPPD_ACTUAL, round( (PA1.A_TOTAL_WH/PA1.A_TOTAL_PD) - PA1.A_BUDGET_WHPPD,2) as VARIANCE, round(round((round((PA1.A_TOTAL_WH/PA1.A_TOTAL_PD) ,2) - PA1.A_BUDGET_WHPPD),2) /PA1.A_BUDGET_WHPPD *100,2) as PERCENT_VARIANCE from P1ST_AUI PA JOIN P1ST_ACTUAL PA1 ON PA.ACTUAL_ID=PA1.ACTUAL_ID where (ID = 20078) AND Hospital_Name = 'Spaulding Rehabilitation Hospital' AND (Unit_Name = 'Amputee / Vascular') order by OrderOfLines
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.191.102.112
Referrer  
Date/Time   28-Apr-24 09:39 PM
Stack Trace
at cfdisplay2ecfm1445762650._factor4(C:/Web/PCL_NEW/staffing_new/display.cfm:54) at cfdisplay2ecfm1445762650._factor11(C:/Web/PCL_NEW/staffing_new/display.cfm:4) at cfdisplay2ecfm1445762650.runPage(C:/Web/PCL_NEW/staffing_new/display.cfm:1) at cfdisplay2ecfm1445762650._factor4(C:/Web/PCL_NEW/staffing_new/display.cfm:54) at cfdisplay2ecfm1445762650._factor11(C:/Web/PCL_NEW/staffing_new/display.cfm:4) at cfdisplay2ecfm1445762650.runPage(C:/Web/PCL_NEW/staffing_new/display.cfm:1) 

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered.
	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.dda4.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:1537)
	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.startQueryExecution(QueryTag.java:815)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cfdisplay2ecfm1445762650._factor4(C:\Web\PCL_NEW\staffing_new\display.cfm:54)
	at cfdisplay2ecfm1445762650._factor11(C:\Web\PCL_NEW\staffing_new\display.cfm:4)
	at cfdisplay2ecfm1445762650.runPage(C:\Web\PCL_NEW\staffing_new\display.cfm:1)
	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:505)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)