#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.
QQ20180312_083906.jpg
QQ20180312_084021.jpg

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.
Wechat_IMG50.jpg

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

Board footer

Powered by FluxBB