java.lang.RuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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
    via by Jake Cornelius,
  • 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
    via by Jake Cornelius,
  • Topcount with total of all members
    via by Unknown author,
  • 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
    via by gunter rombauts,
  • run the attached report. The error message = unable to initialize the report. No stack trace with an explanation. Change the de default value of param1 to "param1" without quotes. Look at the parameter part in the MDX : Parameter("param1", STRING, "param1") It replaces the wrong part!!!!!!!!!!!! The stack trace now is as follows: org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:482) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:354) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1466) at mondrian.olap.Util.newError(Util.java:1482) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:592) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:345) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) Caused by: mondrian.olap.MondrianException: Mondrian Error:Member '[param1]' not found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.Util.lookupCompound(Util.java:639) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:386) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:108) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1508) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1469) at mondrian.olap.fun.BuiltinFunTable$22.strToMember(BuiltinFunTable.java:725) at mondrian.olap.fun.BuiltinFunTable$22$1.evaluateMember(BuiltinFunTable.java:715) at mondrian.olap.fun.SetFunDef$MemberSetListCalc$2.evaluateVoid(SetFunDef.java:173) at mondrian.olap.fun.SetFunDef$MemberSetListCalc.evaluateMemberList(SetFunDef.java:190) at mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87) at mondrian.rolap.RolapNativeSet.expandNonNative(RolapNativeSet.java:826) at mondrian.rolap.RolapNativeSet.checkCrossJoin(RolapNativeSet.java:804) at mondrian.rolap.RolapNativeCrossJoin.createEvaluator(RolapNativeCrossJoin.java:86) at mondrian.rolap.RolapNativeRegistry.createEvaluator(RolapNativeRegistry.java:55) at mondrian.rolap.RolapSchemaReader.getNativeSetEvaluator(RolapSchemaReader.java:566) at mondrian.olap.DelegatingSchemaReader.getNativeSetEvaluator(DelegatingSchemaReader.java:220) at mondrian.olap.fun.CrossJoinFunDef$BaseTupleIterCalc.evaluateTupleIterable(CrossJoinFunDef.java:253) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:570) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:536) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:563) ... 14 more
    via by gunter rombauts,
  • Create a working prpt that uses a database connection. I created one of type jdbc/jndi. Make sure is is not one of the default connections. Open this prpt on a PC that has never run the designer. You will get the error below. Please add decent error dialog. java.lang.RuntimeException: Database type [null] not found! at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:494) at org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.setData(XulDatabaseDialog.java:200) at org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.open(XulDatabaseDialog.java:211) at org.pentaho.reporting.ui.datasources.jdbc.ui.ConnectionPanel$EditDataSourceAction.actionPerformed(ConnectionPanel.java:160) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6263) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1045) at java.awt.Dialog$3.run(Dialog.java:1097) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1095) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:985) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcDataSourceDialog.performConfiguration(JdbcDataSourceDialog.java:624) at org.pentaho.reporting.ui.datasources.jdbc.JdbcDataSourcePlugin.performEdit(JdbcDataSourcePlugin.java:67) at org.pentaho.reporting.designer.core.actions.report.EditQueryAction.performEdit(EditQueryAction.java:147) at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:140) at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253) at java.awt.Component.processMouseEvent(Component.java:6266) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: database type [null] couldn't be found! at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:418) at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:397) at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:490) ... 60 more org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:482) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Virtual file is not readable: cmc/sales/mondrian_cube_definitions/sales_budget.mondrian.xml at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:255) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: cmc/sales/mondrian_cube_definitions/sales_budget.mondrian.xml at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.Util.newInternal(Util.java:1459) at mondrian.olap.Util.newError(Util.java:1474) at mondrian.olap.Util.readVirtualFile(Util.java:2215) at mondrian.rolap.RolapSchema.load(RolapSchema.java:283) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:237) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:72) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:970) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:781) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:170) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:92) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:246) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)
    via by gunter rombauts,
  • Pentaho Reporting / Mailing Lists
    via by Unknown author,
  • run the attached report. The error message = unable to initialize the report. No stack trace with an explanation. Change the de default value of param1 to "param1" without quotes. Look at the parameter part in the MDX : Parameter("param1", STRING, "param1") It replaces the wrong part!!!!!!!!!!!! The stack trace now is as follows: org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:482) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:354) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select Crossjoin({StrToMember(Parameter("param1", STRING, "param1"))}, {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON ROWS from [SteelWheelsSales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1466) at mondrian.olap.Util.newError(Util.java:1482) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:592) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:345) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DenormalizedMDXDataFactory.queryData(DenormalizedMDXDataFactory.java:51) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) Caused by: mondrian.olap.MondrianException: Mondrian Error:Member '[param1]' not found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.Util.lookupCompound(Util.java:639) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:386) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:108) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1508) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1469) at mondrian.olap.fun.BuiltinFunTable$22.strToMember(BuiltinFunTable.java:725) at mondrian.olap.fun.BuiltinFunTable$22$1.evaluateMember(BuiltinFunTable.java:715) at mondrian.olap.fun.SetFunDef$MemberSetListCalc$2.evaluateVoid(SetFunDef.java:173) at mondrian.olap.fun.SetFunDef$MemberSetListCalc.evaluateMemberList(SetFunDef.java:190) at mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87) at mondrian.rolap.RolapNativeSet.expandNonNative(RolapNativeSet.java:826) at mondrian.rolap.RolapNativeSet.checkCrossJoin(RolapNativeSet.java:804) at mondrian.rolap.RolapNativeCrossJoin.createEvaluator(RolapNativeCrossJoin.java:86) at mondrian.rolap.RolapNativeRegistry.createEvaluator(RolapNativeRegistry.java:55) at mondrian.rolap.RolapSchemaReader.getNativeSetEvaluator(RolapSchemaReader.java:566) at mondrian.olap.DelegatingSchemaReader.getNativeSetEvaluator(DelegatingSchemaReader.java:220) at mondrian.olap.fun.CrossJoinFunDef$BaseTupleIterCalc.evaluateTupleIterable(CrossJoinFunDef.java:253) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:727) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:570) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:536) at mondrian.rolap.RolapResult.<init>(RolapResult.java:269) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:563) ... 14 more
    via by gunter rombauts,
  • Create a working prpt that uses a database connection. I created one of type jdbc/jndi. Make sure is is not one of the default connections. Open this prpt on a PC that has never run the designer. You will get the error below. Please add decent error dialog. java.lang.RuntimeException: Database type [null] not found! at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:494) at org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.setData(XulDatabaseDialog.java:200) at org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.open(XulDatabaseDialog.java:211) at org.pentaho.reporting.ui.datasources.jdbc.ui.ConnectionPanel$EditDataSourceAction.actionPerformed(ConnectionPanel.java:160) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6263) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1045) at java.awt.Dialog$3.run(Dialog.java:1097) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1095) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:985) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcDataSourceDialog.performConfiguration(JdbcDataSourceDialog.java:624) at org.pentaho.reporting.ui.datasources.jdbc.JdbcDataSourcePlugin.performEdit(JdbcDataSourcePlugin.java:67) at org.pentaho.reporting.designer.core.actions.report.EditQueryAction.performEdit(EditQueryAction.java:147) at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:140) at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253) at java.awt.Component.processMouseEvent(Component.java:6266) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6028) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: database type [null] couldn't be found! at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:418) at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:397) at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:490) ... 60 more org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:482) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Virtual file is not readable: cmc/sales/mondrian_cube_definitions/sales_budget.mondrian.xml at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:255) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: cmc/sales/mondrian_cube_definitions/sales_budget.mondrian.xml at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813) at mondrian.olap.Util.newInternal(Util.java:1459) at mondrian.olap.Util.newError(Util.java:1474) at mondrian.olap.Util.readVirtualFile(Util.java:2215) at mondrian.rolap.RolapSchema.load(RolapSchema.java:283) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:237) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:72) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:970) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:781) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:170) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:92) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:246) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:81) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:265) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:389) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)
    via by gunter rombauts,
    • 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.<init>(Query.java:240) at mondrian.olap.Query.<init>(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

    Users with the same issue

    Unknown visitor1 times, last one,