mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant

Pentaho BI Platform Tracking | Matt Campbell | 3 years ago
  1. 0

    The attached schema causes the error below during load in Mondrian 4.0. The <View> element has a <SQL> child defined with dialect="generic". It will load without issue in 3.x. {noformat} mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:979) at mondrian.olap.Util.newInternal(Util.java:2470) at mondrian.olap.Util.newError(Util.java:2485) at mondrian.olap.MondrianDef$SQL.choose(MondrianDef.java:2900) at mondrian.rolap.RolapSchemaLoader.registerView(RolapSchemaLoader.java:984) at mondrian.rolap.RolapSchemaLoader.validatePhysicalSchema(RolapSchemaLoader.java:724) at mondrian.rolap.RolapSchemaLoader.loadStage2(RolapSchemaLoader.java:364) at mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:324) at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:260) at mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4126) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:163) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:112) at mondrian.test.TestContext.getConnection(TestContext.java:394) at mondrian.test.TestContext.executeQuery(TestContext.java:710) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:1349) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:1366) at mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:110) at mondrian.test.BasicQueryTest.testQ(BasicQueryTest.java:7767) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at com.intellij.junit3.JUnit3IdeaTestRunner.doRun(JUnit3IdeaTestRunner.java:139) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:63) {noformat}

    Pentaho BI Platform Tracking | 3 years ago | Matt Campbell
    mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant
  2. 0

    The attached schema causes the error below during load in Mondrian 4.0. The <View> element has a <SQL> child defined with dialect="generic". It will load without issue in 3.x. {noformat} mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:979) at mondrian.olap.Util.newInternal(Util.java:2470) at mondrian.olap.Util.newError(Util.java:2485) at mondrian.olap.MondrianDef$SQL.choose(MondrianDef.java:2900) at mondrian.rolap.RolapSchemaLoader.registerView(RolapSchemaLoader.java:984) at mondrian.rolap.RolapSchemaLoader.validatePhysicalSchema(RolapSchemaLoader.java:724) at mondrian.rolap.RolapSchemaLoader.loadStage2(RolapSchemaLoader.java:364) at mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:324) at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:260) at mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4126) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:163) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:112) at mondrian.test.TestContext.getConnection(TestContext.java:394) at mondrian.test.TestContext.executeQuery(TestContext.java:710) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:1349) at mondrian.test.TestContext.assertQueryReturns(TestContext.java:1366) at mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:110) at mondrian.test.BasicQueryTest.testQ(BasicQueryTest.java:7767) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at com.intellij.junit3.JUnit3IdeaTestRunner.doRun(JUnit3IdeaTestRunner.java:139) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:63) {noformat}

    Pentaho BI Platform Tracking | 3 years ago | Matt Campbell
    mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant
  3. 0

    Please see attached video and logs showing the issue: https://pentaho.box.com/s/zc7bwoqtnmuty6wgtbl8p8br9vl6kuwl The following dimension has been declared for the Foodmart in Infobright {noformat} <Dimension type="StandardDimension" visible="true" foreignKey="customer_id" highCardinality="false" name="Gender Using View"> <Hierarchy visible="true" hasAll="true" primaryKey="customer_id"> <View alias="GenderView"> <SQL dialect="infobright"> <![CDATA[Select distinct customer_id, gender from customer]]> </SQL> </View> <Level name="Gender" visible="true" column="gender" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> {noformat} Notice this line: *<SQL dialect="infobright">* This is the dimension as declared for MySQL {noformat} <Dimension type="StandardDimension" visible="true" foreignKey="customer_id" highCardinality="false" name="Gender using VIEW"> <Hierarchy visible="true" hasAll="true" primaryKey="customer_id"> <View alias="GenderView"> <SQL dialect="mysql"> <![CDATA[Select customer_id, gender from customer]]> </SQL> </View> <Level name="Gender" visible="true" column="gender" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> {noformat} Please note that when moving Gender from the MySQL based schema the report works. When dragging Gender from the Infobright based schema the report breaks with the following stack trace: {noformat} ERROR [com.pentaho.analyzer.b.c] Exception in AJAX handler. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:156) at com.pentaho.analyzer.content.controller.b.b(SourceFile:202) at com.pentaho.analyzer.content.AnalyzerContentGenerator.a(SourceFile:311) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:157) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:236) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:163) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) 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:411) 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:411) 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:411) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:189) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 85 more Caused by: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:320) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:139) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:979) at mondrian.olap.Util.newInternal(Util.java:2403) at mondrian.olap.Util.newError(Util.java:2418) at mondrian.rolap.sql.SqlQuery$CodeSet.chooseQuery(SqlQuery.java:1010) at mondrian.rolap.sql.SqlQuery.addFrom(SqlQuery.java:357) at mondrian.rolap.RolapHierarchy.addToFrom(RolapHierarchy.java:670) at mondrian.rolap.SqlTupleReader.addLevelMemberSql(SqlTupleReader.java:1127) at mondrian.rolap.SqlTupleReader.generateSelectForLevels(SqlTupleReader.java:938) at mondrian.rolap.SqlTupleReader.makeLevelMembersSql(SqlTupleReader.java:863) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:405) at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:530) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:259) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:193) at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:118) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:112) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:202) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:976) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:801) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:757) at mondrian.rolap.RolapResult.<init>(RolapResult.java:401) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) ... 4 more {noformat} There are no views using the Generic dialect

    Pentaho BI Platform Tracking | 8 months ago | Carlos Lopez
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Please see attached video and logs showing the issue: https://pentaho.box.com/s/zc7bwoqtnmuty6wgtbl8p8br9vl6kuwl The following dimension has been declared for the Foodmart in Infobright {noformat} <Dimension type="StandardDimension" visible="true" foreignKey="customer_id" highCardinality="false" name="Gender Using View"> <Hierarchy visible="true" hasAll="true" primaryKey="customer_id"> <View alias="GenderView"> <SQL dialect="infobright"> <![CDATA[Select distinct customer_id, gender from customer]]> </SQL> </View> <Level name="Gender" visible="true" column="gender" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> {noformat} Notice this line: *<SQL dialect="infobright">* This is the dimension as declared for MySQL {noformat} <Dimension type="StandardDimension" visible="true" foreignKey="customer_id" highCardinality="false" name="Gender using VIEW"> <Hierarchy visible="true" hasAll="true" primaryKey="customer_id"> <View alias="GenderView"> <SQL dialect="mysql"> <![CDATA[Select customer_id, gender from customer]]> </SQL> </View> <Level name="Gender" visible="true" column="gender" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> {noformat} Please note that when moving Gender from the MySQL based schema the report works. When dragging Gender from the Infobright based schema the report breaks with the following stack trace: {noformat} ERROR [com.pentaho.analyzer.b.c] Exception in AJAX handler. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:156) at com.pentaho.analyzer.content.controller.b.b(SourceFile:202) at com.pentaho.analyzer.content.AnalyzerContentGenerator.a(SourceFile:311) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:157) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:236) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:163) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) 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:411) 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:411) 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:411) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:189) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 85 more Caused by: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:320) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:139) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:979) at mondrian.olap.Util.newInternal(Util.java:2403) at mondrian.olap.Util.newError(Util.java:2418) at mondrian.rolap.sql.SqlQuery$CodeSet.chooseQuery(SqlQuery.java:1010) at mondrian.rolap.sql.SqlQuery.addFrom(SqlQuery.java:357) at mondrian.rolap.RolapHierarchy.addToFrom(RolapHierarchy.java:670) at mondrian.rolap.SqlTupleReader.addLevelMemberSql(SqlTupleReader.java:1127) at mondrian.rolap.SqlTupleReader.generateSelectForLevels(SqlTupleReader.java:938) at mondrian.rolap.SqlTupleReader.makeLevelMembersSql(SqlTupleReader.java:863) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:405) at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:530) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:259) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:193) at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:118) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:112) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:202) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:976) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:801) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:757) at mondrian.rolap.RolapResult.<init>(RolapResult.java:401) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) ... 4 more {noformat} There are no views using the Generic dialect

    Pentaho BI Platform Tracking | 8 months ago | Carlos Lopez
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: View has no 'generic' variant
  6. 0

    Mondrian 4.1.1.0 - Issue

    GitHub | 2 years ago | sanjayraja
    mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX parse failed

    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:Internal error: View has no 'generic' variant

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:979)
      1 frame
    3. mondrian.olap
      MondrianDef$SQL.choose
      1. mondrian.olap.Util.newInternal(Util.java:2470)
      2. mondrian.olap.Util.newError(Util.java:2485)
      3. mondrian.olap.MondrianDef$SQL.choose(MondrianDef.java:2900)
      3 frames
    4. mondrian.rolap
      RolapConnection.<init>
      1. mondrian.rolap.RolapSchemaLoader.registerView(RolapSchemaLoader.java:984)
      2. mondrian.rolap.RolapSchemaLoader.validatePhysicalSchema(RolapSchemaLoader.java:724)
      3. mondrian.rolap.RolapSchemaLoader.loadStage2(RolapSchemaLoader.java:364)
      4. mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:324)
      5. mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:260)
      6. mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4126)
      7. mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)
      8. mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)
      9. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:163)
      10. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91)
      10 frames
    5. mondrian.olap
      DriverManager.getConnection
      1. mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
      1 frame
    6. mondrian.test
      BasicQueryTest.testQ
      1. mondrian.test.TestContext.getConnection(TestContext.java:394)
      2. mondrian.test.TestContext.executeQuery(TestContext.java:710)
      3. mondrian.test.TestContext.assertQueryReturns(TestContext.java:1349)
      4. mondrian.test.TestContext.assertQueryReturns(TestContext.java:1366)
      5. mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:110)
      6. mondrian.test.BasicQueryTest.testQ(BasicQueryTest.java:7767)
      6 frames
    7. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3 frames
    8. com.intellij.junit3
      JUnit3IdeaTestRunner.doRun
      1. com.intellij.junit3.JUnit3IdeaTestRunner.doRun(JUnit3IdeaTestRunner.java:139)
      1 frame
    9. IDEA
      JUnitStarter.main
      1. com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:63)
      1 frame