org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource: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
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource: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
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource: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
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Bad value access='custom'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    If I set a security options (mondrianSecurityDialog) and them I remove this options later (put it blank again) it returns the error: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while creating SQL connection: Anonymous data source=org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource@dd667826; JdbcUser=; JdbcPassword= 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: Error while creating SQL connection: Anonymous data source=org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource@dd667826; JdbcUser=; JdbcPassword= at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:233) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:184) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:228) 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) Caused by: org.postgresql.util.PSQLException: FATAL: no PostgreSQL user name specified in startup packet at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:276) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:95) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:386) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource.getConnection(DriverDataSourceCache.java:154) at mondrian.rolap.RolapConnection$UserPasswordDataSource.getConnection(RolapConnection.java:998) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:213) ... 14 more The only work around that I find was delete the data set...

    Pentaho BI Platform Tracking | 4 years ago | David da Guia
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while creating SQL connection: Anonymous data source=org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource@dd667826; JdbcUser=; JdbcPassword=
  6. 0

    If I set a security options (mondrianSecurityDialog) and them I remove this options later (put it blank again) it returns the error: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while creating SQL connection: Anonymous data source=org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource@dd667826; JdbcUser=; JdbcPassword= 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: Error while creating SQL connection: Anonymous data source=org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource@dd667826; JdbcUser=; JdbcPassword= at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:233) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:184) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:228) 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) Caused by: org.postgresql.util.PSQLException: FATAL: no PostgreSQL user name specified in startup packet at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:276) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:95) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:386) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource.getConnection(DriverDataSourceCache.java:154) at mondrian.rolap.RolapConnection$UserPasswordDataSource.getConnection(RolapConnection.java:998) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:213) ... 14 more The only work around that I find was delete the data set...

    Pentaho BI Platform Tracking | 4 years ago | David da Guia
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to create datasource:Mondrian Error:Internal error: Error while creating SQL connection: Anonymous data source=org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DriverDataSourceCache$DriverManagerDataSource@dd667826; JdbcUser=; JdbcPassword=

    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. 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()
    2. org.pentaho.reporting
      MondrianPreviewWorker.run
      1. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:394)
      2. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:80)
      3. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54)
      4. org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99)
      4 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame