Ticket #830: selected.reporterscore.export.txt

File selected.reporterscore.export.txt, 4.3 KB (added by Martin Svensson, 15 years ago)

output file from table exporter when failing

Line 
1Name  Score External ID Gene symbol Description
2java.io.IOException: could not execute query using scroll
3  at net.sf.basedb.clients.web.plugins.SimpleExport.performExport(SimpleExport.java:388)
4  at net.sf.basedb.core.plugin.AbstractExporterPlugin.doExport(AbstractExporterPlugin.java:186)
5  at net.sf.basedb.core.PluginResponse.downloadImmediately(PluginResponse.java:158)
6  at org.apache.jsp.common.plugin.index_jsp._jspService(index_jsp.java:552)
7  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
8  at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
9  at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
10  at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
11  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
12  at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
13  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
14  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
15  at net.sf.basedb.clients.web.servlet.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:72)
16  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
17  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
18  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
19  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
20  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
21  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
22  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
23  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
24  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
25  at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
26  at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
27  at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
28  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
29  at java.lang.Thread.run(Thread.java:619)
30Caused by: net.sf.basedb.core.BaseException: could not execute query using scroll
31  at net.sf.basedb.core.HibernateUtil.loadIterator(HibernateUtil.java:1503)
32  at net.sf.basedb.core.ReporterScoreQuery.iterate(ReporterScoreQuery.java:68)
33  at net.sf.basedb.clients.web.plugins.ReporterScoreQueryWrapper.iterate(ReporterScoreQueryWrapper.java:66)
34  at net.sf.basedb.clients.web.plugins.SimpleExport.performExport(SimpleExport.java:342)
35  ... 26 more
36Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
37  at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
38  at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
39  at org.hibernate.loader.Loader.scroll(Loader.java:2328)
40  at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:441)
41  at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:390)
42  at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:245)
43  at org.hibernate.impl.StatelessSessionImpl.scroll(StatelessSessionImpl.java:586)
44  at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:67)
45  at net.sf.basedb.core.hibernate.QueryWrapper.scroll(QueryWrapper.java:116)
46  at net.sf.basedb.core.HibernateUtil.loadIterator(HibernateUtil.java:1498)
47  ... 29 more
48Caused by: java.sql.SQLException: No value specified for parameter 2
49  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
50  at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1699)
51  at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1647)
52  at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1357)
53  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
54  at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
55  at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
56  at org.hibernate.loader.Loader.scroll(Loader.java:2293)
57  ... 36 more