mondrian.olap.MondrianException: Mondrian Error:Internal error: Bad value access='custom'

Pentaho BI Platform Tracking | David da Guia | 4 years ago
  1. 0

    Using "Pentaho Analysis" as data source with a "custom" role for especify the hierarchy limits for some users I got the error (on the attempt to preview the query): org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Bad value access='custom' at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:394) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:80) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:619) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Bad value access='custom' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838) at mondrian.olap.Util.newInternal(Util.java:1532) at mondrian.olap.Util.newError(Util.java:1547) at mondrian.rolap.RolapSchema.getAccess(RolapSchema.java:679) at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:560) at mondrian.rolap.RolapSchema.load(RolapSchema.java:463) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DefaultMondrianConnectionProvider.createConnection(DefaultMondrianConnectionProvider.java:58) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:385) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:80) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:619) The MDX query works fine inside PSW and BiServer (analysis)! If I change the "custom" parameter of the role to "all" or "none" (any but custom) it works... but with custom (at any role) it gives me that error. At de schema... the Authenticated role are set to none, the Admin to all and other roles have all or custom... I try to add security (options) passing the role static "Admin" and the db user/pass but the error still there!

    Pentaho BI Platform Tracking | 4 years ago | David da Guia
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Bad value access='custom'
  2. 0

    Error with "Pentaho Analysis" data source and schema with roles (custom) [Archive] - Pentaho Community Forums

    pentaho.com | 7 months ago
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Bad value access='custom'
  3. 0

    Using "Pentaho Analysis" as data source with a "custom" role for especify the hierarchy limits for some users I got the error (on the attempt to preview the query): org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Bad value access='custom' at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:394) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:80) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:619) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Bad value access='custom' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838) at mondrian.olap.Util.newInternal(Util.java:1532) at mondrian.olap.Util.newError(Util.java:1547) at mondrian.rolap.RolapSchema.getAccess(RolapSchema.java:679) at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:560) at mondrian.rolap.RolapSchema.load(RolapSchema.java:463) at mondrian.rolap.RolapSchema.load(RolapSchema.java:318) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95) at mondrian.olap.DriverManager.getConnection(DriverManager.java:110) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DefaultMondrianConnectionProvider.createConnection(DefaultMondrianConnectionProvider.java:58) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:385) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:80) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99) at java.lang.Thread.run(Thread.java:619) The MDX query works fine inside PSW and BiServer (analysis)! If I change the "custom" parameter of the role to "all" or "none" (any but custom) it works... but with custom (at any role) it gives me that error. At de schema... the Authenticated role are set to none, the Admin to all and other roles have all or custom... I try to add security (options) passing the role static "Admin" and the db user/pass but the error still there!

    Pentaho BI Platform Tracking | 4 years ago | David da Guia
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Bad value access='custom'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error : Error Di BI Server

    Google Groups | 5 years ago | Bambang Sistriadianto
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Anonymous data source=org.apache.tomcat.dbcp.dbcp.BasicDataSource@67c8f3da
  6. 0

    Hello, I'm have the solution-repository based on DataBase, and have folloved code: ChartHelper.doChart("ol", "analysis", "topp.widget.xml", parameters, content, userSession, messages, null); I cautch exception (+debug mode): 18:03:51,573 DEBUG [HibernateUtil] Opening new Session for this thread. 18:03:51,963 DEBUG [SolutionEngine] ::: Starting execute of ol/analysis/topp_data_query1.xaction 18:03:51,963 DEBUG [SolutionEngine] :SOLUTION-ENGINE:topp_data_query1.xaction: Getting runtime context and data 18:03:51,963 DEBUG [HibernateUtil] Starting new database transaction in this thread. 18:03:51,963 DEBUG [RuntimeRepository] 60F19E27DC67347DA1E604B4BB386832:org.pentaho.ui.component.charting.CategoryDatasetChartComponent:topp_data_query1.xaction: newRuntimeElement(60F19E27DC67347DA1E604B4BB386832,session) 18:03:52,698 DEBUG [RuntimeRepository] 60F19E27DC67347DA1E604B4BB386832:org.pentaho.ui.component.charting.CategoryDatasetChartComponent:topp_data_query1.xaction: Created instanceId: 2429165e-7027-11dc-87ee-e38a34dd5e1a 18:03:52,791 DEBUG [SolutionEngine] 2429165e-7027-11dc-87ee-e38a34dd5e1a:SOLUTION-ENGINE:topp_data_query1.xaction: Loading action sequence definition file 18:03:52,791 DEBUG [RuntimeContext] 2429165e-7027-11dc-87ee-e38a34dd5e1a:RUNTIME:context-8363376-1191247432698:topp_data_query1.xaction audit: instanceId=2429165e-7027-11dc-87ee-e38a34dd5e1a, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start 18:03:53,104 ERROR [Logger] Error: Pentaho 1.6.0 build 782 RC1 18:03:53,104 ERROR [Logger] misc-org.pentaho.data.connection.mdx.MDXConnection: MDXConnection.ERROR_0002 - "Unable to create a native connection for connection string: "provider=mondrian; dataSource=java:OL; Catalog=c:/Work/_Project/Pentaho/Project/pentaho-solutions\ol\analysis\OLCube.mondrian.xml" mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: c:/Work/_Project/Pentaho/Project/pentaho-solutions\ol\analysis\OLCube.mondrian.xml at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1076) at mondrian.olap.Util.newError(Util.java:1091) at mondrian.rolap.RolapSchema.load(RolapSchema.java:277) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:213) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:76) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:837) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:659) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:148) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:79) at mondrian.olap.DriverManager.getConnection(DriverManager.java:122) at mondrian.olap.DriverManager.getConnection(DriverManager.java:87) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at org.pentaho.data.connection.mdx.MDXConnection.init(MDXConnection.java:88) at org.pentaho.data.connection.mdx.MDXConnection.init(MDXConnection.java:152) at org.pentaho.data.connection.mdx.MDXConnection.<init>(MDXConnection.java:73) at org.pentaho.data.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:136) at org.pentaho.plugin.mdx.MDXBaseComponent.getConnection(MDXBaseComponent.java:393) at org.pentaho.plugin.mdx.MDXBaseComponent.getDatasourceConnection(MDXBaseComponent.java:306) at org.pentaho.plugin.mdx.MDXBaseComponent.executeAction(MDXBaseComponent.java:137) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:437) at org.pentaho.core.runtime.RuntimeContextBase.executeComponent(RuntimeContextBase.java:1097) at org.pentaho.core.runtime.RuntimeContextBase.executeAction(RuntimeContextBase.java:1071) at org.pentaho.core.runtime.RuntimeContextBase.performActions(RuntimeContextBase.java:986) at org.pentaho.core.runtime.RuntimeContextBase.executeLoop(RuntimeContextBase.java:942) at org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:847) at org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:754) at org.pentaho.core.solution.SolutionEngineBase.executeInternal(SolutionEngineBase.java:298) at org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:232) at org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:164) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:58) at org.pentaho.ui.component.charting.AbstractChartComponent.getActionData(AbstractChartComponent.java:163) at org.pentaho.ui.component.charting.CategoryDatasetChartComponent.createChart(CategoryDatasetChartComponent.java:82) at org.pentaho.ui.component.charting.CategoryDatasetChartComponent.getXmlContent(CategoryDatasetChartComponent.java:156) at org.pentaho.ui.XmlComponent.getContent(XmlComponent.java:47) at org.pentaho.ui.ChartHelper.doChart(ChartHelper.java:279) at org.apache.jsp.portlets.TOPPChart_jsp._jspService(TOPPChart_jsp.java:86) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:71) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:160) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Unknown Source) 18:03:53,151 ERROR [Logger] Error end: 18:03:53,151 ERROR [MDXLookupRule] 2429165e-7027-11dc-87ee-e38a34dd5e1a:COMPONENT:context-8363376-1191247432698:topp_data_query1.xaction MDXBaseComponent.ERROR_0008 - Connection to data source is not valid 18:03:53,151 ERROR [RuntimeContext] 2429165e-7027-11dc-87ee-e38a34dd5e1a:RUNTIME:context-8363376-1191247432698:topp_data_query1.xaction RuntimeContext.ERROR_0012 - ActionDefinition for MDXLookupRule did not execute successfully 18:03:53,166 ERROR [SolutionEngine] 2429165e-7027-11dc-87ee-e38a34dd5e1a:SOLUTION-ENGINE:topp_data_query1.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

    Pentaho BI Platform Tracking | 9 years ago | Roman Bliznets
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: c:/Work/_Project/Pentaho/Project/pentaho-solutions\ol\analysis\OLCube.mondrian.xml

    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: Bad value access='custom'

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838)
      1 frame
    3. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newInternal(Util.java:1532)
      2. mondrian.olap.Util.newError(Util.java:1547)
      2 frames
    4. mondrian.rolap
      RolapConnection.<init>
      1. mondrian.rolap.RolapSchema.getAccess(RolapSchema.java:679)
      2. mondrian.rolap.RolapSchema.createRole(RolapSchema.java:560)
      3. mondrian.rolap.RolapSchema.load(RolapSchema.java:463)
      4. mondrian.rolap.RolapSchema.load(RolapSchema.java:318)
      5. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229)
      6. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54)
      7. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986)
      8. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797)
      9. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173)
      10. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
      10 frames
    5. mondrian.olap
      DriverManager.getConnection
      1. mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
      1 frame
    6. org.pentaho.reporting
      MondrianPreviewWorker.run
      1. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DefaultMondrianConnectionProvider.createConnection(DefaultMondrianConnectionProvider.java:58)
      2. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:385)
      3. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:80)
      4. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54)
      5. org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99)
      5 frames
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame