Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: XAction Returns Wrong Model

  1. #1

    Default XAction Returns Wrong Model

    I am using RC2 on Windows XP against an MSSQL 2005 db. I have created an MDX model and an MDX query xaction. However, when I execute it I get a JPivot view of a different model. I restart Pentaho and I get a NullPointerException:

    21:49:35,063 ERROR [PivotViewComponent] Error Start: Pentaho 1.2.0 build 398 RC2

    21:49:35,063 ERROR [PivotViewComponent] 0360a6c6-5680-11db-a3c0-6d80c3018be3:COM
    PONENT:context-268686-1160279375003:dept_analysis.xaction Base.ERROR_0002 - Comp
    onent execution failed
    java.lang.NullPointerException
    at org.pentaho.plugin.olap.PivotViewComponent.executeAction(PivotViewCom
    ponent.java:174)
    at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:397)
    at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeConte
    xt.java:979)
    at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.
    java:951)
    at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext
    .java:867)
    at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.ja
    va:823)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContex
    t.java:729)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContex
    t.java:653)
    at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngi
    ne.java:251)
    at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:
    204)
    at org.apache.jsp.jsp.Pivot_jsp.getRuntimeForQuery(Pivot_jsp.java:68)
    at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:226)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
    .java:332)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
    14)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(Re
    questFilter.java:139)
    at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(Reques
    tSynchronizer.java:127)
    at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.jav
    a:263)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilte
    r.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
    lter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    alve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    alve.java:178)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
    yAssociationValve.java:175)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
    e.java:74)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
    ava:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
    ava:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
    ve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
    a:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
    :869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
    rocessConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
    int.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
    kerThread.java:112)
    at java.lang.Thread.run(Unknown Source)
    21:49:35,073 ERROR [PivotViewComponent] Error end:
    21:49:35,073 ERROR [RuntimeContext] 0360a6c6-5680-11db-a3c0-6d80c3018be3:RUNTIME
    :context-268686-1160279375003:dept_analysis.xaction RuntimeContext.ERROR_0012 -
    ActionDefinition for PivotViewComponent did not execute successfully

    The schema and query are very simple:

    Code:
    <Schema>
       <Dimension name="Department" foreignkey="tf_d_id">
           <Hierarchy hasall="true" allmembername="All Depts" primarykey="d_id">
              <Table name="dept_dim"/>
              <Level name="Department" column="d_name" uniquemembers="true"/>
           </Hierarchy>
       </Dimension>
       <Cube name="testcube">
          <Table name="test_fact"/>
          <DimensionUsage name="Department" source="Department"/>
          <Measure name="FundedAmount" column="tf_number" aggregator="sum" formatstring="#,###"/>
       </Cube>
    </Schema>
    Code:
    SELECT  [Measures] ON ROWS
    FROM [testcube]
    Any thoughts?

    Bill

  2. #2
    Join Date
    Nov 1999
    Posts
    579

    Default Re:XAction Returns Wrong Model

    Have you successfully created an action sequence using an MDX Lookup Rule using that query against that model?

    For troubleshooting purposes, it's far easier to troubleshoot JPivot out of the equation, and just do an MDXLookupRule for testing.

    Let us know how that works,

    Marc

  3. #3

    Default Re:XAction Returns Wrong Model

    Marc,

    I am still unable to get the result set back. I have a very simple one dimension, one measure model. Most other MDX models work fine. I have found this part of the suite the most unforgiving.

    I have tried to download the recent post of the cube designer to try and remove that part of the equation, but only the Linux version is downloading. Is the Windows version available?

    I will post the detailed information (model, logs, etc.) to provide more information.

    Bill

  4. #4

    Question same problem

    Hi,

    Did you have any luck with this error? I'm getting the same problem.

    Thanks

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.