Database Exception Handler
A problem has occurred while attempting to process your request.
Exception type: Database
Error Event: onRequest
Report that page /QualityOfCare.cfm?quality_measure_group_id=27&print_page=true generated the following messages:
A message has been sent to the CPA developers.
Quality of Care
Date and Time the Error Occurred: 03/29/2024 10:14 AM
Datasource: CPAWebApps
Database Detail: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
Database ErrorCode: HY000
Database Message: Error Executing Database Query.
Database RootCause: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
Databsse SQL:
SELECT quality_measures_group_mapping.quality_measure_id,
quality_measures.description, quality_measures.whatthismeans,
quality_measures.whyitisimportant,
quality_measures_group_mapping.quality_measure_group_id,
quality_measures.graph_title, quality_measures.graph_title1,
case when quality_graph_type_id=1 then
quality_measures.uh*100
else
quality_measures.uh end as UH,
case when quality_graph_type_id=1 then
quality_measures.nationalavg*100
else
quality_measures.nationalavg
end AS nationalavg,
quality_measures.scale_desc, quality_measures.quality_graph_type_id,
quality_measures.last_maint_date
FROM quality_measures_group_mapping, quality_measures
WHERE quality_measures_group_mapping.quality_measure_id =
quality_measures.quality_measure_id
AND quality_measures_group_mapping.quality_measure_group_id =
AND quality_measures.is_used = 1
AND uh is not null
AND nationalavg is not null
ORDER BY quality_measures_group_mapping.sort_order
Database Cause ErrorCode: 936
Database Cause Message: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
Database Cause StackTrace: ------------------- java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source)
at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source)
at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source)
at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source)
at macromedia.jdbc.oracle.ddal.a(Unknown Source)
at macromedia.jdbc.oracle.ddal.a(Unknown Source)
at macromedia.jdbc.oracle.ddam.t(Unknown Source)
at macromedia.jdbc.oraclebase.dde3.y(Unknown Source)
at macromedia.jdbc.oraclebase.dde3.u(Unknown Source)
at macromedia.jdbc.oraclebase.dde3.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)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfQualityOfCare2ecfm58776699._factor24(G:\inetpub\cpawebapps\QualityOfCare.cfm:313)
at cfQualityOfCare2ecfm58776699._factor26(G:\inetpub\cpawebapps\QualityOfCare.cfm:257)
at cfQualityOfCare2ecfm58776699._factor28(G:\inetpub\cpawebapps\QualityOfCare.cfm:250)
at cfQualityOfCare2ecfm58776699.runPage(G:\inetpub\cpawebapps\QualityOfCare.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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfApplication2ecfc1337516634$funcONREQUEST.runFunction(G:\inetpub\cpawebapps\Application.cfc:95)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470)
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.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: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: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)
-------------------
Click here to return to the previous page.
Do not use your browser's "Back" button.
|