infofabrik/reportserver

ReportServer is a modern and versatile open source business intelligence (BI) platform with powerful reporting features. With ReportServer you are not limited to one provider's solutions. ReportServer integrates Jasper, Birt, Mondrian and Excel-based reporting: choose what best suits your needs!

ReportServer

ReportServer is a modern and versatile open source business intelligence (BI) platform with powerful reporting features.

With ReportServer you are not limited to one provider's solutions. ReportServer integrates Jasper, Birt, Mondrian and Excel-based reporting: choose what best suits your needs!

ReportServer Homepage: https://reportserver.net

Documentation: https://reportserver.net/en/documentation

Scripting samples: https://github.com/infofabrik/reportserver-samples

Demo: https://reportserver.net/en/demo/

Forum: https://forum.reportserver.net

Bitnami Builds: https://bitnami.com/stack/reportserver

reportserver's Issues

Project build setup

Team great work on this product. Do have any plan to add project build scripts; it seems the current project setup is integrated with Eclipse IDE.

Ant Ivy-based setup would be the ideal choice if the team chooses to stay with the offline build process.

RS4.2.0 Scheduled Jobs cannot be opened, executed, created or deleted

Hi, I am facing an 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>

Project build environment

Dear colleagues!
Thanks for your work!
Can you post the system requirements for building the project (preferred ide, java version, gwt version, etc.) and a quick guide?
Thank your!

Lib folder is missing

Appreciate your support, the lib folder is missing and when we try to download the dependencies from maven there is a list of missing jars:

'war/WEB-INF/lib/bcmail-jdk18on-1.71.jar'
'war/WEB-INF/lib/bcpg-jdk18on-1.71.jar'
'war/WEB-INF/lib/bcpkix-jdk18on-1.71.jar'
'war/WEB-INF/lib/bcprov-jdk18on-1.71.jar'
'war/WEB-INF/lib/bcutil-jdk18on-1.71.jar'
'war/WEB-INF/lib/gwt-servlet-2.8.2.jar' rep
'war/WEB-INF/lib/pfjgraphics.jar' reports
'war/WEB-INF/lib/rs-schemaupdate-1.3.18.jar'

Thanks