PDA

View Full Version : "NullPointerException" after a query??



javartin
10-05-2003, 04:08 AM
Hi:
I defined a schema.xml for a cube like this:
<Cube name="Billform_Fact_Cube">
<Table name="billform_fact"/>
<Measure name="H@_Total" column="H@" aggregator="sum" formatString="#,###.00"/>
</Cube>
then I tried to run a "test.jsp" page that contains the following query:
<mdx:query name="query1" resultCache="true">
select
{[Measures].[H@_Total]} on columns
from Billform_Fact_Cube
</mdx:query>



<mdx:transform query="query1" xsltURI="/WEB-INF/mdxtable.xsl" xsltCache="false"/>
After executing the jsp page, I got the following error message:
..........................
Mondrian: loaded 0 system properties
Mondrian: JDBC driver sun.jdbc.odbc.JdbcOdbcDriver loaded successfully
Execute query took 230 millisec
java.lang.NullPointerException
at mondrian.web.taglib.TransformTag.doEndTag(TransformTag.java:58)
at org.apache.jsp.test2$jsp._jspService(test2$jsp.java:118)
It seems like the query was properly parsed and the db connection was ok as well. So, what could go wrong here???
Thanx
Martin

jhyde
10-23-2003, 05:29 AM
I don't know, but here are a few hints. (1) Does the query run in adhoc.jsp? (2) If you add a 'columns' axis, does this query run any better? (3) Maybe it's the '@' character in the measure name; try removing the '@' from the schema and see if it works any better.