Error while executing query

[arya]

Hi, I'created a schema using cubedesigner, created a mdx query to run on that cube, but I get the following error:


JPivot had an error ...

org.apache.jasper.JasperException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[InvoiceCost], [Measures].[ComissionValue]} ON COLUMNS, {([TeamId].[All teamid], [CustomerId].[All customerid])} ON ROWS from [testcube] ]

org.apache.jasper.JasperException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[InvoiceCost], [Measures].[ComissionValue]} ON COLUMNS,
{([TeamId].[All teamid], [CustomerId].[All customerid])} ON ROWS
from [testcube]
]
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
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(Unknown Source)


Don't know what's wrong with my query. Can anyone see the problem?

Thanks

Post edited by: arya, at: 2006/11/07 13:57

[danielTMG]

I have the same problem for a very similar query:

select
{[Measures].[Increments], [Measures].[Decrements]} on columns,
{[Subscription_id].[All Subscriptions]} ON rows
from Subscriptions

and my cube is:

<Dimension name="Subscription_id">
<Hierarchy hasAll="true" allMemberName="All Subscriptions" primaryKey="subscription_id">
<Table name="subscription_content_code"/>
<Level name="aggregator" column="aggregator"
uniqueMembers="true"/>
<Level name="keyword" column="log_keyword" uniqueMembers="true"/>
</Hierarchy>
</Dimension>

<!-- Sales -->
<Cube name="Subscriptions">
<Table name="acc_subscription_customers"/>
<DimensionUsage name="Subscription_id" source="Subscription_id" foreignKey="subscription_id"/>
<DimensionUsage name="Operator" source="Operator"
foreignKey="operator"/>
<DimensionUsage name="Time" source="Time" foreignKey="sqldate"/>

<Measure name="Increments" column="increments" aggregator="sum"
formatString="Standard"/>
<Measure name="Decrements" column="decrements" aggregator="sum"
formatString="Standard"/>

<CalculatedMember
name="Difference"
dimension="Measures">
<Formula>[Measures].[Increments] - [Measures].[Decrements]</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,###"/>
</CalculatedMember>

</Cube>


Please, can anyone helps???

[Gemelos]

Are you tried it with the default query?

<query>default</query>