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

Pentaho BI Platform Tracking | anikitin | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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