java.lang.NullPointerException

Pentaho BI Platform Tracking | hhaas | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    The following MDX causes a Nullpointer Exception. with member [Measures].[Average Unit Sales] as 'Avg (Descendants([Time].CurrentMember, [Time].[Month]), [Measures].[Unit Sales])' member [Measures].[Max Unit Sales] as 'Max (Descendants([Time].CurrentMember, [Time].[Month]), [Measures].[Unit Sales])' select {[Measures].[Average Unit Sales], [Measures]. [Max Unit Sales], [Measures].[Unit Sales]} ON columns, NON EMPTY Order( Crossjoin( {[Store].[All Stores].[USA].[OR].[Portland], [Store].[All Stores].[USA].[OR].[Salem], [Store].[All Stores].[USA]. [OR].[Salem].[Store 13], [Store].[All Stores].[USA].[CA]. [San Francisco], [Store].[All Stores].[USA].[CA].[San Diego], [Store].[All Stores].[USA].[CA].[Beverly Hills], [Store].[All Stores].[USA].[CA].[Los Angeles], [Store]. [All Stores].[USA].[WA].[Walla Walla], [Store].[All Stores].[USA].[WA].[Bellingham], [Store].[All Stores]. [USA].[WA].[Yakima], [Store].[All Stores].[USA].[WA]. [Spokane], [Store].[All Stores].[USA].[WA].[Seattle], [Store].[All Stores].[USA].[WA].[Bremerton], [Store].[All Stores].[USA].[WA].[Tacoma]}, [Time].[Year].Members), [Measures].[Average Unit Sales], ASC) ON rows from [Sales] The stack trace is java.lang.NullPointerException at mondrian.olap.fun.HierarchicalArrayComparator.compare HierarchicallyButSiblingsByValue(FunUtil.java:1118) at mondrian.olap.fun.HierarchicalArrayComparator.compare (FunUtil.java:1082) at mondrian.olap.fun.ArrayComparator.compare (FunUtil.java:1043) at java.util.Arrays.mergeSort (Arrays.java:1237) at java.util.Arrays.mergeSort (Arrays.java:1244) at java.util.Arrays.mergeSort (Arrays.java:1244) at java.util.Arrays.mergeSort (Arrays.java:1244) at java.util.Arrays.sort(Arrays.java:1185) at java.util.Collections.sort (Collections.java:151) at mondrian.olap.fun.FunUtil.sort (FunUtil.java:435) at mondrian.olap.fun.BuiltinFunTable$69.evaluate (BuiltinFunTable.java:2428) at mondrian.rolap.RolapEvaluator.xx (RolapEvaluator.java:129) at mondrian.olap.FunCall.evaluate (FunCall.java:247) at mondrian.rolap.RolapResult.executeAxis (RolapResult.java:152) at mondrian.rolap.RolapResult. (RolapResult.java:68) at mondrian.rolap.RolapConnection.execute (RolapConnection.java:198) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult (MondrianModel.java:125) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.get Result(OlapModelDecorator.java:36) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getRe sult(CachingOlapModel.java:26) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.get Result(OlapModelDecorator.java:36) at com.tonbeller.bii.scroll.ScrollableOlapModel.getResult (ScrollableOlapModel.java:74) at com.tonbeller.jpivot.table.TableComponent.render2 (TableComponent.java:150) at com.tonbeller.jpivot.table.TableComponent.render (TableComponent.java:142) at com.tonbeller.wcf.component.RendererTag.doEndTag (RendererTag.java:48) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_render_9 (testpage_jsp.java:1587) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_env_0 (testpage_jsp.java:499) at org.apache.jsp.testpage_jsp._jspService (testpage_jsp.java:259) at org.apache.jasper.runtime.HttpJspBase.service (HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile (JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service (JspServlet.java:241) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalD oFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at com.tonbeller.bii.print.FoFilter.doFilter (FoFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalD oFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.nor malRequest(RequestFilter.java:56) at com.tonbeller.wcf.controller.RequestSynchronizer.handle Request(RequestSynchronizer.java:62) at com.tonbeller.wcf.controller.RequestFilter.doFilter (RequestFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalD oFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipe lineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipe lineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipe lineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipe lineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipe lineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipe lineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service (CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11Connect ionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt (PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunna ble.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:536)

    Pentaho BI Platform Tracking | 1 decade ago | hhaas
    java.lang.NullPointerException

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at mondrian.olap.fun.HierarchicalArrayComparator.compareHierarchicallyButSiblingsByValue()
    2. mondrian.olap.fun
      ArrayComparator.compare
      1. mondrian.olap.fun.HierarchicalArrayComparator.compareHierarchicallyButSiblingsByValue(FunUtil.java:1118)
      2. mondrian.olap.fun.HierarchicalArrayComparator.compare(FunUtil.java:1082)
      3. mondrian.olap.fun.ArrayComparator.compare(FunUtil.java:1043)
      3 frames
    3. Java RT
      Collections.sort
      1. java.util.Arrays.mergeSort(Arrays.java:1237)
      2. java.util.Arrays.mergeSort(Arrays.java:1244)
      3. java.util.Arrays.mergeSort(Arrays.java:1244)
      4. java.util.Arrays.mergeSort(Arrays.java:1244)
      5. java.util.Arrays.sort(Arrays.java:1185)
      6. java.util.Collections.sort(Collections.java:151)
      6 frames
    4. mondrian.olap.fun
      BuiltinFunTable$69.evaluate
      1. mondrian.olap.fun.FunUtil.sort(FunUtil.java:435)
      2. mondrian.olap.fun.BuiltinFunTable$69.evaluate(BuiltinFunTable.java:2428)
      2 frames
    5. mondrian.rolap
      RolapEvaluator.xx
      1. mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
      1 frame
    6. mondrian.olap
      FunCall.evaluate
      1. mondrian.olap.FunCall.evaluate(FunCall.java:247)
      1 frame
    7. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:152)
      2. mondrian.rolap.RolapResult.<init>(RolapResult.java:68)
      3. mondrian.rolap.RolapConnection.execute(RolapConnection.java:198)
      3 frames
    8. com.tonbeller.jpivot
      OlapModelDecorator.getResult
      1. com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:125)
      2. com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:36)
      3. com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:26)
      4. com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:36)
      4 frames
    9. com.tonbeller.bii
      ScrollableOlapModel.getResult
      1. com.tonbeller.bii.scroll.ScrollableOlapModel.getResult(ScrollableOlapModel.java:74)
      1 frame
    10. com.tonbeller.jpivot
      TableComponent.render
      1. com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:150)
      2. com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:142)
      2 frames
    11. com.tonbeller.wcf
      RendererTag.doEndTag
      1. com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:48)
      1 frame
    12. org.apache.jsp
      testpage_jsp._jspService
      1. org.apache.jsp.testpage_jsp._jspx_meth_wcf_render_9(testpage_jsp.java:1587)
      2. org.apache.jsp.testpage_jsp._jspx_meth_wcf_env_0(testpage_jsp.java:499)
      3. org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:259)
      3 frames
    13. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
      1 frame
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      1 frame
    15. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
      3 frames
    16. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      1 frame
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    18. com.tonbeller.bii
      FoFilter.doFilter
      1. com.tonbeller.bii.print.FoFilter.doFilter(FoFilter.java:47)
      1 frame
    19. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    20. com.tonbeller.wcf
      RequestFilter.doFilter
      1. com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:56)
      2. com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:62)
      3. com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:71)
      3 frames
    21. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
      4. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      6. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      8. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      10. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      11. org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
      12. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      13. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      14. org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
      15. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      16. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      17. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      18. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      19. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      20. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      21. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      22. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      23. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      23 frames
    22. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
      1 frame
    23. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
      3 frames
    24. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
      1 frame
    25. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:536)
      1 frame