You are not logged in.
- Topics: Active | Unanswered
Announcement
Migration of this forum
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
- Each user will need to reset their password.
- Please select "I forgot my password".
- Enter the email address you used to register in this forum.
- You will receive an email with a link to set a new password.
- Please choose a new (secure) password and confirm the process.
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Migration des Forums
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
- Jeder Nutzer muss sein Passwort neu vergeben.
- Wählt dazu einfach "Ich habe mein Passwort vergessen".
- Gebt die E-Mail-Adresse ein, mit der ihr registriert seid.
- Ihr erhaltet eine E-Mail mit einem Link zur Passwortvergabe.
- Bitte wählt ein neues (sicheres) Passwort und bestätigt den Vorgang.
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
Pages: 1
#1 2018-03-09 05:59:28
- xtlyk
- Member
- Registered: 2018-03-09
SaiKu report ERROR!
Hi everyone:
The message from China.
I had install RepotServer with Bitnami Installers : bitnami-reportserver-3.0.3-1-linux-x64-installer.run .
I got a ERROR when creat SaiKu Report . Like this:
09-Mar-2018 13:52:49.892 INFO [ajp-apr-8009-exec-2] net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.<init> loaded olap util service
09-Mar-2018 13:52:49.903 SEVERE [ajp-apr-8009-exec-2] net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
java.lang.ClassCastException: net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasource cannot be cast to net.datenwerke.rs.saiku.service.datasource.MondrianDatasource
at net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getCube(OlapUtilServiceImpl.java:87)
at net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:119)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
09-Mar-2018 13:52:49.905 SEVERE [ajp-apr-8009-exec-2] com.sun.jersey.spi.container.ContainerResponse.mapMappableContainerException The RuntimeException could not be mapped to a response, re-throwing to the HTTP container
java.lang.RuntimeException: java.lang.ClassCastException: net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasource cannot be cast to net.datenwerke.rs.saiku.service.datasource.MondrianDatasource
at net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassCastException: net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasource cannot be cast to net.datenwerke.rs.saiku.service.datasource.MondrianDatasource
at net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getCube(OlapUtilServiceImpl.java:87)
at net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:119)
... 50 more
Can anyone help me？
Think you very much！
from： MarsLiu
Offline
#2 2018-03-09 06:55:10
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: SaiKu report ERROR!
Hi MarsLiu,
welcome to the reportserver forum.
Could you please post the exact reportserver version installed? You can check this in your license administration page (administration -> license management).
Regards,
Eduardo
Offline
#3 2018-03-09 07:12:58
- xtlyk
- Member
- Registered: 2018-03-09
Re: SaiKu report ERROR!
Hi Eduardo,
The reportserver version ：
Version: RS3.0.3-6002 (2017-12-09-12-26-19).
Thanks.
Regards,
MarsLiu
Offline
#4 2018-03-09 07:22:24
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: SaiKu report ERROR!
Hi MarsLiu,
is this happening with all pivot reports ? Could you check with a simple dynamic list -> pivot ? Could you please post some screenshots?
Regards,
Eduardo
Offline
#5 2018-03-09 07:43:29
- xtlyk
- Member
- Registered: 2018-03-09
Re: SaiKu report ERROR!
Hi Eduardo,
dynamic list working normally.
This flow is ok:
Administration -> Reports -> Insert -> SaiKu Report -> name: TEST
It show Loading datasources.... when i double click TEST, and server log like "#1"
I don't know how to post screenshots...
Regards,
MarsLiu
Offline
#6 2018-03-09 08:12:14
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: SaiKu report ERROR!
Hi MarsLiu,
Did you select a datasource for your saiku report?
If not, I get another error:
java.lang.RuntimeException: java.lang.NullPointerException
But this is correct, you have to select a datasource.
If yes, which datasource did you select?
Regards,
Eduardo
Offline
#7 2018-03-09 08:43:13
- xtlyk
- Member
- Registered: 2018-03-09
Re: SaiKu report ERROR!
Hi Eduardo,
I had select a datasource (Type: Mysql ), and same to dynamic list .
I had set a Sql Query, and same to dynamic list too.
Dynamic list working normally.
System version：
CentOS release 6.9 (Final)
Regards,
MarsLiu
Last edited by xtlyk (2018-03-09 08:49:03)
Offline
#8 2018-03-09 09:35:32
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: SaiKu report ERROR!
Hi MarsLiu,
For saiku reports you can only select cube datasources. Not "normal" relational datasources. So you cannot be using the same datasource for a dynamic list and a saiku report.
Or are we talking about pivot reports? You can convert any dynamic list into a pivot report by clicking the "Pivot" button.
You can post screenshots here by uploading them to any img server e.g. https://imgbb.com/ and then posting the image links here.
Regards,
Eduardo
Offline
#9 2018-03-12 00:53:41
- xtlyk
- Member
- Registered: 2018-03-09
Re: SaiKu report ERROR!
Hi Eduardo,
The last two days were weekends, and I didn't go online.
My datasources is MYSQL.
I didn't found "Pivot" button.
Offline
#10 2018-03-12 03:21:43
- xtlyk
- Member
- Registered: 2018-03-09
Re: SaiKu report ERROR!
Hi Eduardo,
There's no Pivot at my "Dynamic Lists" page.
Thanks.
Regards,
MarsLiu
Offline
#11 2018-03-13 10:20:21
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: SaiKu report ERROR!
Hi xtlyk,
in the screenshots I can see some problems:
1. You have a Saiku report, and are trying to write a relational query. This is not possible, since Saiku reports work with cubes. The sql queries are hidden behind the cubes. So you have to select a cube/mondrian datasource and select the respective cube. You can read here about Saiku reports and how to configure them: https://reportserver.net/en/guides/admi … a-Sources/ , section 4.8 (Mondrian Datasources).
2. You have a community edition. That's why you cannot see the "pivot" button. You have to install the enterprise (evaluation) for this. You can see a comparison of the editions here: https://reportserver.net/en/pricing/
3. In your screenshots I see you clicked the "default" datasource and it changed to a relational datasource, showing you the query. This is a bug, since, as I explained in 1., you don't have relational datasources with Saiku reports (only with pivot reports). I opened RS-2890 for this purpose. The button should not be clickable in Saiku Reports.
Regards,
Eduardo
Offline
Pages: 1