Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Own cube with adhoc.jsp works, Exception with JPivot

  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Default Own cube with adhoc.jsp works, Exception with JPivot

    Hi there,
    I am new to Pentaho, but so far, the product looks very promising!
    When I was trying to play around with my own data, I ran into the following problem:

    - Created own Cube with Schema Designer
    - Running own MDX queries in Schema Designer works perfectly
    - Running own MDX queries in the web-app adhoc.jsp on own Cube works perfectly (created new data source)

    But:
    - Accessing the cube with JPivot with testpage.jsp, I get the following exception (catalina.out):
    Code:
    [JPivot] 17 Dez 2007 14:46:06,542 ERROR [Session 40C95530BB760D8F1C877F19AF1CC0F8] com.tonbeller.wcf.component.RendererTag#doEndTag: trouble rendering table01
    java.lang.ClassCastException: java.lang.Long
    	at mondrian.rolap.RolapMember.getName(RolapMember.java:391)
    	at mondrian.olap.OlapElementBase.getCaption(OlapElementBase.java:82)
    	at mondrian.olap.MemberBase.getCaption(MemberBase.java:109)
    	at com.tonbeller.jpivot.mondrian.MondrianMember.getLabel(MondrianMember.java:79)
    	at com.tonbeller.jpivot.table.SpanBuilderImpl$RenderSwitch.visitMember(SpanBuilderImpl.java:111)
    	at com.tonbeller.jpivot.mondrian.MondrianMember.accept(MondrianMember.java:161)
    	at com.tonbeller.jpivot.table.SpanBuilderImpl.build(SpanBuilderImpl.java:142)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.AxisHeaderBuilderSupport.build(AxisHeaderBuilderSupport.java:63)
    	at com.tonbeller.jpivot.table.AxisBuilderSupport.buildHeading(AxisBuilderSupport.java:253)
    	at com.tonbeller.jpivot.table.RowAxisBuilderImpl.buildRow(RowAxisBuilderImpl.java:51)
    	at com.tonbeller.jpivot.table.TableComponent.buildRows2Dim(TableComponent.java:425)
    	at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:273)
    	at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234)
    	at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
    	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1390)
    	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:212)
    	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	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:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    	at java.lang.Thread.run(Thread.java:613)
    [JPivot] 17 Dez 2007 14:46:07,090 ERROR [Session 40C95530BB760D8F1C877F19AF1CC0F8] com.tonbeller.wcf.controller.RequestFilter$MyHandler#handleException: exeption
    org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.ClassCastException: java.lang.Long
    	at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	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:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    	at java.lang.Thread.run(Thread.java:613)
    Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.ClassCastException: java.lang.Long
    	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
    	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
    	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:246)
    	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
    	... 20 more
    Caused by: java.lang.ClassCastException: java.lang.Long
    	at mondrian.rolap.RolapMember.getName(RolapMember.java:391)
    	at mondrian.olap.OlapElementBase.getCaption(OlapElementBase.java:82)
    	at mondrian.olap.MemberBase.getCaption(MemberBase.java:109)
    	at com.tonbeller.jpivot.mondrian.MondrianMember.getLabel(MondrianMember.java:79)
    	at com.tonbeller.jpivot.table.SpanBuilderImpl$RenderSwitch.visitMember(SpanBuilderImpl.java:111)
    	at com.tonbeller.jpivot.mondrian.MondrianMember.accept(MondrianMember.java:161)
    	at com.tonbeller.jpivot.table.SpanBuilderImpl.build(SpanBuilderImpl.java:142)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.AxisHeaderBuilderSupport.build(AxisHeaderBuilderSupport.java:63)
    	at com.tonbeller.jpivot.table.AxisBuilderSupport.buildHeading(AxisBuilderSupport.java:253)
    	at com.tonbeller.jpivot.table.RowAxisBuilderImpl.buildRow(RowAxisBuilderImpl.java:51)
    	at com.tonbeller.jpivot.table.TableComponent.buildRows2Dim(TableComponent.java:425)
    	at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:273)
    	at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234)
    	at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
    	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1390)
    	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:212)
    	... 23 more
    [JPivot] 17 Dez 2007 14:46:07,102 ERROR [Session 40C95530BB760D8F1C877F19AF1CC0F8] com.tonbeller.wcf.controller.RequestFilter$MyHandler#handleException: cause
    javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.ClassCastException: java.lang.Long
    	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
    	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
    	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:246)
    	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	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:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    	at java.lang.Thread.run(Thread.java:613)
    Caused by: java.lang.ClassCastException: java.lang.Long
    	at mondrian.rolap.RolapMember.getName(RolapMember.java:391)
    	at mondrian.olap.OlapElementBase.getCaption(OlapElementBase.java:82)
    	at mondrian.olap.MemberBase.getCaption(MemberBase.java:109)
    	at com.tonbeller.jpivot.mondrian.MondrianMember.getLabel(MondrianMember.java:79)
    	at com.tonbeller.jpivot.table.SpanBuilderImpl$RenderSwitch.visitMember(SpanBuilderImpl.java:111)
    	at com.tonbeller.jpivot.mondrian.MondrianMember.accept(MondrianMember.java:161)
    	at com.tonbeller.jpivot.table.SpanBuilderImpl.build(SpanBuilderImpl.java:142)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
    	at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:81)
    	at com.tonbeller.jpivot.table.AxisHeaderBuilderSupport.build(AxisHeaderBuilderSupport.java:63)
    	at com.tonbeller.jpivot.table.AxisBuilderSupport.buildHeading(AxisBuilderSupport.java:253)
    	at com.tonbeller.jpivot.table.RowAxisBuilderImpl.buildRow(RowAxisBuilderImpl.java:51)
    	at com.tonbeller.jpivot.table.TableComponent.buildRows2Dim(TableComponent.java:425)
    	at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:273)
    	at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234)
    	at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
    	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1390)
    	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:212)
    	... 23 more
    Do you have an idea would could be running wrong? As I mentiones, the Cube itsself seems to be all right as it works fine with adhoc.jsp and the MDX query tool.

    Thanks very much!
    Dom
    Last edited by derkopp; 12-17-2007 at 09:55 AM.

  2. #2

    Default

    Hi Dom,
    I have the same problem. How do you resolve this problem?

    yosuan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.