Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error while executing query

  1. #1
    Join Date
    Oct 2006
    Posts
    7

    Default Error while executing query

    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

  2. #2
    Join Date
    Aug 2007
    Posts
    4

    Unhappy I have the same problem

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

  3. #3
    Join Date
    Jul 2007
    Posts
    18

    Default

    Are you tried it with the default query?

    <query>default</query>
    Last edited by Gemelos; 09-04-2007 at 04:59 AM.

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.