mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )'

Pentaho BI Platform Tracking | Sulaiman Karmali | 4 years ago
  1. 0

    If I create a new report and select an analysis data-source and set the analysis file to steelwheels.mondrian.xml, select SampleData for connection and enter the sample query (see PRD-4027 for sample query), I get the following exception: ERROR] ExceptionDialog - ExceptionDialog.ERROR_0001 - UserError <org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )'>org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )' at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:587) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:680) ParentException: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:947) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:680) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: While parsing set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) ) at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:947) at mondrian.olap.Util.newInternal(Util.java:2261) at mondrian.olap.Util.newError(Util.java:2277) at mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:110) at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:59) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ... 7 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1, column 1, token 'set' at mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:99) ... 9 more

    Pentaho BI Platform Tracking | 4 years ago | Sulaiman Karmali
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )'
  2. 0

    If I create a new report and select an analysis data-source and set the analysis file to steelwheels.mondrian.xml, select SampleData for connection and enter the sample query (see PRD-4027 for sample query), I get the following exception: ERROR] ExceptionDialog - ExceptionDialog.ERROR_0001 - UserError <org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )'>org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )' at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:587) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:680) ParentException: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:947) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:680) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: While parsing set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) ) at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:947) at mondrian.olap.Util.newInternal(Util.java:2261) at mondrian.olap.Util.newError(Util.java:2277) at mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:110) at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:59) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ... 7 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1, column 1, token 'set' at mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:99) ... 9 more

    Pentaho BI Platform Tracking | 4 years ago | Sulaiman Karmali
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )'
  3. 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 | 9 years ago | anikitin
    mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1, column 19, token ':'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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 | 9 years ago | anikitin
    mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1, column 19, token ':'
  6. 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 | 9 years ago | anikitin
    mondrian.olap.MondrianException: Mondrian Error:Syntax error in MDX expression '[Product].[Drink]:[Product].[Food]'

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.olap.MondrianException

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

      at mondrian.parser.JavaccParserValidatorImpl.convertException()
    2. mondrian.parser
      JavaccParserValidatorImpl.parseInternal
      1. mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:99)
      2. mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:59)
      2 frames
    3. mondrian.olap
      ConnectionBase.parseStatement
      1. mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96)
      1 frame
    4. mondrian.rolap
      RolapConnection.parseStatement
      1. mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765)
      1 frame
    5. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55)
      1 frame
    6. org.pentaho.reporting
      MondrianPreviewWorker.run
      1. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444)
      2. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145)
      3. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54)
      4. org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99)
      4 frames
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:680)
      1 frame