Menu Content
Quality of Care
Quality of Care:SUNY Upstate Medical University
Quality of Care

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.