Monday, February 27, 2012

Pentaho BI. Jpivot - java.util.EmptyStackException


I found my first bug with Pentaho BI while following this tutorial, but the solution was very straightforward, to replace the jpivot jar file....(because the old one was using an incorrect method).

Java.util.EmptyStackException
at java.util.Stack.peek(Stack.java:85)
at mondrian.server.Locus.peek(Locus.java:63)
at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:902)
at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:830)
at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:804)
at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210)
at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:586)
at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:682)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176)
at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:170)
at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:152)
at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:146)
at mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:78)
at com.tonbeller.jpivot.mondrian.MondrianMemberTree.internalGetChildren(MondrianMemberTree.java:209)
at com.tonbeller.jpivot.mondrian.MondrianMemberTree.getChildren(MondrianMemberTree.java:193)
at com.tonbeller.jpivot.navigator.member.TreeModelAdapter.getChildren(TreeModelAdapter.java:95)

etc...

The solution was given by dulci :

dulci
    Hey,
    I have the solution! Do this!:

    1.- stop-pentaho
    2.- Rename the library biserver-ce/tomcat/webapp/pentaho/WEB-INF/lib/jpivot-1.8.0-100420.jar to jpivot-1.8.0-100420.jar.OLD
    3.- Paste the library that we downloaded from http://www.stratebi.es/todobi/Ene12/jpivot-1.8.0-100420.jar
    4 - start pentaho and that's it! 

And bingo!!! This is the beauty of open source.

Reference:
http://forums.pentaho.com/showthread.php?89323-JPivot-error-want-to-check-the-solution

No comments:

Post a Comment