Iry,

a piece from your error log:

<snip>
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'g1biomart.G1_Biomart' doesn't exist
</snip>

indicates that the offending table is a part of query but
unfortunately doesnt exist in your database. Please check!

Syed



On 11 February 2013 17:59, Iry Witham <[email protected]> wrote:
> Hi Arek,
>
> 1.  I have checked to confirm that data does exist.  However, the data field
> for the filter that I used is blank.  This is a non-issue.
>
> 2.  Here is the tail of the stdouterr.20130211.log:
>
> 2013-02-11 11:53:35,161 INFO  [1329745730@qtp-1188579032-5:Log.java:164]:
> Total query time is 63 ms
> Feb 11, 2013 11:53:35 AM com.sun.jersey.spi.container.ContainerResponse
> mapMappableContainerException
> SEVERE: The RuntimeException could not be mapped to a response, re-throwing
> to the HTTP container
> Throwable occurred: java.lang.NumberFormatException: For input string:
> "error=true"
> at
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:60)
> at java.lang.Integer.parseInt(Integer.java:461)
> at java.lang.Integer.parseInt(Integer.java:511)
> at
> org.biomart.api.rest.PortalResource.getQueryCount(PortalResource.java:297)
> at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
> at java.lang.reflect.Method.invoke(Method.java:600)
> at
> com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:168)
> at
> com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:70)
> at
> com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:279)
> at
> com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:136)
> at
> com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:86)
> at
> com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:136)
> at
> com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:74)
> at
> com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1357)
> at
> com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1289)
> at
> com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1239)
> at
> com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1229)
> at
> com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:420)
> at
> com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:497)
> at
> com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:855)
> at
> com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:828)
> at
> com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:789)
> at
> com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
> at
> com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
> at org.biomart.web.PortalFilter.doFilter(PortalFilter.java:31)
> at
> com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
> at
> com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
> at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:78)
> at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:131)
> at
> com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
> at
> com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
> at
> com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:134)
> at
> com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
> at org.biomart.web.LocationsFilter.doFilter(LocationsFilter.java:29)
> at
> com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
> at
> com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
> at org.biomart.web.FlashMessageFilter.doFilter(FlashMessageFilter.java:35)
> at
> com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
> at
> com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
> at org.biomart.web.AuthFilter.doFilter(AuthFilter.java:47)
> at
> com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
> at
> com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
> at
> com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:122)
> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:110)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
> at
> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
> at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
> at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
> at
> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
> at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:326)
> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
> at
> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:924)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> at
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
> at
> org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'g1biomart.G1_Biomart' doesn't exist
> at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:516)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
> at com.mysql.jdbc.Util.getInstance(Util.java:382)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
> at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:761)
> at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:731)
> at
> org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171)
> at org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73)
> at org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:315)
> at java.util.concurrent.FutureTask.run(FutureTask.java:150)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:453)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:315)
> at java.util.concurrent.FutureTask.run(FutureTask.java:150)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:736)
> 2013-02-11 11:53:35,178 INFO  [1390236381@qtp-1188579032-9:Log.java:164]:
> Total query time is 23 ms
>
> Thanks,
> Iry
>
> From: Arek Kasprzyk <[email protected]>
> Date: Monday, February 11, 2013 12:45 PM
> To: Iry Witham <[email protected]>
> Cc: "[email protected]" <[email protected]>
> Subject: Re: [BioMart Users] 'Error has occurred'
>
> Hi Iry,
>
> 1. "No results found" would indicate that there is no data in your database
> that would satisfy your query. I suggest you use SQL to verify this
> (Ideally, SQL compiled by the BioMart application from the logs).
> 2. "Error has occurred". Please check the log and see what exactly the error
> is. We need more information about the problem
>
>
> a
>
>
> On Mon, Feb 11, 2013 at 4:54 PM, Iry Witham <[email protected]> wrote:
>>
>> Hi Biomart Team,
>>
>> I have setup a biomart with my own specific data and when I submit a query
>> I get one of two results.  I get the 'error has occurred' message or 'no
>> results found'  The following is the query that results in the error:
>>
>> <!DOCTYPE Query><Query client="biomartclient" processor="TSV" limit="-1"
>> header="1"><Dataset name="g1biomart" config="G1_Biomart_config"><Filter
>> name="G1_Biomart__G1_101_key_101" value="Pfkfb2"/><Attribute
>> name="G1_Biomart__Consequence_101_101"/></Dataset></Query>
>>
>> Thanks,
>>
>> Iry
>>
>> The information in this email, including attachments, may be confidential
>> and is intended solely for the addressee(s). If you believe you received
>> this email by mistake, please notify the sender by return email as soon as
>> possible.
>>
>>
>> _______________________________________________
>> Users mailing list
>> [email protected]
>> https://lists.biomart.org/mailman/listinfo/users
>>
>
> The information in this email, including attachments, may be confidential
> and is intended solely for the addressee(s). If you believe you received
> this email by mistake, please notify the sender by return email as soon as
> possible.
>
>
> _______________________________________________
> Users mailing list
> [email protected]
> https://lists.biomart.org/mailman/listinfo/users
>
_______________________________________________
Users mailing list
[email protected]
https://lists.biomart.org/mailman/listinfo/users

Reply via email to