Created
July 10, 2015 14:27
-
-
Save Erotemic/d28cad5913d174726dab to your computer and use it in GitHub Desktop.
Images OnScreen Error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| HTTP Status 500 - An exception occurred processing JSP page /encounters/thumbnailSearchResults.jsp at line 108 | |
| type Exception report | |
| message An exception occurred processing JSP page /encounters/thumbnailSearchResults.jsp at line 108 | |
| description The server encountered an internal error that prevented it from fulfilling this request. | |
| exception | |
| org.apache.jasper.JasperException: An exception occurred processing JSP page /encounters/thumbnailSearchResults.jsp at line 108 | |
| 105: else{ | |
| 106: Query allQuery=myShepherd.getPM().newQuery("SELECT from org.ecocean.SinglePhotoVideo WHERE correspondingEncounterNumber != null"); | |
| 107: allQuery.setRange(startNum, endNum); | |
| 108: rEncounters=new ArrayList<SinglePhotoVideo>((Collection<SinglePhotoVideo>)allQuery.execute()); | |
| 109: } | |
| 110: | |
| 111: %> | |
| Stacktrace: | |
| org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:574) | |
| org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476) | |
| org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) | |
| org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
| org.ecocean.servlet.StrutsUTF8Filter.doFilter(StrutsUTF8Filter.java:33) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) | |
| org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) | |
| org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) | |
| org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| root cause | |
| javax.jdo.JDODataStoreException: Iteration request failed : SELECT 'org.ecocean.Keyword' AS NUCLEUS_TYPE,A1.INDEXNAME,A1.READABLENAME,A0.DATACOLLECTIONEVENTID_OID,A0.IDX AS NUCORDER0 FROM SINGLEPHOTOVIDEO_KEYWORDS A0 INNER JOIN KEYWORD A1 ON A0.INDEXNAME_EID = A1.INDEXNAME WHERE A0.IDX >= 0 AND EXISTS (SELECT 'org.ecocean.SinglePhotoVideo' AS NUCLEUS_TYPE,A0_SUB.DATACOLLECTIONEVENTID AS DN_APPID FROM SINGLEPHOTOVIDEO A0_SUB INNER JOIN DATACOLLECTIONEVENT A1_SUB ON A0_SUB.DATACOLLECTIONEVENTID = A1_SUB.DATACOLLECTIONEVENTID WHERE A1_SUB.CORRESPONDINGENCOUNTERNUMBER IS NOT NULL AND A0.DATACOLLECTIONEVENTID_OID = A0_SUB.DATACOLLECTIONEVENTID) ORDER BY NUCORDER0 | |
| NestedThrowables: | |
| java.sql.SQLSyntaxErrorException: Subquery is only allowed to return a single column. | |
| org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:546) | |
| org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:232) | |
| org.apache.jsp.encounters.thumbnailSearchResults_jsp._jspService(thumbnailSearchResults_jsp.java:199) | |
| org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) | |
| org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) | |
| org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
| org.ecocean.servlet.StrutsUTF8Filter.doFilter(StrutsUTF8Filter.java:33) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) | |
| org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) | |
| org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) | |
| org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| root cause | |
| java.sql.SQLSyntaxErrorException: Subquery is only allowed to return a single column. | |
| org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
| org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
| org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
| org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
| org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) | |
| org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
| org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) | |
| org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) | |
| org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:350) | |
| org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:295) | |
| org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:687) | |
| org.datanucleus.store.query.Query.executeQuery(Query.java:1840) | |
| org.datanucleus.store.query.Query.executeWithArray(Query.java:1729) | |
| org.datanucleus.store.query.Query.execute(Query.java:1711) | |
| org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:223) | |
| org.apache.jsp.encounters.thumbnailSearchResults_jsp._jspService(thumbnailSearchResults_jsp.java:199) | |
| org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) | |
| org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) | |
| org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
| org.ecocean.servlet.StrutsUTF8Filter.doFilter(StrutsUTF8Filter.java:33) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) | |
| org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) | |
| org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) | |
| org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| root cause | |
| java.sql.SQLException: Subquery is only allowed to return a single column. | |
| org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) | |
| org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) | |
| org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
| org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
| org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
| org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
| org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) | |
| org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
| org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) | |
| org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) | |
| org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:350) | |
| org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:295) | |
| org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:687) | |
| org.datanucleus.store.query.Query.executeQuery(Query.java:1840) | |
| org.datanucleus.store.query.Query.executeWithArray(Query.java:1729) | |
| org.datanucleus.store.query.Query.execute(Query.java:1711) | |
| org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:223) | |
| org.apache.jsp.encounters.thumbnailSearchResults_jsp._jspService(thumbnailSearchResults_jsp.java:199) | |
| org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) | |
| org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) | |
| org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
| org.ecocean.servlet.StrutsUTF8Filter.doFilter(StrutsUTF8Filter.java:33) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) | |
| org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) | |
| org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) | |
| org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| root cause | |
| ERROR 42X39: Subquery is only allowed to return a single column. | |
| org.apache.derby.iapi.error.StandardException.newException(Unknown Source) | |
| org.apache.derby.impl.sql.compile.SubqueryNode.bindExpression(Unknown Source) | |
| org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) | |
| org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) | |
| org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source) | |
| org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) | |
| org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) | |
| org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) | |
| org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) | |
| org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) | |
| org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) | |
| org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) | |
| org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
| org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
| org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) | |
| org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) | |
| org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:350) | |
| org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:295) | |
| org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:687) | |
| org.datanucleus.store.query.Query.executeQuery(Query.java:1840) | |
| org.datanucleus.store.query.Query.executeWithArray(Query.java:1729) | |
| org.datanucleus.store.query.Query.execute(Query.java:1711) | |
| org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:223) | |
| org.apache.jsp.encounters.thumbnailSearchResults_jsp._jspService(thumbnailSearchResults_jsp.java:199) | |
| org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) | |
| org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) | |
| org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) | |
| javax.servlet.http.HttpServlet.service(HttpServlet.java:729) | |
| org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
| org.ecocean.servlet.StrutsUTF8Filter.doFilter(StrutsUTF8Filter.java:33) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) | |
| org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) | |
| org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) | |
| org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) | |
| org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) | |
| org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) | |
| org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) | |
| note The full stack trace of the root cause is available in the Apache Tomcat/8.0.24 logs. | |
| Apache Tomcat/8.0.24 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment