You are not logged in.
Im trying to schedule reports and save them in the TeamSpace but I get: could not extract ResultSet.
org.hibernate.exception.GenericJDBCException: could not extract ResultSet
<br> at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
<br> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
<br> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
<br> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
<br> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)
<br> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)
<br> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)
<br> at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:87)
<br> at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:705)
<br> at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:76)
<br> at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
<br> at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2208)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:595)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:591)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:149)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection$1.doWork(AbstractPersistentCollection.java:178)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection$1.doWork(AbstractPersistentCollection.java:163)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264)
<br> at org.hibernate.collection.internal.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:162)
<br> at org.hibernate.collection.internal.PersistentBag.isEmpty(PersistentBag.java:376)
<br> at net.datenwerke.scheduler.service.scheduler.entities.AbstractJob.getAction(AbstractJob.java:132)
<br> at net.datenwerke.rs.amazons3.service.amazons3.hooker.ScheduleConfigAsAmazonS3DatasinkHooker.adaptScheduleDefinition(ScheduleConfigAsAmazonS3DatasinkHooker.java:62)
<br> at net.datenwerke.rs.scheduler.server.scheduler.SchedulerRpcServiceImpl.lambda$5(SchedulerRpcServiceImpl.java:465)
<br> at net.datenwerke.rs.utils.exception.shared.LambdaExceptionUtil.lambda$0(LambdaExceptionUtil.java:56)
<br> at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
<br> at net.datenwerke.rs.scheduler.server.scheduler.SchedulerRpcServiceImpl.loadScheduleInformation(SchedulerRpcServiceImpl.java:464)
<br> at net.datenwerke.rs.scheduler.server.scheduler.SchedulerRpcServiceImpl.loadFullScheduleInformation(SchedulerRpcServiceImpl.java:418)
<br> at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)
<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br> at jdk.internal.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
<br> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
<br> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
<br> at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
<br> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br> at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)
<br> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)
<br> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)
<br> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)
<br> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)
<br> at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)
<br> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82)
<br> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)
<br> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)
<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
<br> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
<br> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
<br> at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433)
<br> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
<br> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
<br> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1787)
<br> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
<br> at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
<br> at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
<br> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
<br> at java.base/java.lang.Thread.run(Thread.java:829)
<br>Caused by: java.sql.SQLException: (conn=42) Too many tables; MariaDB can only use 61 tables in a join
<br> at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:297)
<br> at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:368)
<br> at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:137)
<br> at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:819)
<br> at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:758)
<br> at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:677)
<br> at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:620)
<br> at org.mariadb.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:93)
<br> at org.mariadb.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:276)
<br> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
<br> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
<br> ... 71 more
<br>
Offline
Could you show the full error message with the lines at the end? From what you have sent it says "71 more..."
Offline
Can you point out where can I see the rest of the error message?
Now im trying to schedule an example report from a fresh installation of RS 4.2.0.6066-0 with the same error.
Offline
What type of report is this?
Offline
A Dynamic List
Offline
Hi lreyes,
you can see the core error in the error message you posted:
Caused by: java.sql.SQLException: (conn=42) Too many tables; MariaDB can only use 61 tables in a join
Regards,
Eduardo
Offline
Hi Eduardo,
The problem is that this error is generated when I tried to schedule a report from the example reports that came with RS. I uninstalled RS and reinstalled it and when I tried to schedule the report the error message was the same. So this isnt a error related to the report definition or something that I configured. This happened to me with RS 4.2.0.6066-0. I downgraded to RS4.0.0-6055 with no error
Offline
Hi Ireyes and Eduardo,
I am also facing a similar issue using version RS4.2.0-6066 (2022-06-29-18-43-47) (Error: could not extract ResultSet). The job can be "created", but it cannot be viewed or edited as the error appears when clicking on the job.
Here is the full error message:
org.hibernate.exception.GenericJDBCException: could not extract ResultSet<br> at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)<br> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)<br> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)<br> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)<br> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)<br> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)<br> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)<br> at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:87)<br> at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:705)<br> at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:76)<br> at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)<br> at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2208)<br> at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:595)<br> at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264)<br> at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:591)<br> at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:149)<br> at org.hibernate.collection.internal.AbstractPersistentCollection$1.doWork(AbstractPersistentCollection.java:178)<br> at org.hibernate.collection.internal.AbstractPersistentCollection$1.doWork(AbstractPersistentCollection.java:163)<br> at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264)<br> at org.hibernate.collection.internal.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:162)<br> at org.hibernate.collection.internal.PersistentBag.isEmpty(PersistentBag.java:376)<br> at net.datenwerke.scheduler.service.scheduler.entities.AbstractJob.getAction(AbstractJob.java:132)<br> at net.datenwerke.rs.amazons3.service.amazons3.hooker.ScheduleConfigAsAmazonS3DatasinkHooker.adaptScheduleDefinition(ScheduleConfigAsAmazonS3DatasinkHooker.java:62)<br> at net.datenwerke.rs.scheduler.server.scheduler.SchedulerRpcServiceImpl.lambda$5(SchedulerRpcServiceImpl.java:465)<br> at net.datenwerke.rs.utils.exception.shared.LambdaExceptionUtil.lambda$0(LambdaExceptionUtil.java:56)<br> at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)<br> at net.datenwerke.rs.scheduler.server.scheduler.SchedulerRpcServiceImpl.loadScheduleInformation(SchedulerRpcServiceImpl.java:464)<br> at net.datenwerke.rs.scheduler.server.scheduler.SchedulerRpcServiceImpl.loadFullScheduleInformation(SchedulerRpcServiceImpl.java:418)<br> at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.base/java.lang.reflect.Method.invoke(Method.java:566)<br> at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)<br> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)<br> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)<br> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)<br> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)<br> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)<br> at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)<br> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82)<br> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)<br> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)<br> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:643)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)<br> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)<br> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)<br> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)<br> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)<br> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579)<br> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)<br> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)<br> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)<br> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)<br> at java.base/java.lang.Thread.run(Thread.java:834)<br>Caused by: java.sql.SQLException: Too many tables; MySQL can only use 61 tables in a join<br> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)<br> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)<br> at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)<br> at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)<br> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)<br> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)<br> ... 72 more<br>
Regards,
Johann
Last edited by Johann (2022-07-21 07:55:47)
Offline
In the meantime, how can we delete those scheduler jobs created?
Offline
We are facing the same problem.
The only way that worked for me was to use the terminal. https://reportserver.net/en/guides/admi … scheduler/.
Use the commands: scheduler list, scheduler remove and scheduler unschedule
Offline
Hi Ireyes,
Thank you for sharing! May I check where were you able to download ReportServer version 4.0.0 from? I can't seem to find it from the downloads page https://reportserver.net/en/download/#enterprise
Offline
Hi lreyes, hi Johann,
thanks for letting us know, we are also able to see this error in a standard Bitnami installation. We raised ticket RS-5957 and are looking into the issue.
Regards,
Eduardo
Offline
Is there a resolution or temporary workaround for the ticket RS-5957 ?
Offline
Hi,
we identified the problem, fixed it and will release new 4.1.0 and 4.2.0 patch versions during this week.
Regards,
Eduardo
Offline
Hi,
pls note we released a patch version of 4.1.0: 6067 solving this issue: https://forum.reportserver.net/viewtopi … 9794#p9794
We will release a 4.2.0 patch version shortly and update here as well.
Regards,
Eduardo
Offline
Hi,
pls note we also released 4.2.0-6068 patch solving this issue: https://forum.reportserver.net/viewtopi … 9796#p9796
Regards,
Eduardo
Offline
Thanks so much @eduardo! Do you know the process of how Bitnami ends up getting these updates so they can release to the AWS AMI? https://aws.amazon.com/marketplace/pp/p … oh23acf3iy
Offline
Hi iamakimmer,
normally the new versions are available at Bitnami after some days.
Regards,
Eduardo
Offline