Help is on the way.
| struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource | bigbadbo_Family | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Detail | [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ErrorCode | 22012 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Exceptions |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Message | Error Executing Database Query. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| NativeErrorCode | 8134 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| RootCause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLState | 22012 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sql | SELECT MM.BondsAuthorized_cy , REPLACE(CASE WHEN CHARINDEX('/', MM.County_mv) = 0 THEN MM.County_mv ELSE LEFT(MM.County_mv, CHARINDEX('/', MM.County_mv) - 1) END, ' ', '_') AS County_cd , CASE WHEN MONTH(MM.ElectionDay_dt) = 11 THEN 'General' ELSE 'Primary' END AS Election_cd , MM.Measure_cd , MM.Outcome_fg , (CONVERT(decimal(12,4), MM.VotesCast_nb - MM.VotesFor_nb) / CONVERT(decimal(12,4), MM.VotesCast_nb)) * 100 AS VotePercentNo_nb , (CONVERT(decimal(12,4), MM.VotesFor_nb) / CONVERT(decimal(12,4), MM.VotesCast_nb)) * 100 AS VotePercentYes_nb , MM.VotesCast_nb , MM.VotesCast_nb - MM.VotesFor_nb AS VotesNo_nb , MM.VotesFor_nb AS VotesYes_nb , YEAR(MM.ElectionDay_dt) AS Year_cd , NULL AS BallotQuestion_tx , MM.ElectionDay_dt , NULL AS MeasureType_cd , NULL AS TaxRate_tx , NULL AS Duration_cd , NULL AS TaxAmount_cy , NULL AS Opponent_tx FROM dbo.MeasureMasterV2/*APCDB.apcdb.dbo.MeasureMasterV2*/ AS MM LEFT JOIN dbo.EducationDistrictMaster/*APCDB.apcdb.dbo.EducationDistrictMaster*/ AS EDM ON MM.EducationDistrictMaster_id = EDM.EducationDistrictMaster_id LEFT JOIN dbo.MeasureDetail/*APCDB.apcdb.dbo.MeasureDetail*/ AS MD ON EDM.DistrictNCES_cd = CASE WHEN CHARINDEX(':', MD.DistrictNCES_cd) = 0 THEN MD.DistrictNCES_cd ELSE LEFT(MD.DistrictNCES_cd, CHARINDEX(':', MD.DistrictNCES_cd) - 1) END AND EDM.County_cd = MD.County_cd AND MM.ElectionDay_dt = MD.ElectionDay_dt AND MM.Measure_cd = MD.Measure_cd WHERE 1 = 1 -- 2022-08-17: Allow non-school district agencies to return without error on ballot-argument-referral page. -- 2022-10-21: Changed refereence to master id. AND MM.EducationDistrictMaster_id = CASE WHEN '821'/*@sMeasureDistrict*/ = '' THEN 0 ELSE '821'/*@sMeasureDistrict*/ END AND MM.ElectionDay_dt < GETDATE() /* UNION ALL SELECT CONVERT(money, BondAmount_cy) AS BondsAuthorized_cy , REPLACE(CASE WHEN CHARINDEX('/', County_cd) = 0 THEN County_cd ELSE LEFT(County_cd, CHARINDEX('/', County_cd) - 1) END, ' ', '_') AS County_cd , CASE WHEN MONTH(ElectionDay_dt) = 11 THEN 'General' ELSE 'Primary' END AS Election_cd , Measure_cd , NULL AS Outcome_fg , NULL AS VotePercentNo_nb /*(CONVERT(decimal(12,4), MM.VotesCast_nb - MM.VotesFor_nb) / CONVERT(decimal(12,4), MM.VotesCast_nb)) * 100 AS VotePercentNo_nb*/ , NULL AS VotePercentYes_nb /*(CONVERT(decimal(12,4), MM.VotesFor_nb) / CONVERT(decimal(12,4), MM.VotesCast_nb)) * 100 AS VotePercentYes_nb*/ , NULL AS VotesCast_nb , NULL AS VotesNo_nb /*VotesCast_nb - MM.VotesFor_nb AS VotesNo_nb*/ , NULL AS VotesYes_nb , YEAR(ElectionDay_dt) AS Year_cd , BallotQuestion_tx , ElectionDay_dt , MeasureType_cd , TaxRate_tx , Duration_cd , CONVERT(money, TaxAmount_cy) AS TaxAmount_cy , Opponent_tx FROM dbo.ch_ballot_question_20/*APCDB.apcdb.dbo.ch_ballot_question_20*/ WHERE 1 = 1 AND ElectionDay_dt = '2022-11-08'/*'2024-11-05'*//*@sElection*/ AND County_cd = 'San Bernardino'/*@sCounty*/ AND Measure_cd = 'G'/*@sMeasure*/ AND Entity_cd = '0602160' */ UNION ALL SELECT CONVERT(money, BQ.BondAmount_cy) AS BondsAuthorized_cy , REPLACE(CASE WHEN CHARINDEX('/', BQ.County_cd) = 0 THEN BQ.County_cd ELSE LEFT(BQ.County_cd, CHARINDEX('/', BQ.County_cd) - 1) END, ' ', '_') AS County_cd , BQ.ElectionType_cd AS Election_cd , BQ.Measure_cd -- 2024-10-14: Replace Outcome_fg, VotesCast_nb, VotesNo_nb, and VotesYes_nb --, NULL AS Outcome_fg , vCMR.PassFail_fg AS Outcome_fg -- 2024-10-13: Replace the results from the join to CEDA measures. , NULL AS VotePercentNo_nb --, NULL AS VotePercentYes_nb , REPLACE(CASE WHEN COALESCE(v24.VotePct_nb, 'x.xx%') = 'x.xx%' THEN vCMR.VotePercent_nb ELSE v24.VotePct_nb END, '%', '') AS VotePercentYes_nb --, NULL AS VotesCast_nb , REPLACE(vCMR.VoteTotal_nb, ',', '') AS VotesCast_nb --, NULL AS VotesNo_nb /*VotesCast_nb - MM.VotesFor_nb AS VotesNo_nb*/ , REPLACE(vCMR.VoteNo_nb, ',', '') AS VotesNo_nb --, NULL AS VotesYes_nb , REPLACE(vCMR.VoteYes_nb, ',', '') AS VotesYes_nb , YEAR(BQ.ElectionDay_dt) AS Year_cd , BQ.BallotQuestion_tx , BQ.ElectionDay_dt , BQ.MeasureType_cd , BQ.TaxRate_tx , BQ.Duration_cd , CONVERT(money, BQ.TaxAmount_cy) AS TaxAmount_cy , BQ.Opponent_tx FROM dbo.ch_ballot_question_20 AS BQ -- 2024-10-13: Join the CEDA measure results. LEFT JOIN dbo.vw_MeasureDetail2024 AS v24 ON BQ.Row_id = v24.Row_id LEFT JOIN dbo.vw_CEDAMeasureResults AS vCMR ON v24.Row_id = vCMR.Row_id WHERE 1 = 1 AND BQ.Entity_cd = '0602160' -- 2024-10-09: Exclude any other measures in the current election that are not the one retrieved. AND NOT ( BQ.ElectionDay_dt = '2024-11-05' AND BQ.Measure_cd <> 'G' ) /* SELECT ElectionDay_dt, County_cd, Measure_cd, MeasureType_cd FROM dbo.ch_ballot_question_20 AS BQ WHERE 1 = 1 AND BQ.Entity_cd = '0629940' AND NOT ( BQ.ElectionDay_dt = '2024-11-05' AND BQ.Measure_cd <> 'R' ) */ ORDER BY MM.ElectionDay_dt DESC , MM.Measure_cd -- 2024-10-09: Handle sort for multiple measures on same day. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cf_db2dquery2ecfm168174367.runPage(/home/bigbadbo/public_html/CALBONDS/_db-query.cfm:202) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfballot2dargument2dreferral2ecfm774489901._factor9(/home/bigbadbo/public_html/CALBONDS/ballot-argument-referral.cfm:116) at cfballot2dargument2dreferral2ecfm774489901._factor14(/home/bigbadbo/public_html/CALBONDS/ballot-argument-referral.cfm:3) at cfballot2dargument2dreferral2ecfm774489901._factor16(/home/bigbadbo/public_html/CALBONDS/ballot-argument-referral.cfm:2) at cfballot2dargument2dreferral2ecfm774489901.runPage(/home/bigbadbo/public_html/CALBONDS/ballot-argument-referral.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) 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: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$original$cvVTJTdz(CfmServlet.java:219) at coldfusion.CfmServlet.service$original$cvVTJTdz$accessor$8F5qVgyy(CfmServlet.java) at coldfusion.CfmServlet$auxiliary$zvxw3Vvj.call(Unknown Source) at com.hostmedia.javapulse.JavaPulseAgent$ServletInterceptor.intercept(JavaPulseAgent.java:342) at coldfusion.CfmServlet.service(CfmServlet.java) at coldfusion.bootstrap.BootstrapServlet.service$original$FjqF4BGI(BootstrapServlet.java:89) at coldfusion.bootstrap.BootstrapServlet.service$original$FjqF4BGI$accessor$kZaqL1Wj(BootstrapServlet.java) at coldfusion.bootstrap.BootstrapServlet$auxiliary$9JhtJ4gm.call(Unknown Source) at com.hostmedia.javapulse.JavaPulseAgent$ServletInterceptor.intercept(JavaPulseAgent.java:342) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java) at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:288) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:285) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:549) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:320) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:175) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:297) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:191) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:187) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:186) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:288) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:285) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:549) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:320) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:191) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:187) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: 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.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddm.x(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddm.d(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddn.a(Unknown Source) at macromedia.jdbc.sqlserver.dda3.h(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:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 83 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Suppressed |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| queryError | [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| where | [empty string] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||