[Mondrian] Bug: Named set + range

Anton Nikitin cybernelly at gmail.com
Tue Jul 10 10:55:55 EDT 2007


Just have found the following bug (version 2.3.2.8944).

Not sure about latest sources.

 

The following MDX fails (MSAS 2000 succeedes):

 

with set [Set1] as '[Product].[Drink]:[Product].[Food]' 

select [Set1] on columns, {[Measures].defaultMember} on rows 

from Sales

 

Result:

 

mondrian.olap.MondrianException: Mondrian Error:Syntax error in MDX
expression '[Product].[Drink]:[Product].[Food]'

      at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)

      at mondrian.olap.Parser.parseExpression(Parser.java:796)

      at mondrian.olap.Parser.recursivelyParseExp(Parser.java:730)

      at
mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1359)

      at mondrian.olap.Parser.do_action(Parser.java:685)

      at java_cup.runtime.lr_parser.parse(lr_parser.java:569)

      at mondrian.olap.Parser.parseInternal(Parser.java:755)

      at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)

      at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)

      at
mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:85)

      at
mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)

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

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

      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)

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

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

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

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

      at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

      at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:744)

      at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)

      at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)

      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)

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

Caused by: mondrian.olap.MondrianException: Mondrian Error:Syntax error at
line 1, column 19, token ':'

      at
mondrian.resource.MondrianResource$_Def4.ex(MondrianResource.java:825)

      at mondrian.olap.Parser.syntax_error(Parser.java:886)

      at java_cup.runtime.lr_parser.parse(lr_parser.java:595)

      at mondrian.olap.Parser.parseExpression(Parser.java:791)

      ... 25 more

mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1,
column 19, token ':'

      at
mondrian.resource.MondrianResource$_Def4.ex(MondrianResource.java:825)

      at mondrian.olap.Parser.syntax_error(Parser.java:886)

      at java_cup.runtime.lr_parser.parse(lr_parser.java:595)

      at mondrian.olap.Parser.parseExpression(Parser.java:791)

      at mondrian.olap.Parser.recursivelyParseExp(Parser.java:730)

      at
mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1359)

      at mondrian.olap.Parser.do_action(Parser.java:685)

      at java_cup.runtime.lr_parser.parse(lr_parser.java:569)

      at mondrian.olap.Parser.parseInternal(Parser.java:755)

      at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)

      at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)

      at
mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:85)

      at
mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)

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

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

      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)

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

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

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

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

      at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

      at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:744)

      at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)

      at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)

      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070710/ceed6aeb/attachment.html 


More information about the Mondrian mailing list