Jpivote – data overflow

2008-07-18
2013-04-29
  • mark lichtner
    mark lichtner
    2008-07-18

    Microsoft has changed some conventions in SSAS (2005) and it is causing problems with Jpivot.
    The problem appears while performing drill down in dimension and there is following error displayed consequently.  Can anyone help on this issue?

    "Could not display this resultset - data overflow.  Consider using filter instead of drill down..."

    org.apache.jasper.JasperException: javax.servlet.jsp.JspException: java.lang.NullPointerException
    org.apache.jasper.JasperException: javax.servlet.jsp.JspException: java.lang.NullPointerException
        at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        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:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

    javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
    javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
        at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:837)
        at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
        at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:255)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        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:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

    java.lang.NullPointerException
    java.lang.NullPointerException
        at com.tonbeller.jpivot.xmla.XMLA_QuaxUti.isFunCallTo(XMLA_QuaxUti.java:692)
        at com.tonbeller.jpivot.olap.query.ExpGenerator.bracesAround(ExpGenerator.java:191)
        at com.tonbeller.jpivot.olap.query.ExpGenerator.genExpForNode(ExpGenerator.java:145)
        at com.tonbeller.jpivot.olap.query.ExpGenerator.genExp(ExpGenerator.java:65)
        at com.tonbeller.jpivot.olap.query.Quax.genNormalExp(Quax.java:1129)
        at com.tonbeller.jpivot.olap.query.Quax.genExp(Quax.java:1104)
        at com.tonbeller.jpivot.xmla.XMLA_QueryAdapter.onExecute(XMLA_QueryAdapter.java:134)
        at com.tonbeller.jpivot.xmla.XMLA_Model.getResult(XMLA_Model.java:209)
        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.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1195)
        at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:221)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        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:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

     
    • mark lichtner
      mark lichtner
      2008-07-29

      Here is an example:

      When doing OLAP cube on MS SQL 2000 Analysis services and get connected via jPivot, using the same source data, everything works fine.

      When doing OLAP cube on MS SQL2005 SSAS, while drilling into the dimension jPivot randomly fails with error mentioned above.  The combination of multiple dimensions to one axis worsens  the issue even more.

       
    • Julian Hyde
      Julian Hyde
      2008-07-30

      The message 'ResultSet overflow occured' (sic) is JPivot's equivalent of Oracle's 'ORA-00600', IBM's ABEND or mondrian's 'Internal error'. I just means 'something went wrong'.

      From the error stack, it looks like JPivot found something in the parse tree that it wasn't expecting. Maybe a non-standard function? Please post the MDX that JPivot was executing.

       
      • mark lichtner
        mark lichtner
        2008-08-01

        Our developer considered a better subject for the matter, as the jpivot crashes with - NullPointerException.

        We have tested the issue via profiler and jPivot is not sending any MDX :-(.  It is probably due to that jPivot is not able to generate correct MDX from selected data.

        I attach the MDX that performs the operation OK.
        "
        SELECT NON EMPTY Union(CrossJoin({[Monitoring].[Site-Monitoring-Question].[SiteName].[PPRD-CON021]}, {[Measures].[Answer SUM], [Measures].[Answer AVG]}), CrossJoin({[Monitoring].[Site-Monitoring-Question].[SiteName].[PROD-con009]}, {[Measures].[Answer SUM], [Measures].[Answer AVG]})) ON columns, NON EMPTY CrossJoin(Hierarchize(Union(Union(Union({[Time].[Year-Quarter-Month-Day].[All]}, [Time].[Year-Quarter-Month-Day].[All].Children), [Time].[Year-Quarter-Month-Day].[Year].[2007].Children), [Time].[Year-Quarter-Month-Day].[Quarter].[Q1].Children)), {([Product Flat].[Product].[All], [Territory Flat].[Territory].[All])}) ON rows FROM [Monitoring]
        "
        Consequently when clicking on [Product Flat].[Product], it crashes on java.lang.NullPointerException without SSAS sending any MDX.