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

Pentaho BI Platform Tracking | anikitin | 10 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    The MDX containing named set definition as member range fails in Mondrian 2.3.2.8944 (while succedes in MSAS 2000). Workaround: add curly braces over range statement. Example: 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(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: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.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: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.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

    Pentaho BI Platform Tracking | 10 years ago | anikitin
    mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1, column 19, token ':'
  2. 0

    The MDX containing named set definition as member range fails in Mondrian 2.3.2.8944 (while succedes in MSAS 2000). Workaround: add curly braces over range statement. Example: 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(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: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.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: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.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

    Pentaho BI Platform Tracking | 10 years ago | anikitin
    mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1, column 19, token ':'
  3. 0

    olap4j 0.9.3 Issue

    olap4j | 9 years ago | apptaro
    org.olap4j.OlapException: mondrian gave exception while parsing query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.olap.MondrianException

      Mondrian Error:Syntax error at line 1, column 19, token ':'

      at mondrian.resource.MondrianResource$_Def4.ex()
    2. mondrian.resource
      MondrianResource$_Def4.ex
      1. mondrian.resource.MondrianResource$_Def4.ex(MondrianResource.java:825)
      1 frame
    3. mondrian.olap
      Parser.syntax_error
      1. mondrian.olap.Parser.syntax_error(Parser.java:886)
      1 frame
    4. Xalan Java
      lr_parser.parse
      1. java_cup.runtime.lr_parser.parse(lr_parser.java:595)
      1 frame
    5. mondrian.olap
      Parser.do_action
      1. mondrian.olap.Parser.parseExpression(Parser.java:791)
      2. mondrian.olap.Parser.recursivelyParseExp(Parser.java:730)
      3. mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1359)
      4. mondrian.olap.Parser.do_action(Parser.java:685)
      4 frames
    6. Xalan Java
      lr_parser.parse
      1. java_cup.runtime.lr_parser.parse(lr_parser.java:569)
      1 frame
    7. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.Parser.parseInternal(Parser.java:755)
      2. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)
      3. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
      3 frames
    8. mondrian.web.servlet
      MDXQueryServlet.doGet
      1. mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:85)
      2. mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)
      2 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      2 frames
    10. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      8 frames
    11. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      4 frames
    12. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    13. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame