XAction Returns Wrong Model

[billw]

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:

<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>

SELECT  [Measures] ON ROWS
FROM [testcube]

Any thoughts?

Bill

[mbatchelor]

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

[billw]

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

[dbzak]

Hi,

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

Thanks