Error in Analysis View

clarenz · May 15, 2009

I am facing a problem when i view my own created analysis view.

Prior to that... these are the steps i took:

1. I successfully created my schema using JasperAnalysis Schema Workbench.

2. Created and added new datasource, mondrian connection and my own schema into the JasperServer using the user interface.

3. OLAP connection and schema validated without errors.

MY SCHEMA

When i click to view my analysis view, this error shows :

java.lang.NoSuchMethodError: mondrian.olap.fun.FunUtil.addAll(Ljava/util/List;[Ljava/lang/Object;)V

java.lang.NoSuchMethodError: mondrian.olap.fun.FunUtil.addAll(Ljava/util/List;[Ljava/lang/Object;)V	at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:269)	at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:259)	at mondrian.olap.fun.FunUtil.hierarchyMembers(FunUtil.java:1851)	at mondrian.olap.fun.FunUtil.dimensionMembers(FunUtil.java:1868)	at mondrian.olap.fun.BuiltinFunTable$35$1.evaluateList(BuiltinFunTable.java:991)	at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:67)	at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:694)	at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:557)	at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:532)	at mondrian.rolap.RolapResult.<init>(RolapResult.java:254)	at mondrian.rolap.RolapConnection.execute(RolapConnection.java:597)	at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:295)	at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)	at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:49)	at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)	at sun.reflect.GeneratedMethodAccessor303.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)	at java.lang.reflect.Method.invoke(Unknown Source)	at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)	at org.apache.el.parser.AstValue.getValue(AstValue.java:114)	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)	at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f5(viewOlap_jsp.java:2765)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:413)	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127)	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56)	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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)	at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142)	at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247)	at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141)	at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)	at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281)	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.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)	at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:142)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)	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:70)	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)	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:175)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)	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:286)	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)	at java.lang.Thread.run(Unknown Source)

Someone please help me out on this... thanks!

swood · May 16, 2009

Strange. Can you show the MDX in the view?

Sherman

Jaspersoft

esiravegna · July 17, 2009

I'm facing exactly the same problem...

My Schema:

<Schema name="Results Test">
<Cube name="Conversion" caption="Conversion Cube" cache="true" enabled="true">
    <Table name="ConversionsCube" alias="Conversions">
    </Table>
    <Dimension type="StandardDimension" foreignKey="Placement" name="Placement">
      <Hierarchy hasAll="true" primaryKey="Placement">
        <Table name="ConversionsCube">
        </Table>
        <Level name="PLC" column="Placement" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
      </Hierarchy>
    </Dimension>
    <Measure name="View Conversions" column="ViewConv" datatype="Integer" aggregator="sum" visible="true">
    </Measure>
    <Measure name="Click Conversions" column="ClckConv" datatype="Integer" aggregator="sum" visible="true">
    </Measure>
    <Measure name="M1" column="M1" aggregator="sum" visible="true">
    </Measure>
</Cube>
</Schema>

And MDX:

SELECT [Measures].AllMembers ON COLUMNS,
Hierarchize([Placement].[All Placements].Children) ON ROWS
FROM [Conversion];

Any ideas are greately appreciated. THanks!

esiravegna · July 20, 2009

Got it solved. It seems that the exception was throwed because of the .AllMember thingie....I'll further investigate.

wolly · July 21, 2009

esiravegna

Can you expand on your solution and how the AllMember property was causing this issue?

Regards

Wolly

deaves · October 2, 2009

This looks to be related to:

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=62418#64719

See the above thread for a workaround.

Regards,

Dave

swood · December 1, 2009

See this for a fix http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4247

Sherman

Jaspersoft

Sign In

Error in Analysis View

Recommended Posts

clarenz

java.lang.NoSuchMethodError: mondrian.olap.fun.FunUtil.addAll(Ljava/util/List;[Ljava/lang/Object;)V

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

swood

Link to comment

Share on other sites

esiravegna

Link to comment

Share on other sites

esiravegna

Link to comment

Share on other sites

wolly

Link to comment

Share on other sites

deaves

Link to comment

Share on other sites

swood

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore