search

it4biz / pentaho-ce-audit

Pentaho CE Audit plugin by IT4biz.
3 stars 10 forks source link

Pentaho 8.0 CE issue #21

Open UmangShahspec opened 6 years ago

UmangShahspec commented 6 years ago

After giving my personal details and pressing submit button i got error saying unable to publish. After re-starting the server i went to Pentaho CE Audit in tools menu and got errors in all the components. I checked the logs and getting bellow error.

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: mondrian:/Pentaho+CE+Audit at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:989) at mondrian.olap.Util.newInternal(Util.java:2403) at mondrian.olap.Util.newError(Util.java:2418) at mondrian.olap.Util.readVirtualFile(Util.java:3356) at mondrian.olap.Util.readVirtualFileAsString(Util.java:3377) at mondrian.rolap.RolapSchemaPool.getSchemaContent(RolapSchemaPool.java:366) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:136) at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:86) at mondrian.rolap.RolapConnection.(RolapConnection.java:168) at mondrian.rolap.RolapConnection.(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.DefaultMondrianConnectionProvider.createConnection(DefaultMondrianConnectionProvider.java:67) at org.pentaho.reporting.platform.plugin.connection.PentahoMondrianConnectionProvider.createConnection(PentahoMondrianConnectionProvider.java:54) 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:132) at pt.webdetails.cda.utils.mondrian.CompactBandedMDXDataFactory.queryData(CompactBandedMDXDataFactory.java:48) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:172) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:67) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:411) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:299) at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:127) ... 105 more

Ibby-B commented 3 years ago

For anyone who comes across this issue, it seems the Mondrian schema isn't automatically created if you're using a Pentaho version greater than 5. You can easily remedy this in the front end, just upload the schema here Following the steps in here