You are not logged in.
- Topics: Active | Unanswered
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
- 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
- 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
- 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
- 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
- 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