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)