java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}'

Pentaho BI Platform Tracking | Jake Cornelius | 7 years ago
  1. 0

    Repro Path: Detach the ktr and save it to your .\pdi-ee\data-integration\samples\transformations directory (overwrite existing) Start spoon, do NOT connect to repository Import the sample from XML Open the table output step, click the SQL button and execute the sql for creating target table Run the transformation Right-click on the table output step and visualize in Analyzer Build a report with top 10 customers on rows, Sales as the only measure Change to stacked bar Open the Field Layout and drag the DealSize field onto color stack area - kaboom Note Error: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.px.yf(SourceFile:255) at com.pentaho.analyzer.content.a.yl.ab(SourceFile:207) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:145) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:254) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:77) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:87) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:157) ... 62 more Caused by: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:289) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:293) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:352) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:81) at com.pentaho.analyzer.report.ReportRequestService$mc.f(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:206) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1923) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:101) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1920) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:101) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.Formula.accept(Formula.java:110) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156) at mondrian.olap.Query.resolve(Query.java:580) at mondrian.olap.Query.resolve(Query.java:475) at mondrian.olap.Query.(Query.java:240) at mondrian.olap.Query.(Query.java:196) at mondrian.olap.Parser.makeQuery(Parser.java:877) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1771) at mondrian.olap.Parser.do_action(Parser.java:706) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:779) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:133) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:274) ... 11 more RefreshingAdding DEALSIZE Available fields (31) for:Model 1 CubeView Find: Showing 0NumberMONTH IDMSRPORDERLINENUMBERQTR IDQUANTITYORDEREDSALESText (Names, Categories, etc.)ADDRESSLINE1ADDRESSLINE2CITYCONTACTFIRSTNAMECONTACTLASTNAMECOUNTRYCUSTOMERNAMEDEALSIZEMONTH IDMSRPORDERDATEORDERLINENUMBERORDERNUMBERPHONEPOSTALCODEPRICEEACHPRODUCTCODEPRODUCTLINEQTR IDQUANTITYORDEREDSALESSTATESTATUSTERRITORYYEAR ID by Category Number - Text - Time A→Z

    Pentaho BI Platform Tracking | 7 years ago | Jake Cornelius
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}'
  2. 0

    Repro Path: Detach the ktr and save it to your .\pdi-ee\data-integration\samples\transformations directory (overwrite existing) Start spoon, do NOT connect to repository Import the sample from XML Open the table output step, click the SQL button and execute the sql for creating target table Run the transformation Right-click on the table output step and visualize in Analyzer Build a report with top 10 customers on rows, Sales as the only measure Change to stacked bar Open the Field Layout and drag the DealSize field onto color stack area - kaboom Note Error: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.px.yf(SourceFile:255) at com.pentaho.analyzer.content.a.yl.ab(SourceFile:207) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:145) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:254) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:77) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:87) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:157) ... 62 more Caused by: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:289) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:293) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:352) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:81) at com.pentaho.analyzer.report.ReportRequestService$mc.f(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:206) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1923) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:101) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1920) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:101) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.Formula.accept(Formula.java:110) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156) at mondrian.olap.Query.resolve(Query.java:580) at mondrian.olap.Query.resolve(Query.java:475) at mondrian.olap.Query.(Query.java:240) at mondrian.olap.Query.(Query.java:196) at mondrian.olap.Parser.makeQuery(Parser.java:877) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1771) at mondrian.olap.Parser.do_action(Parser.java:706) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:779) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:133) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:274) ... 11 more RefreshingAdding DEALSIZE Available fields (31) for:Model 1 CubeView Find: Showing 0NumberMONTH IDMSRPORDERLINENUMBERQTR IDQUANTITYORDEREDSALESText (Names, Categories, etc.)ADDRESSLINE1ADDRESSLINE2CITYCONTACTFIRSTNAMECONTACTLASTNAMECOUNTRYCUSTOMERNAMEDEALSIZEMONTH IDMSRPORDERDATEORDERLINENUMBERORDERNUMBERPHONEPOSTALCODEPRICEEACHPRODUCTCODEPRODUCTLINEQTR IDQUANTITYORDEREDSALESSTATESTATUSTERRITORYYEAR ID by Category Number - Text - Time A→Z

    Pentaho BI Platform Tracking | 7 years ago | Jake Cornelius
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{}'
  3. 0

    Topcount with total of all members

    Stack Overflow | 2 years ago
    mondrian.olap.MondrianException: Mondrian Error:No function matches signature '(<Set>, <Member>)'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC connection error while using mondrian

    Stack Overflow | 3 years ago | Dhanish Jose
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Connect string '@mondrian.webapp.connectString@=; Catalog='null'' must contain either 'Jdbc' or 'DataSource'
  6. 0

    As a report designer, i only know the role of the current user i am passing into the mondrian connect string. I do not have an idea of what restrictions this role is applying to the cube. It might make the whole cube unaccessible. Therefor it is required that mondrian can return valid error codes, indicating that there is nothing wrong with the query itself, but that the result returned is an empty result set because of role restrictions in stead of a "Failed to parse query" stack trace. Resolution of case http://jira.pentaho.com/browse/PRD-2211 is unpossible without this. To test : Use the samples\Operational Reports\Top N Analysis.prpt to test It uses samples\steelwheels.mondrian.xml Copy the attached steelwheels.mondrian.xml file. I have added 2 roles, None= nothing is allowed, NoLimitations = there are no restrictions. I have added a default role to the schema. <Schema name="SteelWheels" defaultRole="None"> If default role = NoLimitations everything works. If default role is None you get an error in stead of "no data". The error is also there if one of the hierarchies is hidden because of a role definition. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Failed to parse query 'with 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:393) 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:98) at java.lang.Thread.run(Unknown Source) ParentException: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'with 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:816) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:137) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:318) 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:98) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'with 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:816) at mondrian.olap.Parser.parseInternal(Parser.java:777) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:133) ... 5 more Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX cube 'SteelWheelsSales' not found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.Util.lookupCube(Util.java:832) at mondrian.olap.Query.<init>(Query.java:187) at mondrian.olap.Parser.makeQuery(Parser.java:870) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1764) at mondrian.olap.Parser.do_action(Parser.java:699) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:772) ... 6 more

    Pentaho BI Platform Tracking | 7 years ago | gunter rombauts
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'with 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]")) ) '

    1 unregistered visitors
    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:No function matches signature '{}'

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813)
      1 frame
    3. mondrian.olap
      ValidatorImpl.getDef
      1. mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:206)
      1 frame
    4. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1923)
      1 frame
    5. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:101)
      1 frame
    6. mondrian.olap
      ValidatorImpl.validate
      1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
      1 frame
    7. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1920)
      1 frame
    8. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:101)
      1 frame
    9. mondrian.olap
      Parser.do_action
      1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
      2. mondrian.olap.Formula.accept(Formula.java:110)
      3. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156)
      4. mondrian.olap.Query.resolve(Query.java:580)
      5. mondrian.olap.Query.resolve(Query.java:475)
      6. mondrian.olap.Query.<init>(Query.java:240)
      7. mondrian.olap.Query.<init>(Query.java:196)
      8. mondrian.olap.Parser.makeQuery(Parser.java:877)
      9. mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1771)
      10. mondrian.olap.Parser.do_action(Parser.java:706)
      10 frames
    10. Xalan Java
      lr_parser.parse
      1. java_cup.runtime.lr_parser.parse(lr_parser.java:569)
      1 frame
    11. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.Parser.parseInternal(Parser.java:779)
      2. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:133)
      3. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
      3 frames
    12. com.pentaho.analyzer
      ReportRequestService$mc.call
      1. com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:274)
      2. com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:293)
      3. com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:352)
      4. com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110)
      5. com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:81)
      6. com.pentaho.analyzer.report.ReportRequestService$mc.f(SourceFile:250)
      7. com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240)
      7 frames
    13. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      2. java.util.concurrent.FutureTask.run(Unknown Source)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      5. java.lang.Thread.run(Unknown Source)
      5 frames