mondrian.olap.MondrianException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • I was adding new hierarchies in a dimension and forgot to specify a tablename for the hierarchy <table> element. When I attempted to use the modified schema in my analysis xaction script the script itself returned no page contents, and pentaho.log revealed no exceptions, etc. I then attempted a simple query in the schema workbench, but on connect got this exception: 12:14:13,774 ERROR [QueryPanel] Exception: Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.QueryPanel.connectButtonActionPerformed(QueryPanel.java:276) at mondrian.gui.QueryPanel.initConnection(QueryPanel.java:100) at mondrian.gui.Workbench.newQueryMenuItemActionPerformed(Workbench.java:958) at mondrian.gui.Workbench.access$2(Workbench.java:883) at mondrian.gui.Workbench$3.actionPerformed(Workbench.java:265) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) After the fact, I looked up further and found another exception that occurred when opening the schema file initially in the schema workbench: 12:14:10,925 ERROR [Workbench] Exception : Schema file is invalid.Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.Workbench.openSchemaFrame(Workbench.java:1217) at mondrian.gui.Workbench.lastUsed1MenuItemActionPerformed(Workbench.java:1142) at mondrian.gui.Workbench.access$10(Workbench.java:1140) at mondrian.gui.Workbench$17.actionPerformed(Workbench.java:430) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) This bug represents a couple of things that all center around the same root problem: :- Schema workbench should notify you if the schema is invalid :- When attempting to make a connection using the [invalid] schema, the error message is uninformative, and the exception doesn't describe the problem at all :- When using an invalid schema in an xaction script, it seems the exception is being swallowed without being printed to the pentaho.log
    via by Brian Vandenberg,
  • From Pentaho's JIRA case BISERVER-911: Brian Vandenberg: I was adding new hierarchies in a dimension and forgot to specify a tablename for the hierarchy <table> element. When I attempted to use the modified schema in my analysis xaction script the script itself returned no page contents, and pentaho.log revealed no exceptions, etc. I then attempted a simple query in the schema workbench, but on connect got this exception: 12:14:13,774 ERROR [QueryPanel] Exception: Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.QueryPanel.connectButtonActionPerformed(QueryPanel.java:276) at mondrian.gui.QueryPanel.initConnection(QueryPanel.java:100) at mondrian.gui.Workbench.newQueryMenuItemActionPerformed(Workbench.java:958) at mondrian.gui.Workbench.access$2(Workbench.java:883) at mondrian.gui.Workbench$3.actionPerformed(Workbench.java:265) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) After the fact, I looked up further and found another exception that occurred when opening the schema file initially in the schema workbench: 12:14:10,925 ERROR [Workbench] Exception : Schema file is invalid.Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.Workbench.openSchemaFrame(Workbench.java:1217) at mondrian.gui.Workbench.lastUsed1MenuItemActionPerformed(Workbench.java:1142) at mondrian.gui.Workbench.access$10(Workbench.java:1140) at mondrian.gui.Workbench$17.actionPerformed(Workbench.java:430) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) This bug represents a couple of things that all center around the same root problem: :- Schema workbench should notify you if the schema is invalid :- When attempting to make a connection using the [invalid] schema, the error message is uninformative, and the exception doesn't describe the problem at all :- When using an invalid schema in an xaction script, it seems the exception is being swallowed without being printed to the pentaho.log Forgot to mention what version of schema workbench: 2.3.2.9247
    via by Will Gorman,
  • Steps to repro 1. Set mondrian.query.limit to a low value like 5 2. Fire any MDX query concurrently against the server from multiple threads Once in a while we get the following exception trace {noformat} [Mondrian] 03 Oct 2013 22:30:44,897 DEBUG [Session ] mondrian.rolap.SqlStatement#execute: 42: , failed (mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed) [Mondrian] 03 Oct 2013 22:30:44,899 ERROR [Session ] mondrian.xmla.XmlaServlet#doPost: Errors when handling XML/A message mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1728) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:751) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:666) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:505) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:317) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) Caused by: org.olap4j.OlapException: mondrian gave exception while executing query at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:827) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:421) at mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1705) ... 22 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [ <MDX QUERY> ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967) at mondrian.olap.Util.newInternal(Util.java:2400) at mondrian.olap.Util.newError(Util.java:2416) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:715) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) ... 3 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[ <MEMBER CACHE SQL> ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967) at mondrian.olap.Util.newInternal(Util.java:2400) at mondrian.olap.Util.newError(Util.java:2416) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:337) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:236) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:332) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:923) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:850) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:823) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:248) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:597) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:693) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:166) at mondrian.rolap.SmartMemberReader$SiblingIterator.<init>(SmartMemberReader.java:478) at mondrian.rolap.SmartMemberReader.getMemberRange(SmartMemberReader.java:369) at mondrian.rolap.RolapSchemaReader.getMemberRange(RolapSchemaReader.java:100) at mondrian.olap.DelegatingSchemaReader.getMemberRange(DelegatingSchemaReader.java:171) at mondrian.olap.fun.FunUtil.memberRange(FunUtil.java:1683) at mondrian.olap.fun.RangeFunDef$1.evaluateList(RangeFunDef.java:103) at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:817) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:642) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:598) at mondrian.rolap.RolapResult.<init>(RolapResult.java:243) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680) ... 8 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:964) at mondrian.olap.Util.newInternal(Util.java:2393) at mondrian.olap.Util.assertTrue(Util.java:2374) at mondrian.rolap.RolapUtil$Semaphore.enter(RolapUtil.java:667) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:133) ... 30 more {noformat}
    via by Dhwani Katagade,
  • I was adding new hierarchies in a dimension and forgot to specify a tablename for the hierarchy <table> element. When I attempted to use the modified schema in my analysis xaction script the script itself returned no page contents, and pentaho.log revealed no exceptions, etc. I then attempted a simple query in the schema workbench, but on connect got this exception: 12:14:13,774 ERROR [QueryPanel] Exception: Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.QueryPanel.connectButtonActionPerformed(QueryPanel.java:276) at mondrian.gui.QueryPanel.initConnection(QueryPanel.java:100) at mondrian.gui.Workbench.newQueryMenuItemActionPerformed(Workbench.java:958) at mondrian.gui.Workbench.access$2(Workbench.java:883) at mondrian.gui.Workbench$3.actionPerformed(Workbench.java:265) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) After the fact, I looked up further and found another exception that occurred when opening the schema file initially in the schema workbench: 12:14:10,925 ERROR [Workbench] Exception : Schema file is invalid.Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.Workbench.openSchemaFrame(Workbench.java:1217) at mondrian.gui.Workbench.lastUsed1MenuItemActionPerformed(Workbench.java:1142) at mondrian.gui.Workbench.access$10(Workbench.java:1140) at mondrian.gui.Workbench$17.actionPerformed(Workbench.java:430) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) This bug represents a couple of things that all center around the same root problem: :- Schema workbench should notify you if the schema is invalid :- When attempting to make a connection using the [invalid] schema, the error message is uninformative, and the exception doesn't describe the problem at all :- When using an invalid schema in an xaction script, it seems the exception is being swallowed without being printed to the pentaho.log
    via by Brian Vandenberg,
  • From Pentaho's JIRA case BISERVER-911: Brian Vandenberg: I was adding new hierarchies in a dimension and forgot to specify a tablename for the hierarchy <table> element. When I attempted to use the modified schema in my analysis xaction script the script itself returned no page contents, and pentaho.log revealed no exceptions, etc. I then attempted a simple query in the schema workbench, but on connect got this exception: 12:14:13,774 ERROR [QueryPanel] Exception: Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.QueryPanel.connectButtonActionPerformed(QueryPanel.java:276) at mondrian.gui.QueryPanel.initConnection(QueryPanel.java:100) at mondrian.gui.Workbench.newQueryMenuItemActionPerformed(Workbench.java:958) at mondrian.gui.Workbench.access$2(Workbench.java:883) at mondrian.gui.Workbench$3.actionPerformed(Workbench.java:265) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) After the fact, I looked up further and found another exception that occurred when opening the schema file initially in the schema workbench: 12:14:10,925 ERROR [Workbench] Exception : Schema file is invalid.Mondrian Error:Internal error: assert failed mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1096) at mondrian.olap.Util.assertTrue(Util.java:1077) at mondrian.rolap.RolapLevel.checkColumn(RolapLevel.java:400) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:113) at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:335) at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:170) at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:115) at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:616) at mondrian.rolap.RolapCube.<init>(RolapCube.java:144) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.Workbench.openSchemaFrame(Workbench.java:1217) at mondrian.gui.Workbench.lastUsed1MenuItemActionPerformed(Workbench.java:1142) at mondrian.gui.Workbench.access$10(Workbench.java:1140) at mondrian.gui.Workbench$17.actionPerformed(Workbench.java:430) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) This bug represents a couple of things that all center around the same root problem: :- Schema workbench should notify you if the schema is invalid :- When attempting to make a connection using the [invalid] schema, the error message is uninformative, and the exception doesn't describe the problem at all :- When using an invalid schema in an xaction script, it seems the exception is being swallowed without being printed to the pentaho.log Forgot to mention what version of schema workbench: 2.3.2.9247
    via by Will Gorman,
  • Steps to repro 1. Set mondrian.query.limit to a low value like 5 2. Fire any MDX query concurrently against the server from multiple threads Once in a while we get the following exception trace {noformat} [Mondrian] 03 Oct 2013 22:30:44,897 DEBUG [Session ] mondrian.rolap.SqlStatement#execute: 42: , failed (mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed) [Mondrian] 03 Oct 2013 22:30:44,899 ERROR [Session ] mondrian.xmla.XmlaServlet#doPost: Errors when handling XML/A message mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1728) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:751) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:666) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:505) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:317) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) Caused by: org.olap4j.OlapException: mondrian gave exception while executing query at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:827) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:421) at mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1705) ... 22 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [ <MDX QUERY> ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967) at mondrian.olap.Util.newInternal(Util.java:2400) at mondrian.olap.Util.newError(Util.java:2416) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:715) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) ... 3 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[ <MEMBER CACHE SQL> ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967) at mondrian.olap.Util.newInternal(Util.java:2400) at mondrian.olap.Util.newError(Util.java:2416) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:337) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:236) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:332) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:923) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:850) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:823) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:248) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:597) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:693) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:166) at mondrian.rolap.SmartMemberReader$SiblingIterator.<init>(SmartMemberReader.java:478) at mondrian.rolap.SmartMemberReader.getMemberRange(SmartMemberReader.java:369) at mondrian.rolap.RolapSchemaReader.getMemberRange(RolapSchemaReader.java:100) at mondrian.olap.DelegatingSchemaReader.getMemberRange(DelegatingSchemaReader.java:171) at mondrian.olap.fun.FunUtil.memberRange(FunUtil.java:1683) at mondrian.olap.fun.RangeFunDef$1.evaluateList(RangeFunDef.java:103) at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:817) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:642) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:598) at mondrian.rolap.RolapResult.<init>(RolapResult.java:243) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680) ... 8 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:964) at mondrian.olap.Util.newInternal(Util.java:2393) at mondrian.olap.Util.assertTrue(Util.java:2374) at mondrian.rolap.RolapUtil$Semaphore.enter(RolapUtil.java:667) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:133) ... 30 more {noformat}
    via by Dhwani Katagade,
  • After enabling XMLA on a datasource and attempting to connect to it using Simba driver or REX Data Warehouse Explorer you get an error stating No Suitable connection found with the following stacktrace in the Mondrian.log {noformat} 2017-03-20 17:58:10,638 DEBUG [mondrian.xmla.XmlaServlet] Invoking validate http header callbacks 2017-03-20 17:58:10,638 DEBUG [mondrian.xmla.XmlaServlet] Unmarshalling SOAP message 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.XmlaServlet] XML/A request content <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Header> <Security xmlns="http://schemas.xmlsoap.org/ws/2002/04/secext"> <UsernameToken> <Username>admin</Username> <Password Type="PasswordText">password</Password> </UsernameToken> </Security> </Header> <Body> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> <RequestType>DISCOVER_DATASOURCES</RequestType> <Restrictions> <RestrictionList/> </Restrictions> <Properties> <PropertyList> <LocaleIdentifier>1033</LocaleIdentifier> <Content>SchemaData</Content> <Format>Tabular</Format> </PropertyList> </Properties> </Discover> </Body> </Envelope> 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.XmlaServlet] Handling XML/A message header 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.XmlaServlet] Invoking callbacks preAction 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.XmlaServlet] Handling XML/A message body 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.impl.DefaultXmlaRequest] DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033" 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.impl.DefaultXmlaRequest] DefaultXmlaRequest.initProperties: key="Content", value="SchemaData" 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.impl.DefaultXmlaRequest] DefaultXmlaRequest.initProperties: key="Format", value="Tabular" 2017-03-20 17:58:10,644 DEBUG [mondrian.xmla.XmlaHandler] Creating new connection for user [admin] and session [<no_session>] 2017-03-20 17:58:10,663 DEBUG [mondrian.olap.MondrianServer] XmlaSupport.parseDataSources: dataSources=<?xml version="1.0" encoding="UTF-8"?> <DataSources> <DataSource> <DataSourceName>Pentaho Mondrian</DataSourceName> <DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription> <URL>/pentaho/Xmla</URL> <DataSourceInfo>Provider=Mondrian</DataSourceInfo> <ProviderName>PentahoXMLA</ProviderName> <ProviderType>MDP</ProviderType> <AuthenticationMode>Unauthenticated</AuthenticationMode> <Catalogs> <Catalog name="SteelWheels"> <DataSourceInfo>DataSource=SampleData;Provider=mondrian;EnableXmla="true";overwrite="true"</DataSourceInfo> <Definition>mondrian:/SteelWheels</Definition> </Catalog> </Catalogs> </DataSource> </DataSources> 2017-03-20 17:58:10,679 WARN [mondrian.olap.MondrianServer] Failed getting connection. Skipping org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: exception while getting file with path "/etc/mondrian/SteelWheels/annotations.xml" Reference number: 7ac906a0-a19e-4238-9ea5-b8ac91162e17 at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:512) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getFile(ExceptionLoggingDecorator.java:260) at org.pentaho.platform.repository.solution.filebased.SolutionRepositoryVfsFileObject.initFile(SolutionRepositoryVfsFileObject.java:126) at org.pentaho.platform.repository.solution.filebased.SolutionRepositoryVfsFileObject.exists(SolutionRepositoryVfsFileObject.java:133) at org.pentaho.platform.repository.solution.filebased.MondrianVfs.findFile(MondrianVfs.java:50) at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:790) at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:746) at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:695) at org.pentaho.platform.web.servlet.PentahoXmlaServlet$3.locate(PentahoXmlaServlet.java:225) at mondrian.olap.DriverManager.getConnection(DriverManager.java:111) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:164) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:97) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at mondrian.server.FileRepository.getConnection(FileRepository.java:241) at mondrian.server.FileRepository.getConnection(FileRepository.java:191) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:262) at org.pentaho.platform.web.servlet.PentahoXmlaServlet$4.getConnection(PentahoXmlaServlet.java:319) at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2977) at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:178) at mondrian.xmla.Rowset.populate(Rowset.java:219) at mondrian.xmla.Rowset.unparse(Rowset.java:194) at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2898) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:671) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:184) at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:189) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:125) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at com.pentaho.platform.security.a.doFilter(SourceFile:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:133) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) 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:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497) 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: org.springframework.dao.DataAccessResourceFailureException: Could not open Jcr Session; nested exception is javax.jcr.LoginException: Workspace access denied at org.springframework.extensions.jcr.SessionFactoryUtils.getSession(SessionFactoryUtils.java:121) at org.pentaho.platform.repository2.unified.jcr.sejcr.PentahoJcrTemplate.getSession(PentahoJcrTemplate.java:85) at org.pentaho.platform.repository2.unified.jcr.sejcr.PentahoJcrTemplate.execute(PentahoJcrTemplate.java:58) at org.springframework.extensions.jcr.JcrTemplate.execute(JcrTemplate.java:115) at org.pentaho.platform.security.policy.rolebased.JcrRoleAuthorizationPolicyRoleBindingDao.getBoundLogicalRoleNames(JcrRoleAuthorizationPolicyRoleBindingDao.java:151) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:280) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy86.getBoundLogicalRoleNames(Unknown Source) at org.pentaho.platform.security.policy.rolebased.RoleAuthorizationPolicy.isAllowed(RoleAuthorizationPolicy.java:82) at org.pentaho.platform.security.policy.rolebased.springsecurity.AuthorizationPolicyVoter.vote(AuthorizationPolicyVoter.java:91) at org.springframework.security.access.vote.UnanimousBased.decide(UnanimousBased.java:76) at org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:233) at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:65) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:280) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy90.getFile(Unknown Source) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$20.call(ExceptionLoggingDecorator.java:262) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$20.call(ExceptionLoggingDecorator.java:260) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:489) ... 104 more Caused by: javax.jcr.LoginException: Workspace access denied at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1529) at org.pentaho.platform.repository2.unified.jcr.sejcr.NoCachePentahoJcrSessionFactory.getSession(NoCachePentahoJcrSessionFactory.java:24) at org.pentaho.platform.repository2.unified.jcr.sejcr.GuavaCachePoolPentahoJcrSessionFactory.getSession(GuavaCachePoolPentahoJcrSessionFactory.java:142) at org.pentaho.platform.repository2.unified.jcr.sejcr.CredentialsStrategySessionFactory.getSession(CredentialsStrategySessionFactory.java:362) at org.springframework.extensions.jcr.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:87) at org.springframework.extensions.jcr.SessionFactoryUtils.getSession(SessionFactoryUtils.java:119) ... 135 more Caused by: javax.jcr.AccessDeniedException: Not allowed to access Workspace default at org.apache.jackrabbit.core.security.DefaultAccessManager.init(DefaultAccessManager.java:159) at org.apache.jackrabbit.core.DefaultSecurityManager.getAccessManager(DefaultSecurityManager.java:280) at org.apache.jackrabbit.core.SessionImpl.createAccessManager(SessionImpl.java:356) at org.apache.jackrabbit.core.SessionImpl.<init>(SessionImpl.java:273) at org.apache.jackrabbit.core.SessionImpl.<init>(SessionImpl.java:239) at org.apache.jackrabbit.core.XASessionImpl.<init>(XASessionImpl.java:101) at org.apache.jackrabbit.core.RepositoryImpl.createSessionInstance(RepositoryImpl.java:1613) at org.apache.jackrabbit.core.RepositoryImpl.createSession(RepositoryImpl.java:956) at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1501) ... 140 more 2017-03-20 17:58:10,683 ERROR [mondrian.xmla.XmlaServlet] Errors when handling XML/A message mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2904) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:671) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:184) at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:189) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:125) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at com.pentaho.platform.security.a.doFilter(SourceFile:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:133) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) 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:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497) 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: mondrian.olap.MondrianException: Mondrian Error:Internal error: No suitable connection found at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:984) at mondrian.olap.Util.newInternal(Util.java:2403) at mondrian.olap.Util.newError(Util.java:2418) at mondrian.server.FileRepository.getConnection(FileRepository.java:205) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:262) at org.pentaho.platform.web.servlet.PentahoXmlaServlet$4.getConnection(PentahoXmlaServlet.java:319) at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2977) at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:178) at mondrian.xmla.Rowset.populate(Rowset.java:219) at mondrian.xmla.Rowset.unparse(Rowset.java:194) at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2898) ... 78 more 2017-03-20 17:58:10,687 DEBUG [mondrian.xmla.XmlaServlet] XML/A response content <?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" > <SOAP-ENV:Header> </SOAP-ENV:Header> <SOAP-ENV:Body> <SOAP-ENV:Fault> <faultcode>SOAP-ENV:Server.00HSBE02</faultcode> <faultstring>XMLA Discover unparse results error</faultstring> <faultactor>Mondrian</faultactor> <detail> <XA:error xmlns:XA="http://mondrian.sourceforge.net"> <code>00HSBE02</code> <desc>The Mondrian XML: Mondrian Error:Internal error: No suitable connection found</desc> </XA:error> </detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> {noformat}
    via by Carlos Lopez,
  • In order to get around MONDRIAN-2564 you have to follow the changes done to applicationContext-spring-security.xml as described in BISERVER-13494 You have to enable XMLA Datasource in legacy form according to MONDRIAN-2229 (NOTE: the behavior is the same with or without this change) Once you connect to Mondrian via XMLA in MS Excel you get the following stacktrace in the mondrian.log {noformat} 2017-03-22 08:07:27,110 DEBUG [mondrian.olap.MondrianServer] XmlaSupport.parseDataSources: dataSources=<?xml version="1.0" encoding="UTF-8"?> <DataSources> <DataSource> <DataSourceName>Provider=Mondrian</DataSourceName> <DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription> <URL>/pentaho/Xmla</URL> <DataSourceInfo>Provider=Mondrian</DataSourceInfo> <ProviderName>PentahoXMLA</ProviderName> <ProviderType>MDP</ProviderType> <AuthenticationMode>Unauthenticated</AuthenticationMode> <Catalogs> <Catalog name="SteelWheels"> <DataSourceInfo>DataSource=SampleData;Provider=mondrian;EnableXmla="true";overwrite="true"</DataSourceInfo> <Definition>mondrian:/SteelWheels</Definition> </Catalog> </Catalogs> </DataSource> </DataSources> 2017-03-22 08:07:27,113 DEBUG [mondrian.server.MondrianServerImpl] removeConnection , id=1, statements=0, connections=1 2017-03-22 08:07:27,113 ERROR [mondrian.xmla.XmlaServlet] Errors when handling XML/A message mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2904) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:671) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:184) at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:189) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:125) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at com.pentaho.platform.security.a.doFilter(SourceFile:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:133) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) 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:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497) 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: mondrian.olap.MondrianException: Mondrian Error:Internal error: Unknown database 'SteelWheels' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:984) at mondrian.olap.Util.newInternal(Util.java:2403) at mondrian.olap.Util.newError(Util.java:2418) at mondrian.server.FileRepository.getConnection(FileRepository.java:180) at org.pentaho.platform.web.servlet.PentahoXmlaServlet$4.getConnection(PentahoXmlaServlet.java:361) at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2977) at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:178) at mondrian.xmla.Rowset.populate(Rowset.java:219) at mondrian.xmla.Rowset.unparse(Rowset.java:194) at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2898) ... 78 more 2017-03-22 08:07:27,113 DEBUG [mondrian.server.monitor] ConnectionInfo{cellCacheHitCount=0, cellCacheRequestCount=0, cellCacheMissCount=0, cellCachePendingCount=0, statementStartCount=0, statementEndCount=0, executeStartCount=0, executeEndCount=0} 2017-03-22 08:07:27,118 DEBUG [mondrian.server.monitor] ConnectionEndEvent(43) 2017-03-22 08:07:27,118 DEBUG [mondrian.xmla.XmlaServlet] XML/A response content <?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" > <SOAP-ENV:Header> </SOAP-ENV:Header> <SOAP-ENV:Body> <SOAP-ENV:Fault> <faultcode>SOAP-ENV:Server.00HSBE02</faultcode> <faultstring>XMLA Discover unparse results error</faultstring> <faultactor>Mondrian</faultactor> <detail> <XA:error xmlns:XA="http://mondrian.sourceforge.net"> <code>00HSBE02</code> <desc>The Mondrian XML: Mondrian Error:Internal error: Unknown database &#39;SteelWheels&#39;</desc> </XA:error> </detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> {noformat} Please see attached mondrian.log
    via by Carlos Lopez,
    • mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:984) at mondrian.olap.Util.newInternal(Util.java:2403) at mondrian.olap.Util.assertTrue(Util.java:2384) at mondrian.rolap.RolapAggregationManager.addNonConstrainingColumns(RolapAggregationManager.java:467)

    Users with the same issue

    Unknown visitor1 times, last one,