PDA

View Full Version : Patch for JPivot errors during use



nricheton
09-23-2006, 11:43 PM
Hi,

Jpivot 1.5 which is included in pentaho is not usable in production because of a bug that leads to the "Jpivot has an error" screen. This often occurs when you have several dimension as rows and you try to expand a dimension other than the first.

On the stack trace you get on extract from pivot.jsp showing the test for query01.result.isOverflow so I thought at first that an overflow was happening.

But this is caused by a missing convertion in com.tonbeller.jpivot.mondrian.MondrianQuaxUti.equalMember
This bug has already been fixed in Jpivot CVS for 2 months :
http://sourceforge.net/tracker/index.php?func=detail&aid=1530578&group_id=58645&atid=488472

Pentaho 1.2 should at least use a patched version of jpivot 1.5 or use the cvs version.

In my case, JPivot was crashing everything i tryed to get useful figures with it. After the patch, it is very stable.

--
Nicolas

nricheton
09-29-2006, 05:24 AM
This file must also be updated to prevent ClassCastExceptions.

http://jpivot.cvs.sourceforge.net/jpivot/jpivot/src/java/com/tonbeller/jpivot/mondrian/MondrianUtil.java?view=log

--
Nicolas

jagiaz
10-27-2006, 02:13 AM
Wow, thank you very much.

That problem really bothered me. I'm going to try this right now.

Regards.