org.apache.jasper.el.JspELException: /WEB-INF/jsp/online/system/modules/ch.ethz.sed.bootstrap.resources.flexitable/formatters/dbplotter-formatter.jsp(39,12) '${db:executeSqlSelectQuery(requestVo)}' Problems calling function [db:executeSqlSelectQuery]
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:141)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_resources_flexitable.formatters.dbplotter_002dformatter_jsp._jspx_meth_c_005fset_005f11(dbplotter_002dformatter_jsp.java:1188)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_resources_flexitable.formatters.dbplotter_002dformatter_jsp._jspx_meth_c_005fcatch_005f0(dbplotter_002dformatter_jsp.java:1150)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_resources_flexitable.formatters.dbplotter_002dformatter_jsp._jspService(dbplotter_002dformatter_jsp.java:250)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:407)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:260)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1582)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:592)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_cms_005fcontainer_005f0(layoutrow_jsp.java:1965)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_c_005fotherwise_005f0(layoutrow_jsp.java:1892)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_c_005fchoose_005f1(layoutrow_jsp.java:1826)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_c_005fforEach_005f0(layoutrow_jsp.java:620)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspService(layoutrow_jsp.java:210)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:407)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:260)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1582)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:592)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.templaterow_jsp._jspx_meth_cms_005fcontainer_005f0(templaterow_jsp.java:1384)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.templaterow_jsp._jspx_meth_c_005fforEach_005f0(templaterow_jsp.java:407)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.templaterow_jsp._jspService(templaterow_jsp.java:187)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:407)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:260)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1582)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:592)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_stations.templates.bootstrap_002dgrid_002dpage_jsp._jspx_meth_cms_005fcontainer_005f0(bootstrap_002dgrid_002dpage_jsp.java:1598)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_stations.templates.bootstrap_002dgrid_002dpage_jsp._jspService(bootstrap_002dgrid_002dpage_jsp.java:262)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:982)
at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:533)
at org.opencms.loader.CmsXmlContainerPageLoader.load(CmsXmlContainerPageLoader.java:108)
at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1196)
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:2823)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.opencms.jsp.jsonpart.CmsJsonPartFilter.doFilter(CmsJsonPartFilter.java:298)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.opencms.main.OpenCmsUrlServletFilter.doFilter(OpenCmsUrlServletFilter.java:132)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
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:433)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1735)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.RuntimeException: Exception thrown executing inner query. [sql='select
encode(dlpickcomment.m_text, 'escape'::text)::double precision as "dlpick confidence",
case when prefpick.m_time_loweruncertainty is not null then round(prefpick.m_time_loweruncertainty::numeric,3) else 0 end as "manupick_uncertainty (sec., analyst assigned)",
preforigin.m_time_value as "origin time"
from
pick as dlpick inner join arrival as dlarrival on dlarrival.m_pickid = dlpick.m_publicid
inner join origin as dlorigin on dlarrival._parent_oid = dlorigin._oid
inner join originreference as dloriginreference on dloriginreference.m_originid = dlorigin.m_publicid
inner join event on event._oid = dloriginreference._parent_oid
inner join origin as preforigin on event.m_preferredoriginid = preforigin.m_publicid
inner join magnitude as prefmagnitude on event.m_preferredmagnitudeid = prefmagnitude.m_publicid
inner join arrival as prefarrival on prefarrival._parent_oid = preforigin._oid
inner join pick as prefpick on prefarrival.m_pickid = prefpick.m_publicid
left join comment as dlpickcomment on dlpickcomment._parent_oid = dlpick._oid and dlpickcomment.m_id = 'confidence'
where dlpick.m_creationinfo_author = 'ML picker' and
dlpick.m_waveformid_networkcode = prefpick.m_waveformid_networkcode
and dlpick.m_waveformid_stationcode = prefpick.m_waveformid_stationcode
--and dlpick.m_waveformid_locationcode = prefpick.m_waveformid_locationcode
and dlpick.m_waveformid_channelcode = prefpick.m_waveformid_channelcode
and dlarrival.m_phase_code = left(prefarrival.m_phase_code,1)
and event._oid =
order by dlpick.m_time_value desc']
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.ColumnNamesSeeker.invoke(ColumnNamesSeeker.java:49)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.QueryExecutor.doExecuteSqlSelectQuery(QueryExecutor.java:186)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.QueryExecutor.executeSqlSelectQuery(QueryExecutor.java:134)
at jdk.internal.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.el.parser.AstFunction.getValue(AstFunction.java:198)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:129)
... 125 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "order"
Position: 1529
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2427)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2169)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.QueryExecutor.executeSqlQuery(QueryExecutor.java:886)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.ColumnNamesSeeker.invoke(ColumnNamesSeeker.java:46)
... 133 more
org.apache.jasper.el.JspELException: /WEB-INF/jsp/online/system/modules/ch.ethz.sed.bootstrap.resources.flexitable/formatters/dbplotter-formatter.jsp(39,12) '${db:executeSqlSelectQuery(requestVo)}' Problems calling function [db:executeSqlSelectQuery]
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:141)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_resources_flexitable.formatters.dbplotter_002dformatter_jsp._jspx_meth_c_005fset_005f11(dbplotter_002dformatter_jsp.java:1188)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_resources_flexitable.formatters.dbplotter_002dformatter_jsp._jspx_meth_c_005fcatch_005f0(dbplotter_002dformatter_jsp.java:1150)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_resources_flexitable.formatters.dbplotter_002dformatter_jsp._jspService(dbplotter_002dformatter_jsp.java:250)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:407)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:260)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1582)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:592)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_cms_005fcontainer_005f0(layoutrow_jsp.java:1965)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_c_005fotherwise_005f0(layoutrow_jsp.java:1892)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_c_005fchoose_005f1(layoutrow_jsp.java:1826)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspx_meth_c_005fforEach_005f0(layoutrow_jsp.java:620)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.layoutrow_jsp._jspService(layoutrow_jsp.java:210)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:407)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:260)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1582)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:592)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.templaterow_jsp._jspx_meth_cms_005fcontainer_005f0(templaterow_jsp.java:1384)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.templaterow_jsp._jspx_meth_c_005fforEach_005f0(templaterow_jsp.java:407)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_alkacon_bootstrap_formatters.formatters.templaterow_jsp._jspService(templaterow_jsp.java:187)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:407)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:260)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1582)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:592)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_stations.templates.bootstrap_002dgrid_002dpage_jsp._jspx_meth_cms_005fcontainer_005f0(bootstrap_002dgrid_002dpage_jsp.java:1598)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.ch_ethz_sed_bootstrap_stations.templates.bootstrap_002dgrid_002dpage_jsp._jspService(bootstrap_002dgrid_002dpage_jsp.java:262)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:578)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:517)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:654)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:443)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:982)
at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:533)
at org.opencms.loader.CmsXmlContainerPageLoader.load(CmsXmlContainerPageLoader.java:108)
at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1196)
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:2823)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.opencms.jsp.jsonpart.CmsJsonPartFilter.doFilter(CmsJsonPartFilter.java:298)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.opencms.main.OpenCmsUrlServletFilter.doFilter(OpenCmsUrlServletFilter.java:132)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
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:433)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1735)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.RuntimeException: Exception thrown executing inner query. [sql='select
encode(dlpickcomment.m_text, 'escape'::text)::double precision as "dlpick confidence",
least(0.5::double precision, abs(extract( seconds from dlpick.m_time_value + (dlpick.m_time_value_ms::numeric || ' microseconds')::interval - prefpick.m_time_value - (prefpick.m_time_value_ms::numeric || ' microseconds')::interval ))) as "pick deviation (sec, abs.)",
preforigin.m_time_value as "origin time"
from
pick as dlpick inner join arrival as dlarrival on dlarrival.m_pickid = dlpick.m_publicid
inner join origin as dlorigin on dlarrival._parent_oid = dlorigin._oid
inner join originreference as dloriginreference on dloriginreference.m_originid = dlorigin.m_publicid
inner join event on event._oid = dloriginreference._parent_oid
inner join origin as preforigin on event.m_preferredoriginid = preforigin.m_publicid
inner join magnitude as prefmagnitude on event.m_preferredmagnitudeid = prefmagnitude.m_publicid
inner join arrival as prefarrival on prefarrival._parent_oid = preforigin._oid
inner join pick as prefpick on prefarrival.m_pickid = prefpick.m_publicid
left join comment as dlpickcomment on dlpickcomment._parent_oid = dlpick._oid and dlpickcomment.m_id = 'confidence'
where dlpick.m_creationinfo_author = 'ML picker' and
dlpick.m_waveformid_networkcode = prefpick.m_waveformid_networkcode
and dlpick.m_waveformid_stationcode = prefpick.m_waveformid_stationcode
-- and dlpick.m_waveformid_locationcode = prefpick.m_waveformid_locationcode
and dlpick.m_waveformid_channelcode = prefpick.m_waveformid_channelcode
and dlarrival.m_phase_code = left(prefarrival.m_phase_code,1)
and event._oid =
order by dlpick.m_time_value desc']
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.ColumnNamesSeeker.invoke(ColumnNamesSeeker.java:49)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.QueryExecutor.doExecuteSqlSelectQuery(QueryExecutor.java:186)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.QueryExecutor.executeSqlSelectQuery(QueryExecutor.java:134)
at jdk.internal.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.el.parser.AstFunction.getValue(AstFunction.java:198)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:129)
... 125 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "order"
Position: 1625
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2427)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2169)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.QueryExecutor.executeSqlQuery(QueryExecutor.java:886)
at ch.ethz.sed.bootstrap.resources.flexitable.taglibs.ColumnNamesSeeker.invoke(ColumnNamesSeeker.java:46)
... 133 more