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] ]

Pentaho BI Platform Tracking | scudderfish | 1 decade ago
  1. 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] ]
  2. 0

    Error Occurred While getting Resultset -- di BI Server

    Google Groups | 6 years ago | akulupa
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Nilai]} ON COLUMNS, {[Waktu].[All Waktus]} ON ROWS from [PendapatanOperasional] ])
  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

    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 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:821) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)

    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: 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()
    2. GWT dev
      PageContextImpl.handlePageException
      1. org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:821)
      2. org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
      2 frames
    3. org.apache.jsp
      test_jsp._jspService
      1. org.apache.jsp.test_jsp._jspService(test_jsp.java:108)
      1 frame
    4. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      1 frame
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      1 frame
    6. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      3 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      1 frame
    8. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      2 frames
    9. com.tonbeller.wcf
      RequestFilter.doFilter
      1. com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
      2. com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
      3. com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
      3 frames
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      2 frames
    11. uk.co.cartesian
      AscertainSessionFilter.doFilter
      1. uk.co.cartesian.ascertain.web.session.filter.AscertainSessionFilter.doFilter(AscertainSessionFilter.java:189)
      1 frame
    12. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
      4. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      6. org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
      8. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      10. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
      11. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      12. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      13. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      14. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      15. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      16. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      17. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      18. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      18 frames
    13. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      1 frame
    14. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
      3 frames
    15. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
      1 frame
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame