| java error | Ben Bimber | 2010-04-15 14:05 |
| Status: Closed | ||
if you have a query, and you go to a URL that tries to filter that query on a non-existent column the QWP says something to the effect of 'Ignoring filter/sort on columns 'age.AgeInYears', 'species' because they do not exist.' If you then try to change the view of this query you get the following java error. This is reproducible with several queries. Error below: An unexpected error occurred javax.servlet.ServletException at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774) at org.labkey.jsp.compiled.org.labkey.query.controllers.chooseColumns_jsp._jspService(chooseColumns_jsp.java:331) at org.labkey.api.view.JspView.renderView(JspView.java:119) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:186) at org.labkey.api.view.HttpView.render(HttpView.java:140) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:566) at org.labkey.jsp.compiled.org.labkey.api.view.template.CommonTemplate_jsp._jspService(CommonTemplate_jsp.java:207) at org.labkey.api.view.JspView.renderView(JspView.java:119) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:186) at org.labkey.api.view.HttpView.render(HttpView.java:140) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:427) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:342) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:742) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:150) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:601) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) java.lang.AssertionError at org.labkey.study.query.ParticipantVisitDataSetTable.<init>(ParticipantVisitDataSetTable.java:49) at org.labkey.study.query.ParticipantDataSetTable$2.getLookupTableInfo(ParticipantDataSetTable.java:126) at org.labkey.api.data.ColumnInfo.getFkTableInfo(ColumnInfo.java:483) at org.labkey.query.controllers.ChooseColumnsForm.addColumns(ChooseColumnsForm.java:148) at org.labkey.query.controllers.ChooseColumnsForm.addColumns(ChooseColumnsForm.java:151) at org.labkey.query.controllers.ChooseColumnsForm.addColumns(ChooseColumnsForm.java:151) at org.labkey.query.controllers.ChooseColumnsForm.getAvailableColumns(ChooseColumnsForm.java:171) at org.labkey.query.controllers.ChooseColumnsForm.getCaption(ChooseColumnsForm.java:214) at org.labkey.query.controllers.ChooseColumnsForm.getFilterColumnNamesFromURL(ChooseColumnsForm.java:204) at org.labkey.jsp.compiled.org.labkey.query.controllers.chooseColumns_jsp._jspService(chooseColumns_jsp.java:221) at org.labkey.api.view.JspView.renderView(JspView.java:119) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:186) at org.labkey.api.view.HttpView.render(HttpView.java:140) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:566) at org.labkey.jsp.compiled.org.labkey.api.view.template.CommonTemplate_jsp._jspService(CommonTemplate_jsp.java:207) at org.labkey.api.view.JspView.renderView(JspView.java:119) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:186) at org.labkey.api.view.HttpView.render(HttpView.java:140) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:427) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:342) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:742) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:150) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:601) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) request attributes LABKEY.StartTime = 1271365330143 query = org.labkey.query.controllers.ChooseColumnsForm@19d9248 LABKEY.container = /WNPRC/EHR LABKEY.OriginalURL = http://localhost:8080/labkey/query/WNPRC/EHR/chooseColumns.view?query.queryName=demographics&schemaName=study&srcURL=%2Flabkey%2Fquery%2FWNPRC%2FEHR%2FexecuteQuery.view%3FschemaName%3Dstudy%26query.queryName%3Ddemographics%26query.species%257Eeq%3DCyno%26query.age%252FAgeInYears%257Eeq%3D4.0%26query.sex%257Eeq%3Df%26%3D&dataRegionName=query&queryName=demographics LABKEY.action = chooseColumns org.springframework.validation.BindingResult.query = org.springframework.validation.BeanPropertyBindingResult: 0 errors LABKEY.controller = query LABKEY.RequestURL = /labkey/query/WNPRC/EHR/chooseColumns.view?query.queryName=demographics&schemaName=study&srcURL=%2Flabkey%2Fquery%2FWNPRC%2FEHR%2FexecuteQuery.view%3FschemaName%3Dstudy%26query.queryName%3Ddemographics%26query.species%257Eeq%3DCyno%26query.age%252FAgeInYears%257Eeq%3D4.0%26query.sex%257Eeq%3Df%26%3D&dataRegionName=query&queryName=demographics LABKEY.OriginalURLHelper = /labkey/query/WNPRC/EHR/chooseColumns.view?query.queryName=demographics&schemaName=study&srcURL=%2Flabkey%2Fquery%2FWNPRC%2FEHR%2FexecuteQuery.view%3FschemaName%3Dstudy%26query.queryName%3Ddemographics%26query.species%257Eeq%3DCyno%26query.age%252FAgeInYears%257Eeq%3D4.0%26query.sex%257Eeq%3Df%26%3D&dataRegionName=query&queryName=demographics core schema database configuration Server URL jdbc:postgresql://localhost:5432/labkey2 Product Name PostgreSQL Product Version 8.4.3 Driver Name PostgreSQL Native Driver Driver Version PostgreSQL 8.4 JDBC3 (build 701) |
||