I don't understand this error. The same query with the last version works well. Is there anybody which could help me ?
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am getting exactly the same error when running the application on linux. The interesting thing is that when the same versions of Tomcat/JPivot/Mondrian is used on windows it works perfectly!
I was wondering if you got to a solution for this problem
Thank You,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
in the root directory (or possibly in the WEB-INF directory) there is a "mondrian.properties" file which contains the max number of rows that a SQL query may return. If a query returns more elements, an overflow exception is thrown. This helps to avoids queries to run "forever" and make the server hang.
To disable this feature set the value to 0.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I haved the same problem while trying to make sql filtering on a dimension: i think this error is not due to a real results overflow but it is a sql-level error; sorry but i don't know more!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been developing a complex model with mondrian 1.1.5 version and this error is really an SQL error.
In previous versions of mondrian / jpivot it appears differently (try an old version).
The stack trace of the exception usually shows the real error at bottom.
For example, when a query is incorrect because a column is mispelled it appears "overflow" on top and an driver specific error at the bottom ("[Microsoft Access][ODBC] Error: to few parameters" or so).
I also had this error because I exported a DB from Oracle to Access and the keys where imported as float values instead of integer values.
Hope this helps.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I have the same error and it's not caused by an overflow. Do you have a solution yet?
I'm using Ms Access via jdbc:odbc...
As I saw in the generated SQL there should be a tablejoin, but there is none.
For example:
Select a.col1, b.col2 from a where a.foreignId = b.key... ODBC says: unkown parameter b.key
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
if you want better error feedback comment the following lines in your calling jsp page (for example testpage.jsp )
<%-- if there was an overflow, show error message -<c:if test="${query01.result.overflowOccured}">
<p>
<strong style="color:red">Resultset overflow occured</strong>
<p>
</c:if>
-%>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
MDX:
[code]
select {[Date].[All Date]} ON columns, Hierarchize(Union(Union({[Kpi].[All Kpi]}, [Kpi].[All Kpi].Children), [Kpi].[All Kpi].[Financieel].Children)) ON rows from [Bsc]
[/code]
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache;
SQL:
[code]
select `kpi`.`name` as `c0` from `kpi` as `kpi` where `kpi`.`perspId` = `persp`.`perspId` and `persp`.`name` = 'Financieel' group by `kpi`.`name` order by `kpi`.`name`
[/code]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok, I cannot generate DDL from ms access, but I can tell you I have a table named fact, with the columns (Id, kpiId, perspId, month, year, val) and a table kpi( id, name, perspId) and a table persp(id, name).
This is a bug in jpivot-1.3, it hides another exeption. Try to remove the <c:if .../> from the testpage.jsp, that evaluates the "overflowOccured" attribute of the query01
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hello ,
thanks for reply ,
if i remove the <c:if .../> from the testpage.jsp , i get other error :
Caused by: java.lang.UnsupportedOperationException
at mondrian.rolap.RolapAggregator$6.aggregate(RolapAggregator.java:67)
at mondrian.olap.fun.BuiltinFunTable$41.evaluate(BuiltinFunTable.java:1146)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:168)
at mondrian.olap.FunCall.evaluate(FunCall.java:254)
at mondrian.olap.ExpBase.evaluateScalar(ExpBase.java:109)
at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:216)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:265)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:293)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:293)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:218)
at mondrian.rolap.RolapResult.(RolapResult.java:143)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:326)
... 46 more
i dont' understand what can i do to resolve problem !
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't understand this error. The same query with the last version works well. Is there anybody which could help me ?
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
I am getting exactly the same error when running the application on linux. The interesting thing is that when the same versions of Tomcat/JPivot/Mondrian is used on windows it works perfectly!
I was wondering if you got to a solution for this problem
Thank You,
in the root directory (or possibly in the WEB-INF directory) there is a "mondrian.properties" file which contains the max number of rows that a SQL query may return. If a query returns more elements, an overflow exception is thrown. This helps to avoids queries to run "forever" and make the server hang.
To disable this feature set the value to 0.
I haved the same problem while trying to make sql filtering on a dimension: i think this error is not due to a real results overflow but it is a sql-level error; sorry but i don't know more!
I have been developing a complex model with mondrian 1.1.5 version and this error is really an SQL error.
In previous versions of mondrian / jpivot it appears differently (try an old version).
The stack trace of the exception usually shows the real error at bottom.
For example, when a query is incorrect because a column is mispelled it appears "overflow" on top and an driver specific error at the bottom ("[Microsoft Access][ODBC] Error: to few parameters" or so).
I also had this error because I exported a DB from Oracle to Access and the keys where imported as float values instead of integer values.
Hope this helps.
Hi, I have the same error and it's not caused by an overflow. Do you have a solution yet?
I'm using Ms Access via jdbc:odbc...
As I saw in the generated SQL there should be a tablejoin, but there is none.
For example:
Select a.col1, b.col2 from a where a.foreignId = b.key... ODBC says: unkown parameter b.key
Is this against the FoodMart database?
Can you show the MDX and the relevant parts of your schema?
Sherman
if you want better error feedback comment the following lines in your calling jsp page (for example testpage.jsp )
<%-- if there was an overflow, show error message -<c:if test="${query01.result.overflowOccured}">
<p>
<strong style="color:red">Resultset overflow occured</strong>
<p>
</c:if>
-%>
Hi, no it's not foodmart, but my own very simple balanced scorecard database. It happens when I drilldown on the kpi dimension
Exception:
[code]
javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query
[/code]
MDX:
[code]
select {[Date].[All Date]} ON columns, Hierarchize(Union(Union({[Kpi].[All Kpi]}, [Kpi].[All Kpi].Children), [Kpi].[All Kpi].[Financieel].Children)) ON rows from [Bsc]
[/code]
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache;
SQL:
[code]
select `kpi`.`name` as `c0` from `kpi` as `kpi` where `kpi`.`perspId` = `persp`.`perspId` and `persp`.`name` = 'Financieel' group by `kpi`.`name` order by `kpi`.`name`
[/code]
The SQL is generated by Mondrian based on its interpretation of the schema. Please show the schema of the Bsc cube.
Sherman
Ok, I cannot generate DDL from ms access, but I can tell you I have a table named fact, with the columns (Id, kpiId, perspId, month, year, val) and a table kpi( id, name, perspId) and a table persp(id, name).
By the way.. I just found a bug report on this issue
http://sourceforge.net/tracker/index.php?func=detail&aid=1209659&group_id=35302&atid=414613
Please post your Mondrian schema.
Sherman
the primary key of the table persp is of course perspId
This one works:
<Dimension name="Kpi">
<Hierarchy hasAll="true" primaryKey="kpiId" allMemberName="All Kpi" primaryKeyTable="kpi">
<Join leftKey="perspId" rightKey="perspId">
<Table name="kpi"/>
<Table name="persp"/>
</Join>
<Level name="perspectiveId" table="persp" column="perspId" type="Numeric" uniqueMembers="false"/>
<Level name="perspective" table="persp" column="name" uniqueMembers="false"/>
<Level name="kpi" table="kpi" column="name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
And this one doesn't work:
<Dimension name="Kpi">
<Hierarchy hasAll="true" primaryKey="kpiId" allMemberName="All Kpi" primaryKeyTable="kpi">
<Join leftKey="perspId" rightKey="perspId">
<Table name="kpi"/>
<Table name="persp"/>
</Join>
<Level name="perspective" table="persp" column="name" uniqueMembers="false"/>
<Level name="kpi" table="kpi" column="name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
i obtain the same error with foodmart schema when i would test other query
my querie is :
select {[Measures].[Employee Salary]} on columns,
{[Employees]} ON rows
from HR
any one can test this query
thanks
This is a bug in jpivot-1.3, it hides another exeption. Try to remove the <c:if .../> from the testpage.jsp, that evaluates the "overflowOccured" attribute of the query01
hello ,
thanks for reply ,
if i remove the <c:if .../> from the testpage.jsp , i get other error :
Caused by: java.lang.UnsupportedOperationException
at mondrian.rolap.RolapAggregator$6.aggregate(RolapAggregator.java:67)
at mondrian.olap.fun.BuiltinFunTable$41.evaluate(BuiltinFunTable.java:1146)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:168)
at mondrian.olap.FunCall.evaluate(FunCall.java:254)
at mondrian.olap.ExpBase.evaluateScalar(ExpBase.java:109)
at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:216)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:265)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:293)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:293)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:218)
at mondrian.rolap.RolapResult.(RolapResult.java:143)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:326)
... 46 more
i dont' understand what can i do to resolve problem !