Cannot use OLAP schema with a Hadoop Hive data source

Hello!

 

Even though I am using an OLAP schema file similar to the one that works for a JDBC data source (towards Oracle DB), this schema file is not recognized when using a Hadoop Hive datasource (which I successfully used to run static reports, by the way). When, in Jasper Reports Server, I try to use the cube definitions from the defined OLAP schema file inorder to create Ad Hoc reports (by clicking Create -> Ad Hoc Report -> OLAP Connections), I cannot see and choose the cubes under the Mondrian connection which I defined. As you may know, when the cubes do not appear there, this is a sign of error from Jasper.

 

The following error message appears in the Apache Tomcat log:

 

WARN OlapConnectionTreeProvider,http-8080-7:106 - Can not load information about OLAP cubes from OLAP connection: SHE_Connection_HADOOP

java.lang.ClassCastException: com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.client.CustomReportDataSourceImpl cannot be cast to com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.JndiJdbcReportDataSource

                at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.getMondrianConnectProperties(OlapConnectionServiceImpl.java:559)

                at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.getOlapConnectProperties(OlapConnectionServiceImpl.java:436)

                at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.getOlapConnection(OlapConnectionServiceImpl.java:713)

                at com.jaspersoft.ji.ja.security.service.SecureOlapConnectionServiceImpl.getOlapConnection(SecureOlapConnectionServiceImpl.java:215)

                at com.jaspersoft.ji.ja.security.service.SecureOlapConnectionServiceImpl.getOlapConnection(SecureOlapConnectionServiceImpl.java:192)

                at com.jaspersoft.ji.ja.security.service.LicenseCheckingOlapConnectionServiceImpl.getOlapConnection(LicenseCheckingOlapConnectionServiceImpl.java:53)

                at com.jaspersoft.ji.adhoc.action.tree.OlapConnectionTreeProvider.addCubesAsLeavesToNode(OlapConnectionTreeProvider.java:127)

                at com.jaspersoft.ji.adhoc.action.tree.OlapConnectionTreeProvider.cutNodeHierarchyToGivenDepth(OlapConnectionTreeProvider.java:104)

                at com.jaspersoft.ji.tree.BaseTreeDataProvider.getNode(BaseTreeDataProvider.java:72)

                at com.jaspersoft.jasperserver.war.action.tree.TreeAction.getChildren(TreeAction.java:155)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

                at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98)

                at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123)

                at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)

                at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)

                at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79)

                at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)

                at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145)

                at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)

                at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101)

                at org.springframework.webflow.engine.State.enter(State.java:194)

                at org.springframework.webflow.engine.Transition.execute(Transition.java:227)

                at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:51)

                at org.springframework.webflow.engine.State.enter(State.java:194)

                at org.springframework.webflow.engine.Flow.start(Flow.java:535)

                at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:364)

                at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:222)

                at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:140)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

                at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

                at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

                at $Proxy41.launchExecution(Unknown Source)

                at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193)

                at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174)

                at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

                at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)

                at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)

                at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)

                at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)

                at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154)

                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)

                at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)

                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:108)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:96)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)

                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180)

                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)

                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:81)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:83)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)

                at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

                at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)

                at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)

                at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)

                at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)

                at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

                at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)

                at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)

                at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)

                at java.lang.Thread.run(Thread.java:619)

 

 

I have no clue on what might be the cause of this problem.

 

Any help would be very much appreciated!

 

Best regards,

Marius Moldovan

marius19842003's picture
Joined: Oct 31 2012 - 10:26am
Last seen: 7 years 2 months ago

0 Answers:

No answers yet
Feedback