[Mondrian] Unicode character member name in MDX

Julian Hyde jhyde at pentaho.com
Fri Sep 4 02:31:36 EDT 2009


That's a question for the jpivot list!


  _____  

From: Mike Chen [mailto:chagel at gmail.com] 
Sent: Thursday, September 03, 2009 8:58 PM
To: jhyde at pentaho.com; Mondrian developer mailing list
Subject: Re: [Mondrian] Unicode character member name in MDX


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(OlapModelDecor
ator.java:132)
    at
com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.j
ava:77)
    at
com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateMana
ger.java:76)
    at
com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.ja
va: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:3
31)
    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(Application
FilterChain.java:269)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:265)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:124)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUs
erProcessingFilter.java:341)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(Securi
tyStartupFilter.java:85)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.
doFilter(RequestParameterAuthenticationFilter.java:169)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessin
gFilter.java:174)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:271)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFil
ter(HttpSessionReuseDetectionFilter.java:134)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:249)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.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(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFi
lter.java:139)
    at
com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchr
onizer.java:127)
    at
com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStat
usFilter.java:60)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(Se
tCharacterEncodingFilter.java:113)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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.processC
onnection(Http11BaseProtocol.java:665)
    at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)
    at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a: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(OlapModelDecor
ator.java:132)
    at
com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.j
ava:77)
    at
com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateMana
ger.java:76)
    at
com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.ja
va: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:3
31)
    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(Application
FilterChain.java:269)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:265)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:124)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUs
erProcessingFilter.java:341)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(Securi
tyStartupFilter.java:85)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.
doFilter(RequestParameterAuthenticationFilter.java:169)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessin
gFilter.java:174)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:271)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFil
ter(HttpSessionReuseDetectionFilter.java:134)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:249)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.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(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFi
lter.java:139)
    at
com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchr
onizer.java:127)
    at
com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStat
usFilter.java:60)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(Se
tCharacterEncodingFilter.java:113)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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.processC
onnection(Http11BaseProtocol.java:665)
    at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)
    at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a: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(OlapModelDecor
ator.java:132)
    at
com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.j
ava:77)
    at
com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateMana
ger.java:76)
    at
com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.ja
va: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:3
31)
    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(Application
FilterChain.java:269)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:265)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:124)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUs
erProcessingFilter.java:341)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(Securi
tyStartupFilter.java:85)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.
doFilter(RequestParameterAuthenticationFilter.java:169)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessin
gFilter.java:174)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:271)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFil
ter(HttpSessionReuseDetectionFilter.java:134)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:249)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.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(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFi
lter.java:139)
    at
com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchr
onizer.java:127)
    at
com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStat
usFilter.java:60)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(Se
tCharacterEncodingFilter.java:113)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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.processC
onnection(Http11BaseProtocol.java:665)
    at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)
    at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a: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:3
31)
    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(Application
FilterChain.java:269)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:265)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
    at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:124)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUs
erProcessingFilter.java:341)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(Securi
tyStartupFilter.java:85)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.
doFilter(RequestParameterAuthenticationFilter.java:169)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessin
gFilter.java:174)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:271)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFil
ter(HttpSessionReuseDetectionFilter.java:134)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:249)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:275)
    at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
    at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.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(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFi
lter.java:139)
    at
com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchr
onizer.java:127)
    at
com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStat
usFilter.java:60)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(Se
tCharacterEncodingFilter.java:113)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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.processC
onnection(Http11BaseProtocol.java:665)
    at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)
    at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a: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/20090903/979c96fe/attachment.html 


More information about the Mondrian mailing list