Ticket #830: selected.reporterscore.export.txt

File selected.reporterscore.export.txt, 4.3 KB (added by Martin Svensson, 16 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