MDX Support in JPivot

2005-07-19
2013-04-29
  • Hi,

    I am trying to execute the query

    SELECT {[Measures].Members} ON columns, {Dimensions(1.0).Members} ON rows
    FROM [HR]

    from JPivot /testpage.jsp but this is resulting in the following exception. Could any one tell what is wrong in JPivot impl.

    -----------------------

    com.tonbeller.wcf.utils.SoftException: java.lang.NullPointerException
    com.tonbeller.wcf.utils.SoftException: java.lang.NullPointerException
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:102)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.validate(ConverterImpl.java:65)
        at com.tonbeller.wcf.form.FormComponent.validate(FormComponent.java:100)
        at com.tonbeller.wcf.form.ButtonHandler.request(ButtonHandler.java:91)
        at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:166)
        at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:103)
        at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:70)
        at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:122)
        at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:114)
        at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:242)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
    Caused by: java.lang.NullPointerException
        at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.(MondrianQueryAdapter.java:65)
        at com.tonbeller.jpivot.mondrian.MondrianModel.setUserMdx(MondrianModel.java:695)
        at com.tonbeller.jpivot.mondrian.MondrianMdxQuery.setMdxQuery(MondrianMdxQuery.java:45)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773)
        at org.apache.commons.beanutils.PropertyUtilsBean.setSimpleProperty(PropertyUtilsBean.java:1759)
        at org.apache.commons.beanutils.PropertyUtilsBean.setNestedProperty(PropertyUtilsBean.java:1648)
        at org.apache.commons.beanutils.PropertyUtilsBean.setProperty(PropertyUtilsBean.java:1677)
        at org.apache.commons.beanutils.PropertyUtils.setProperty(PropertyUtils.java:559)
        at com.tonbeller.wcf.convert.EditCtrlConverter.convert(EditCtrlConverter.java:72)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:88)
        ... 28 more

    java.lang.NullPointerException
    java.lang.NullPointerException
        at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.(MondrianQueryAdapter.java:65)
        at com.tonbeller.jpivot.mondrian.MondrianModel.setUserMdx(MondrianModel.java:695)
        at com.tonbeller.jpivot.mondrian.MondrianMdxQuery.setMdxQuery(MondrianMdxQuery.java:45)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773)
        at org.apache.commons.beanutils.PropertyUtilsBean.setSimpleProperty(PropertyUtilsBean.java:1759)
        at org.apache.commons.beanutils.PropertyUtilsBean.setNestedProperty(PropertyUtilsBean.java:1648)
        at org.apache.commons.beanutils.PropertyUtilsBean.setProperty(PropertyUtilsBean.java:1677)
        at org.apache.commons.beanutils.PropertyUtils.setProperty(PropertyUtils.java:559)
        at com.tonbeller.wcf.convert.EditCtrlConverter.convert(EditCtrlConverter.java:72)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:88)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.traverse(ConverterImpl.java:111)
        at com.tonbeller.wcf.convert.ConverterImpl.validate(ConverterImpl.java:65)
        at com.tonbeller.wcf.form.FormComponent.validate(FormComponent.java:100)
        at com.tonbeller.wcf.form.ButtonHandler.request(ButtonHandler.java:91)
        at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:166)
        at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:103)
        at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:70)
        at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:122)
        at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:114)
        at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:242)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)