PDA

View Full Version : [Mondrian] Problems with functions throwing exceptions likeCastFunDef



Pappyn Bart
01-04-2007, 02:44 AM
Hi,

Since the introduction of CAST( expression AS ...), I use this function
very regularly to solve
problems with complex calculated members.

Now I am doing multi-user tests on mondrian and I notice problems. When
a lot of queries
are executed by mondrian at the same time, CastFunDef is regularly
throwing exceptions (a
single user test always succeeds).

The problems is related to the fact the RolapResult.executeBody() is
evaluating cells
until all data is get from the database. So it is possible that a
certain calculated member,
that depends on data that is not retrieved from the database yet, fails.

Most functions do not throw exceptions, so the principle works fine.

But CAST(expression as NUMERIC) throws an exception when the expression
it needs to
convert is null.

I think this is wrong and breaking the concept.

While I am not entirely sure, I think the multi-user test stressed my
system to much and
somehow made that executeBody needed more iterations than usually
needed.

Could you take a quick look, because I am not sure if I am taking the
right conclusions?

Thanks,
Bart

_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian