Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Pentaho 8.0 CE issue #21

Open
UmangShahspec opened this issue May 17, 2018 · 1 comment
Open

Pentaho 8.0 CE issue #21

UmangShahspec opened this issue May 17, 2018 · 1 comment

Comments

@UmangShahspec
Copy link

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
Copy link

Ibby-B commented Jun 30, 2021

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants