Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: query01.result.overflowOccured

  1. #1

    Default query01.result.overflowOccured

    hi every1,
    im getting this wierd overflow error. i read that this had nothing to do with data in DB but is some genaral mondrian error. so this is what I did, it is realy wierd:
    1. added cube called "Bilans" to the mondrian.xml
    2. added table called "bilans" to mondrian.mdb database for testing
    3. made simple query:
    select {[Measures].[Plan], [Measures].[2005], [Measures].[2006]} ON COLUMNS,
    {([Firma].[Sve Firme], [Kategorija].[Sve Kategorije])} ON ROWS
    from [Bilans]
    which works fine from adhoc input script.
    query works also fine when cube is a part of the original foodmart.xml, but when I delete all the original content from it and leave just my cube it gives this overflow error.
    my scheme is thus:
    <?xml version="1.0"?>
    <Schema name="FoodMart">
    <Cube name="Bilans">
    <Table name="bilans"/>
    <Dimension name="Firma">
    <Hierarchy hasAll="true" allMemberName="Sve Firme">
    <Table name="bilans"/>
    <Level name="Firma" column="ime" uniqueMembers="true"/>
    </Hierarchy>
    </Dimension>
    <Dimension name="Kategorija">
    <Hierarchy hasAll="true" allMemberName="Sve Kategorije">
    <Table name="bilans"/>
    <Level name="Kategorija" column="kategorija" uniqueMembers="true"/>
    </Hierarchy>
    </Dimension>
    <Measure name="Plan" column="plan" aggregator="sum"
    formatString="#,###"/>
    <Measure name="2005" column="2005" aggregator="sum"
    formatString="#,###"/>
    <Measure name="2006" column="2006" aggregator="sum"
    formatString="#,###"/>
    </Cube>
    </Schema>
    my query:
    <jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbcdbc:MondrianFoodMart" catalogUri="/WEB-INF/queries/FoodMart.xml">
    select {[Measures].[Plan], [Measures].[2005], [Measures].[2006]} ON COLUMNS,
    {([Firma].[Sve Firme], [Kategorija].[Sve Kategorije])} ON ROWS
    from [Bilans]
    </jp:mondrianQuery>
    <c:set var="title01" scope="session">ASA BIP - Test Query</c:set>
    error trace:
    [JPivot] 10 Oct 2006 12:52:50,069 ERROR [Session 5AD29FBD4E22AB397712BF7726A701BF] com.tonbeller.wcf.controller.RequestFilter$MyHandler#handleException: cause
    javax.servlet.ServletException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Plan], [Measures].[2005], [Measures].[2006]} ON COLUMNS,
    {([Firma].[Sve Firme], [Kategorija].[Sve Kategorije])} ON ROWS
    from [Bilans]
    ])
    at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
    at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:258)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
    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)

  2. #2

    Default addition info

    ok this is what I figured out:
    when I run my query first in the ad hoc jsp and then run my query the mondrian genarates the correct output without any problems.
    any ideas why it want run directly ????
    pls help this is messing me up for 3 days now :SS

  3. #3
    Join Date
    Nov 1999
    Posts
    459

    Default ${query01.result.overflowOccured} with reserved words

    Some things need time to get an answer ;-)

    An error occurred while evaluating custom action attribute "test"
    with value "${query01.result.overflowOccured}": [...]

    I also got this message when the reserved word "titel" was used with a MS SQL database. I saw you also use an (ofter) not allowed column name like "2005" or "plan".
    We changed the "titel" to another name and it works now.

    Cheers,
    Jens

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.