Help save net neutrality! Learn more.
Close

JPivot XMLA issues connecting to MS SSAS 2005

Help
Shibu
2008-05-06
2013-04-29
  • Shibu

    Shibu - 2008-05-06

    Hi

    I am getting the following issue when I’m trying to connect to Microsoft Analysis Services 2005 thru JPivot 1.6/1.7/1.8 using XMLA interface.

    The scenario when I am getting the following error is as follows.

    I have 2 measures selected for my measures dimension. I am able to see my Geography Hierarchy on my rows and also able to drilldown on its levels and everything works fine.  When I move one of my Time Hierarchy to Rows then I am getting errors when I do drilldown operation. I have two hierarchies for my Time dimension.

    Any help regarding this would be helpful.

    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.genExp(ExpGenerator.java:73)
        at com.tonbeller.jpivot.olap.query.Quax.genNormalExp(Quax.java:1130)
        at com.tonbeller.jpivot.olap.query.Quax.genExp(Quax.java:1105)
        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:246)
        at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251)
        at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235)
        at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
        at org.apache.jsp.testpage_jsp._jspx_meth_wcf_render_7(testpage_jsp.java:1295)
        at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:231)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        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: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:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        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)

    Thanks
    Shibu.

     
    • DerShodan

      DerShodan - 2008-11-06

      I know, this is no help for you at all ... but would you please be so kind and tell me what your connection string is? (queryname.jsp)
      I am unable to connect to SSAS 2008 and hope that a proper 2005 connection string will work.

      Thanks a lot for this in adcvance :)

       

Log in to post a comment.