[Mondrian] Unicode character member name in MDX

Mike Chen chagel at gmail.com
Thu Sep 3 23:57:35 EDT 2009


Thanks for your reply.
I checked the modrian sql log, and you are right about the problem.
Now I add "useUnicode=true&characterEncoding=UTF-8" in my JDBC data source
connection, and it works like a charm!

However, I still have problems on jpivot diagram.
Eastern characters can't display correctly on diagram of analysis view. Is
there any suggestion for this?

Regards,
-Mike


2009/9/4 Julian Hyde <jhyde at pentaho.com>

>  It's possible that your JDBC driver isn't handling Unicode data
> correctly. Turn on SQL tracing, see what SQL queries Mondrian sends to the
> database, and see how many rows come back.
>
> Julian
>
>  ------------------------------
> *From:* mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> *On Behalf Of *Mike Chen
> *Sent:* Thursday, September 03, 2009 1:42 AM
> *To:* mondrian at pentaho.org
> *Subject:* [Mondrian] Unicode character member name in MDX
>
> Hi,
>
> I am new to Pentaho and Mondrian, and meet this problem when open my saved
> analysis view in Pentaho user console.
> This analysis view worked fine when I slice English members on rows, but it
> fails to open when I select some members with Chinese characters.
> It's probably a simple unicode support configuration, but I don't have a
> clue right now. I'll appreciate if anybody may tell me how to resolve this?
> Thanks.
>
> Error log here:
>
> --------------------------------------------------------------------------------------
> 16:10:25,280 ERROR [MondrianModel] Parse Failure
> mondrian.olap.MondrianException: Mondrian Error:Failed to parse query '
>
>     select NON EMPTY {([Time].[2009].[September].[2009-09-03],
> [Measures].[Income])} ON COLUMNS,
>   NON EMPTY Crossjoin({[Player].[All Players].[5].[4].[Quake],
> [Player].[All Players].[5].[4].[美年达], [Player].[All Players].[5].[4].[金银妖瞳],
> [Player].[All Players].[5].[4].[mike]}, {[Resource].[All Resources],
> [Resource].[All Resources].[Crystal], [Resource].[All Resources].[Gem],
> [Resource].[All Resources].[Gold], [Resource].[All Resources].[Mercury],
> [Resource].[All Resources].[Ore], [Resource].[All Resources].[Sulfur],
> [Resource].[All Resources].[Wood]}) ON ROWS
> from [Resource]
>
>
> '
>     at
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
>     at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134)
>     at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
>     at
> com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:579)
>     at
> com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:546)
>     at
> com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
>     at
> com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
>     at
> com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
>     at
> com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
>     at
> com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
>     at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:818)
>     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
>     at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
>     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
>     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:275)
>     at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>     at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
>     at
> com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
>     at
> com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
>     at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>     at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>     at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>     at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>     at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>     at java.lang.Thread.run(Thread.java:619)
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while
> parsing MDX statement '
>
>     select NON EMPTY {([Time].[2009].[September].[2009-09-03],
> [Measures].[Income])} ON COLUMNS,
>   NON EMPTY Crossjoin({[Player].[All Players].[5].[4].[Quake],
> [Player].[All Players].[5].[4].[美年达], [Player].[All Players].[5].[4].[金银妖瞳],
> [Player].[All Players].[5].[4].[mike]}, {[Resource].[All Resources],
> [Resource].[All Resources].[Crystal], [Resource].[All Resources].[Gem],
> [Resource].[All Resources].[Gold], [Resource].[All Resources].[Mercury],
> [Resource].[All Resources].[Ore], [Resource].[All Resources].[Sulfur],
> [Resource].[All Resources].[Wood]}) ON ROWS
> from [Resource]
>
>
> '
>     at
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
>     at mondrian.olap.Parser.parseInternal(Parser.java:772)
>     at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129)
>     ... 73 more
> Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object
> '[Player].[All Players].[5].[4].[美年达]' not found in cube 'Resource'
>     at
> mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802)
>     at mondrian.olap.Util.lookup(Util.java:775)
>     at mondrian.olap.Id.accept(Id.java:105)
>     at mondrian.olap.Query$StackValidator.validate(Query.java:1260)
>     at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1681)
>     at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:99)
>     at mondrian.olap.Query$StackValidator.validate(Query.java:1260)
>     at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1681)
>     at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:99)
>     at mondrian.olap.Query$StackValidator.validate(Query.java:1260)
>     at mondrian.olap.QueryAxis.resolve(QueryAxis.java:198)
>     at mondrian.olap.Query$StackValidator.validate(Query.java:1320)
>     at mondrian.olap.Query.resolve(Query.java:574)
>     at mondrian.olap.Query.resolve(Query.java:429)
>     at mondrian.olap.Query.<init>(Query.java:226)
>     at mondrian.olap.Query.<init>(Query.java:183)
>     at mondrian.olap.Parser.makeQuery(Parser.java:863)
>     at
> mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1696)
>     at mondrian.olap.Parser.do_action(Parser.java:694)
>     at java_cup.runtime.lr_parser.parse(lr_parser.java:569)
>     at mondrian.olap.Parser.parseInternal(Parser.java:767)
>     ... 74 more
> 16:10:25,282 ERROR [MondrianModel] Mondrian Error:MDX object '[Player].[All
> Players].[5].[4].[美年达]' not found in cube 'Resource'
> 16:10:25,282 ERROR [OlapModelProxy]
> com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:MDX object
> '[Player].[All Players].[5].[4].[美年达]' not found in cube 'Resource'
>     at
> com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:550)
>     at
> com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
>     at
> com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
>     at
> com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
>     at
> com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
>     at
> com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
>     at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:818)
>     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
>     at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
>     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
>     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:275)
>     at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>     at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
>     at
> com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
>     at
> com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
>     at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>     at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>     at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>     at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>     at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>     at java.lang.Thread.run(Thread.java:619)
> 16:10:25,283 ERROR [OlapModelTag]
> com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:MDX object
> '[Player].[All Players].[5].[4].[美年达]' not found in cube 'Resource'
>     at
> com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:550)
>     at
> com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
>     at
> com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
>     at
> com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
>     at
> com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
>     at
> com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
>     at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:818)
>     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
>     at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
>     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
>     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:275)
>     at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>     at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
>     at
> com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
>     at
> com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
>     at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>     at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>     at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>     at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>     at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>     at java.lang.Thread.run(Thread.java:619)
> javax.servlet.jsp.JspException: Mondrian Error:MDX object '[Player].[All
> Players].[5].[4].[美年达]' not found in cube 'Resource'
>     at
> com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:86)
>     at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:818)
>     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
>     at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
>     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
>     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:275)
>     at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
>     at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
>     at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>     at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
>     at
> com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
>     at
> com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
>     at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>     at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>     at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>     at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>     at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>     at java.lang.Thread.run(Thread.java:619)
>
> Regards,
> -Mike
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090904/be26e5df/attachment.html 


More information about the Mondrian mailing list