Jump to content
Changes to the Jaspersoft community edition download ×

updated to 1.1.0 mondrian crashes


kidpollo

Recommended Posts

I managed to update my jasper intelligence installation from 1.0.1 to 1.1.0 manually, I installed 1.1.0 with the bit rock installer and updated the database, everything works smoothly except the mondrian views I had working.

 

I get an error like this

 

Code:

Pivot had an error ...

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoSuchFieldError: CubeRelationNotTable

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoSuchFieldError: CubeRelationNotTable
java.lang.NoSuchFieldError: CubeRelationNotTable
at mondrian.rolap.aggmatcher.ExplicitRules$Group.make(ExplicitRules.java:110)
at mondrian.rolap.RolapCube.loadAggGroup(RolapCube.java:341)
at mondrian.rolap.RolapCube.(RolapCube.java:239)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:309)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:229)
at mondrian.rolap.RolapSchema.(RolapSchema.java:159)
at mondrian.rolap.RolapSchema.(RolapSchema.java:49)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:802)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:636)
at mondrian.rolap.RolapConnection.(RolapConnection.java:138)
at mondrian.rolap.RolapConnection.(RolapConnection.java:73)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:120)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:87)
at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:386)
.
.
.

 

any ideas?

Link to comment
Share on other sites

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Hi,

there's my schema

Code:

<?xml version="1.0"?>

<Schema name="Zustatkyy">

<Dimension name="Accounts">
<Hierarchy hasAll="true" allMemberName="All Accounts" primaryKey="ac">
<Table name="vb.tblaccbridge" alias="tblaccbridge"/>
<Level name="Accounts" column="ac" nameColumn="ACNameLL" uniqueMembers="true" type="String"/>
</Hierarchy>
</Dimension>

<Dimension name="Clients">
<Hierarchy hasAll="true" allMemberName="All Clients" primaryKey="c_cnum">
<Table name="vb.tblcusts" alias="tblcusts"/>
<Level name="Clients" column="c_cnum" nameColumn="c_bbcrnm" uniqueMembers="true" type="String"/>
</Hierarchy>
</Dimension>

<Dimension name="Account officers">
<Hierarchy hasAll="true" allMemberName="All Account officers" primaryKey="ao">
<View alias="bs_todayO">
<SQL dialect="generic">
select distinct ao from vb.bs_today
</SQL>
</View>
<Level name="Account officer" column="ao" nameColumn="ao" uniqueMembers="true" type="String"/>
</Hierarchy>
</Dimension>


<Cube name="Zustatky">
<View alias="bs_today">
<SQL dialect="generic">
<![CDATA[
SELECT*,(IF(grp='ASS',czkeq,0)+IF(grp='ASL' AND czkeq>0,czkeq,0)) as czkeqO,(IF(grp='ASS',if(czkeq>0,czkeq*indb,czkeq*incr),0)+IF(grp='ASL' AND czkeq>0,czkeq*indb,0))/(IF(grp='ASS',czkeq,0)+IF(grp='ASL' AND czkeq>0,czkeq,0)) AS i_assO,
(IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq,0)) AS liaO,
(IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq*incr,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq*incr,0))/(IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq,0)) AS i_liaO,
(IF(acod=9742 or acod=9744,-1*czkeq,0)) AS seO,
(IF(grp='ASS',czkeq,0)+IF(grp='ASL' AND czkeq>0,czkeq,0))+(IF(grp='LIA' AND tblaccbridge.agrpnr<>500,-1*czkeq,0)+IF(grp='ASL' AND czkeq<0,-1*czkeq,0)+IF(acod=9742 or acod=9744,-1*czkeq,0)) AS volO
FROM vb.bs_today left join vb.tblaccbridge on acod=ac
]]>
</SQL>
</View>

<Dimension name="Division" foreignKey="pc">
<Hierarchy hasAll="true" allMemberName="All Divisions" primaryKey="pc">
<Table name="profitability.division" alias="division"/>
<Level name="Divize" column="divize_name" nameColumn="divize_name" uniqueMembers="true" type="String"/>
<Level name="SubDivision" column="odbor" nameColumn="name" uniqueMembers="true" type="String"/>
<Level name="ProfitCenter" column="pc" nameColumn="pc" uniqueMembers="true" type="String"/>
</Hierarchy>
</Dimension>

<DimensionUsage name="Account officers" source="Account officers" foreignKey="ao"/>
<DimensionUsage name="Clients" source="Clients" foreignKey="cnum"/>
<!--DimensionUsage name="Accounts" source="Accounts" foreignKey="acod"/-->

<Measure name="Aktiva" type="Numeric" column="czkeqO" aggregator="sum" formatString="#,###0.00"/>
<Measure name="Aktiva ur. sazba" type="Numeric" column="i_assO" aggregator="sum" formatString="#,###0.00"/>
<Measure name="Pasiva" type="Numeric" column="liaO" aggregator="sum" formatString="#,###0.00"/>
<Measure name="Pasiva ur. sazba" type="Numeric" column="i_liaO" aggregator="sum" formatString="#,###0.00"/>
<Measure name="Cenne papiry" type="Numeric" column="seo" aggregator="sum" formatString="#,###0.00"/>
<Measure name="Obchodni objem" type="Numeric" column="volO" aggregator="sum" formatString="#,###0.00"/>
<!--Measure name="Warehouse Profit" aggregator="sum">
<MeasureExpression>
<SQL dialect="mysql">
(case when `vb.bs_today`.`promotion_id` = 0 then 0 else `sales_fact_1997`.`store_sales` end)
IF(`grp`='ASS',`czkeq`,0)+IF(`grp`='ASL' AND `czkeq`>0,`czkeq`,0)
</SQL>
</MeasureExpression>
</Measure-->
</Cube>

<Cube name="Profitabilita">
<Table name="dwh.margin_month" alias="margin_month"/>

<DimensionUsage name="Clients" source="Clients" foreignKey="cnum"/>
<Measure name="Profitability" type="Numeric" column="margin" aggregator="sum" formatString="#,###0.00"/>

</Cube>

<VirtualCube name="ZustatkyAll">
<VirtualCubeDimension cubeName="Zustatky" name="Division"/>
<VirtualCubeDimension name="Clients"/>

<VirtualCubeMeasure cubeName="Zustatky" name="[Measures].[Aktiva]"/>
<!--VirtualCubeMeasure cubeName="Zustatky" name="[Measures].[Aktiva ur. sazba]"/-->
<VirtualCubeMeasure cubeName="Profitabilita" name="[Measures].[Profitability]"/>
</VirtualCube>

</Schema>

I think problem was not in dimension but in the cube, because it is defined as view.
What is good, measure expression now works.

dis

Link to comment
Share on other sites

This looks like a Mondrian level bug. It may have been fixed - we will have to do some digging.

 

BTW: The way your cube database is laid out is not efficient. Doing the Views and MeasureExpressions forces Mondrian to do a lot of work that would be best done by a more efficient database layout.

 

 

 

Sherman

JasperSoft

Link to comment
Share on other sites

thanks,

 

I know that my schema is not efficient, because I used mysql4 database and without admin privilegies. But now I work with mysql5 so I can create view and also I have root privilegies, so I changed my schema.

 

But I have another problem. Is there some solution for creating interactive reports? When I have report grouped by more values it is possible to expand/collapse report by clicking on grouped value? Because I find this feature only with using jpivot. But I need it for example in generated html from normall report.

 

dis

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...