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 generated the following messages:

A message has been sent to the CPA developers.

Quality of Care

Date and Time the Error Occurred: 02/13/2016 06:35 PM
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, quality_measures.uh, quality_measures.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.ddca.b(Unknown Source) at macromedia.jdbc.oraclebase.ddca.a(Unknown Source) at macromedia.jdbc.oraclebase.ddb9.b(Unknown Source) at macromedia.jdbc.oraclebase.ddb9.a(Unknown Source) at macromedia.jdbc.oracle.ddm.q(Unknown Source) at macromedia.jdbc.oraclebase.ddem.v(Unknown Source) at macromedia.jdbc.oraclebase.ddem.r(Unknown Source) at macromedia.jdbc.oraclebase.ddem.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1442) 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:1056) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:685) at cfQualityOfCare2ecfm58776699._factor24(G:\Inetpub\cpawebapps\QualityOfCare.cfm:473) at cfQualityOfCare2ecfm58776699._factor26(G:\Inetpub\cpawebapps\QualityOfCare.cfm:425) at cfQualityOfCare2ecfm58776699._factor28(G:\Inetpub\cpawebapps\QualityOfCare.cfm:418) at cfQualityOfCare2ecfm58776699.runPage(G:\Inetpub\cpawebapps\QualityOfCare.cfm:1) 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 cfApplication2ecfc1337516634$funcONREQUEST.runFunction(G:\Inetpub\cpawebapps\Application.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) 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.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:424) 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.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$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)
-------------------


Click here to return to the previous page.

Do not use your browser's "Back" button.