mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1012)

Pentaho BI Platform Tracking | avix | 1 decade ago
  1. 0

    When I have multiple dimensions that refer to the same table, I get mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1012) at mondrian.olap.Util.newInternal(Util.java:823) at mondrian.olap.Util.assertTrue(Util.java:804) at mondrian.rolap.agg.Segment.get(Segment.java:187) at mondrian.rolap.agg.Aggregation.get(Aggregation.java:349) at mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:105) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:86) To reproduce: in FoodMart.xml in the Sales cube, I duplicate the "Promotion" dimension and rename the copy to "Promotion2" - looks like this: <Dimension name="Promotions" foreignKey="promotion_id"> <Hierarchy hasAll="true" allMemberName="All Promotions" primaryKey="promotion_id"> <Table name="promotion"/> <Level name="Promotion Name" column="promotion_name" uniqueMembers="true"/> </Hierarchy> </Dimension> <Dimension name="Promotions2" foreignKey="promotion_id"> <Hierarchy hasAll="true" allMemberName="All Promotions" primaryKey="promotion_id"> <Table name="promotion"/> <Level name="Promotion Name" column="promotion_name" uniqueMembers="true"/> </Hierarchy> </Dimension> Then run the following MDX select { [Promotions].[All Promotions].[Bag Stuffers] } on columns, { [Promotions2].[All Promotions].[Bag Stuffers] } on rows from [Sales] This produces above exception.

    Pentaho BI Platform Tracking | 1 decade ago | avix
    mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1012)
  2. 0

    When I have multiple dimensions that refer to the same table, I get mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1012) at mondrian.olap.Util.newInternal(Util.java:823) at mondrian.olap.Util.assertTrue(Util.java:804) at mondrian.rolap.agg.Segment.get(Segment.java:187) at mondrian.rolap.agg.Aggregation.get(Aggregation.java:349) at mondrian.rolap.agg.AggregationManager.getCellFromCache(AggregationManager.java:105) at mondrian.rolap.FastBatchingCellReader.get(FastBatchingCellReader.java:86) To reproduce: in FoodMart.xml in the Sales cube, I duplicate the "Promotion" dimension and rename the copy to "Promotion2" - looks like this: <Dimension name="Promotions" foreignKey="promotion_id"> <Hierarchy hasAll="true" allMemberName="All Promotions" primaryKey="promotion_id"> <Table name="promotion"/> <Level name="Promotion Name" column="promotion_name" uniqueMembers="true"/> </Hierarchy> </Dimension> <Dimension name="Promotions2" foreignKey="promotion_id"> <Hierarchy hasAll="true" allMemberName="All Promotions" primaryKey="promotion_id"> <Table name="promotion"/> <Level name="Promotion Name" column="promotion_name" uniqueMembers="true"/> </Hierarchy> </Dimension> Then run the following MDX select { [Promotions].[All Promotions].[Bag Stuffers] } on columns, { [Promotions2].[All Promotions].[Bag Stuffers] } on rows from [Sales] This produces above exception.

    Pentaho BI Platform Tracking | 1 decade ago | avix
    mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1012)
  3. 0

    I'm attempting to connect to an Oracle DB via JPivot. Mondrian connects successfully and does run some SQL against it. However, in rendering the table, it blows up with this :- javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:821) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758) at org.apache.jsp.test_jsp._jspService(test_jsp.java:108) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:204) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:245) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:250) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.test_jsp._jspx_meth_wcf_render_0(test_jsp.java:219) at org.apache.jsp.test_jsp._jspService(test_jsp.java:97) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1030) at mondrian.olap.Util.newInternal(Util.java:893) at mondrian.olap.Util.newError(Util.java:909) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:353) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:185) ... 47 more Caused by: java.lang.ClassCastException at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:61) at mondrian.olap.fun.TupleFunDef$CalcImpl.evaluateTuple(TupleFunDef.java:126) at mondrian.olap.fun.SetFunDef$4.evaluateVoid(SetFunDef.java:174) at mondrian.olap.fun.SetFunDef$SetCalc.evaluateList(SetFunDef.java:189) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:45) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:197) at mondrian.rolap.RolapResult.(RolapResult.java:81) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330) ... 48 more mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1030) at mondrian.olap.Util.newInternal(Util.java:893) at mondrian.olap.Util.newError(Util.java:909) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:353) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:185) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:245) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:250) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.test_jsp._jspx_meth_wcf_render_0(test_jsp.java:219) at org.apache.jsp.test_jsp._jspService(test_jsp.java:97) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) Caused by: java.lang.ClassCastException at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:61) at mondrian.olap.fun.TupleFunDef$CalcImpl.evaluateTuple(TupleFunDef.java:126) at mondrian.olap.fun.SetFunDef$4.evaluateVoid(SetFunDef.java:174) at mondrian.olap.fun.SetFunDef$SetCalc.evaluateList(SetFunDef.java:189) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:45) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:197) at mondrian.rolap.RolapResult.(RolapResult.java:81) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330) ... 48 more java.lang.ClassCastException java.lang.ClassCastException at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:61) at mondrian.olap.fun.TupleFunDef$CalcImpl.evaluateTuple(TupleFunDef.java:126) at mondrian.olap.fun.SetFunDef$4.evaluateVoid(SetFunDef.java:174) at mondrian.olap.fun.SetFunDef$SetCalc.evaluateList(SetFunDef.java:189) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:45) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:197) at mondrian.rolap.RolapResult.(RolapResult.java:81) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:185) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:245) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:250) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.test_jsp._jspx_meth_wcf_render_0(test_jsp.java:219) at org.apache.jsp.test_jsp._jspService(test_jsp.java:97) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) My schema definition is :- <Schema name="Bob"> <Cube name="XDRs"> <Table name="XDR" /> <Dimension name="Period" foreignKey="PERIOD_ID"> <Hierarchy hasAll="false" primaryKey="PERIOD_ID"> <Table name="XDR_PERIOD" /> <Level name="Year" column="YEAR" type="String" uniqueMembers="true" /> <Level name="Quarter" column="QUARTER" type="Numeric" uniqueMembers="false" /> <Level name="Month" column="MONTH" type="Numeric" uniqueMembers="false" /> <Level name="Day" column="DAY" type="Numeric" uniqueMembers="false" /> </Hierarchy> </Dimension> <Dimension name="CDRType" foreignKey="XDR_TYPE_ID"> <Hierarchy hasAll="true" primaryKey="XDR_TYPE_ID"> <Table name="XDR_TYPE" /> <Level name="Type" column="XDR_TYPE" type="String" uniqueMembers="true" /> <Level name="SubType" column="XDR_SUB_TYPE" type="String" uniqueMembers="true" /> </Hierarchy> </Dimension> <Measure name="cdrs" column="CDRS" aggregator="sum" /> <Measure name="duration" column="DURATION" aggregator="sum" /> </Cube> </Schema> And I am querying it within the jsp as :- <jp:mondrianQuery id="query01" jdbcDriver="oracle.jdbc.driver.OracleDriver" jdbcUrl="jdbc:oracle:thin:@localhost:1521:paphdv16" jdbcUser="scott" jdbcPassword="tiger" catalogUri="/WEB-INF/dataModel.xml"> select {Measures.cdrs,Measures.duration} on columns, {(Period.Year,CDRType.Type)} ON rows from XDRs </jp:mondrianQuery> <body> <h1>Test</h1> <jp:table id="table01" query="#{query01}" visible="true"/> <wcf:render ref="table01" xslUri="/WEB-INF/jpivot/table/mdxtable.xsl" xslCache="true"/> <h1>End</h1> I may well have a configuration problem (I'm low on the learning curve), but I find the ClassCastException scary

    Pentaho BI Platform Tracking | 1 decade ago | scudderfish
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:204) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:245) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:250) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.test_jsp._jspx_meth_wcf_render_0(test_jsp.java:219)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I'm attempting to connect to an Oracle DB via JPivot. Mondrian connects successfully and does run some SQL against it. However, in rendering the table, it blows up with this :- javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:821) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758) at org.apache.jsp.test_jsp._jspService(test_jsp.java:108) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:204) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:245) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:250) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.test_jsp._jspx_meth_wcf_render_0(test_jsp.java:219) at org.apache.jsp.test_jsp._jspService(test_jsp.java:97) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1030) at mondrian.olap.Util.newInternal(Util.java:893) at mondrian.olap.Util.newError(Util.java:909) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:353) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:185) ... 47 more Caused by: java.lang.ClassCastException at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:61) at mondrian.olap.fun.TupleFunDef$CalcImpl.evaluateTuple(TupleFunDef.java:126) at mondrian.olap.fun.SetFunDef$4.evaluateVoid(SetFunDef.java:174) at mondrian.olap.fun.SetFunDef$SetCalc.evaluateList(SetFunDef.java:189) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:45) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:197) at mondrian.rolap.RolapResult.(RolapResult.java:81) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330) ... 48 more mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1030) at mondrian.olap.Util.newInternal(Util.java:893) at mondrian.olap.Util.newError(Util.java:909) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:353) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:185) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:245) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:250) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.test_jsp._jspx_meth_wcf_render_0(test_jsp.java:219) at org.apache.jsp.test_jsp._jspService(test_jsp.java:97) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) Caused by: java.lang.ClassCastException at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:61) at mondrian.olap.fun.TupleFunDef$CalcImpl.evaluateTuple(TupleFunDef.java:126) at mondrian.olap.fun.SetFunDef$4.evaluateVoid(SetFunDef.java:174) at mondrian.olap.fun.SetFunDef$SetCalc.evaluateList(SetFunDef.java:189) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:45) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:197) at mondrian.rolap.RolapResult.(RolapResult.java:81) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330) ... 48 more java.lang.ClassCastException java.lang.ClassCastException at mondrian.calc.impl.GenericCalc.evaluateMember(GenericCalc.java:61) at mondrian.olap.fun.TupleFunDef$CalcImpl.evaluateTuple(TupleFunDef.java:126) at mondrian.olap.fun.SetFunDef$4.evaluateVoid(SetFunDef.java:174) at mondrian.olap.fun.SetFunDef$SetCalc.evaluateList(SetFunDef.java:189) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:45) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:197) at mondrian.rolap.RolapResult.(RolapResult.java:81) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:185) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:245) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:250) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.test_jsp._jspx_meth_wcf_render_0(test_jsp.java:219) at org.apache.jsp.test_jsp._jspService(test_jsp.java:97) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) My schema definition is :- <Schema name="Bob"> <Cube name="XDRs"> <Table name="XDR" /> <Dimension name="Period" foreignKey="PERIOD_ID"> <Hierarchy hasAll="false" primaryKey="PERIOD_ID"> <Table name="XDR_PERIOD" /> <Level name="Year" column="YEAR" type="String" uniqueMembers="true" /> <Level name="Quarter" column="QUARTER" type="Numeric" uniqueMembers="false" /> <Level name="Month" column="MONTH" type="Numeric" uniqueMembers="false" /> <Level name="Day" column="DAY" type="Numeric" uniqueMembers="false" /> </Hierarchy> </Dimension> <Dimension name="CDRType" foreignKey="XDR_TYPE_ID"> <Hierarchy hasAll="true" primaryKey="XDR_TYPE_ID"> <Table name="XDR_TYPE" /> <Level name="Type" column="XDR_TYPE" type="String" uniqueMembers="true" /> <Level name="SubType" column="XDR_SUB_TYPE" type="String" uniqueMembers="true" /> </Hierarchy> </Dimension> <Measure name="cdrs" column="CDRS" aggregator="sum" /> <Measure name="duration" column="DURATION" aggregator="sum" /> </Cube> </Schema> And I am querying it within the jsp as :- <jp:mondrianQuery id="query01" jdbcDriver="oracle.jdbc.driver.OracleDriver" jdbcUrl="jdbc:oracle:thin:@localhost:1521:paphdv16" jdbcUser="scott" jdbcPassword="tiger" catalogUri="/WEB-INF/dataModel.xml"> select {Measures.cdrs,Measures.duration} on columns, {(Period.Year,CDRType.Type)} ON rows from XDRs </jp:mondrianQuery> <body> <h1>Test</h1> <jp:table id="table01" query="#{query01}" visible="true"/> <wcf:render ref="table01" xslUri="/WEB-INF/jpivot/table/mdxtable.xsl" xslCache="true"/> <h1>End</h1> I may well have a configuration problem (I'm low on the learning curve), but I find the ClassCastException scary

    Pentaho BI Platform Tracking | 1 decade ago | scudderfish
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[cdrs], [Measures].[duration]} ON COLUMNS, {([Period].[Year], [CDRType].[Type])} ON ROWS from [XDRs] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1030)
  6. 0

    In a situation where I have to mix a snowflake dimension with a Closure table, I get the following error: "Internal error: join does not have alias". I can see from stepping through the code that this is generated in the file mondrian.rolap.RolapStar$Table.addJoin() String rightAlias = join.rightAlias; if (rightAlias == null) { rightAlias = join.right.getAlias(); if (rightAlias == null) { throw Util.newError( "missing rightKeyAlias in " + relation); } } The right hand side of the join for the Closure dimension is also a Join because of the Snowflake. The Join class embedded in Mondrian.xml returns the error when we try to get it's alias: public String getAlias() { throw Util.newInternal("join does not have alias"); } Here is the relevant section of my schema: <Dimension name="User"> <Hierarchy hasAll="true" primaryKey="user_id" allMemberName="All" primaryKeyTable="dim_users"> <Join leftKey="dim_user_fused_groups_fused_group_id" rightAlias="dim_user_fused_groups" rightKey="fused_group_id"> <Table name="dim_users"/> <Table name="dim_user_fused_groups"/> </Join> <Level name="User Groups" table="dim_user_fused_groups" column="fused_group_names" uniqueMembers="true"/> <Level name="User Id" table="dim_users" column="user_id" type="Numeric" parentColumn="manager_id" nameColumn="Name" nullParentValue="0" uniqueMembers="true"> <Closure parentColumn="dim_users_manager_id" childColumn="dim_users_user_id"> <Table name="dim_user_manager_closure"/> </Closure> <Property name="Name" column="name"/> <Property name="Description" column="description"/> <Property name="Login" column="login"/> <Property name="Email" column="email"/> </Level> </Hierarchy> </Dimension> Here is the full stack trace: 2007-03-05 12:41:34,127 ERROR [http-8080-Processor25] com.tonbeller.jpivot.tags.OlapModelTag (OlapModelTag.java:80) - mondrian.olap.MondrianException: Mondrian Error:Internal error: join does not have alias at mondrian.resource.MondrianResource$_Def0.ex(Mondri anResource.java:852) at mondrian.olap.Util.newInternal(Util.java:947) at mondrian.olap.MondrianDef$Join.getAlias(MondrianDe f.java:2125) at mondrian.rolap.RolapStar$Table.addJoin(RolapStar.j ava:1266) at mondrian.rolap.RolapCube.registerDimension(RolapCu be.java:1336) at mondrian.rolap.RolapLevel.init(RolapLevel.java:377 ) at mondrian.rolap.RolapHierarchy.init(RolapHierarchy. java:275) at mondrian.rolap.RolapDimension.init(RolapDimension. java:193) at mondrian.rolap.RolapCube.init(RolapCube.java:865) at mondrian.rolap.RolapCube.<init>(RolapCube.java:244 ) at mondrian.rolap.RolapSchema.load(RolapSchema.java:3 90) at mondrian.rolap.RolapSchema.load(RolapSchema.java:2 72) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :212) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :89) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.ja va:828) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.ja va:653) at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:141) at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:76) at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:120) at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:87) at com.tonbeller.jpivot.mondrian.MondrianModel.initia lize(MondrianModel.java:400) at com.tonbeller.jpivot.olap.model.OlapModelDecorator .initialize(OlapModelDecorator.java:129) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.i nitialize(OlapModelProxy.java:76) at com.tonbeller.jpivot.tags.PageStateManager.initial izeAndShow(PageStateManager.java:37) at com.tonbeller.jpivot.tags.OlapModelProxy.initializ eAndShow(OlapModelProxy.java:161) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(Ol apModelTag.java:76) at org.apache.jsp.WEB_002dINF.queries.activity_jsp._j spx_meth_jp_mondrianQuery_0(activity_jsp.java:126) at org.apache.jsp.WEB_002dINF.queries.activity_jsp._j spService(activity_jsp.java:64) at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.doI nclude(ApplicationDispatcher.java:574) at org.apache.catalina.core.ApplicationDispatcher.inc lude(ApplicationDispatcher.java:499) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(Incl udeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_include _0(testpage_jsp.java:277) at org.apache.jsp.testpage_jsp._jspService(testpage_j sp.java:122) at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandl er.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.h andleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilte r(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) 2007-03-05 12:41:34,174 ERROR [http-8080-Processor25] org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/connect-repo rts].[jsp] (ApplicationDispatcher.java:704) - Servlet.service() for servlet jsp threw exception mondrian.olap.MondrianException: Mondrian Error:Internal error: join does not have alias at mondrian.resource.MondrianResource$_Def0.ex(Mondri anResource.java:852) at mondrian.olap.Util.newInternal(Util.java:947) at mondrian.olap.MondrianDef$Join.getAlias(MondrianDe f.java:2125) at mondrian.rolap.RolapStar$Table.addJoin(RolapStar.j ava:1266) at mondrian.rolap.RolapCube.registerDimension(RolapCu be.java:1336) at mondrian.rolap.RolapLevel.init(RolapLevel.java:377 ) at mondrian.rolap.RolapHierarchy.init(RolapHierarchy. java:275) at mondrian.rolap.RolapDimension.init(RolapDimension. java:193) at mondrian.rolap.RolapCube.init(RolapCube.java:865) at mondrian.rolap.RolapCube.<init>(RolapCube.java:244 ) at mondrian.rolap.RolapSchema.load(RolapSchema.java:3 90) at mondrian.rolap.RolapSchema.load(RolapSchema.java:2 72) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :212) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :89) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.ja va:828) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.ja va:653) at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:141) at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:76) at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:120) at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:87) at com.tonbeller.jpivot.mondrian.MondrianModel.initia lize(MondrianModel.java:400) at com.tonbeller.jpivot.olap.model.OlapModelDecorator .initialize(OlapModelDecorator.java:129) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.i nitialize(OlapModelProxy.java:76) at com.tonbeller.jpivot.tags.PageStateManager.initial izeAndShow(PageStateManager.java:37) at com.tonbeller.jpivot.tags.OlapModelProxy.initializ eAndShow(OlapModelProxy.java:161) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(Ol apModelTag.java:76) at org.apache.jsp.WEB_002dINF.queries.activity_jsp._j spx_meth_jp_mondrianQuery_0(activity_jsp.java:126) at org.apache.jsp.WEB_002dINF.queries.activity_jsp._j spService(activity_jsp.java:64) at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.doI nclude(ApplicationDispatcher.java:574) at org.apache.catalina.core.ApplicationDispatcher.inc lude(ApplicationDispatcher.java:499) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(Incl udeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_include _0(testpage_jsp.java:277) at org.apache.jsp.testpage_jsp._jspService(testpage_j sp.java:122) at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandl er.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.h andleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilte r(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

    Pentaho BI Platform Tracking | 10 years ago | bcassidy123
    mondrian.olap.MondrianException: Mondrian Error:Internal error: join does not have alias at mondrian.resource.MondrianResource$_Def0.ex(Mondri anResource.java:852)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.olap.MondrianException

      Mondrian Error:Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1012)

      at mondrian.olap.Util.newInternal()
    2. mondrian.olap
      Util.assertTrue
      1. mondrian.olap.Util.newInternal(Util.java:823)
      2. mondrian.olap.Util.assertTrue(Util.java:804)
      2 frames
    3. mondrian.rolap.agg
      Segment.get
      1. mondrian.rolap.agg.Segment.get(Segment.java:187)
      1 frame