<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18975"></HEAD>
<BODY>
<DIV><SPAN class=097345315-18112010><FONT color=#000080 size=2
face="Lucida Sans">Did you search jira for this issue? There are similar ones,
e.g. <A href="http://jira.pentaho.com/browse/MONDRIAN-762"><FONT size=3
face="Times New Roman">http://jira.pentaho.com/browse/MONDRIAN-762</FONT></A></FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Martijn van den
Broek<BR><B>Sent:</B> Thursday, November 18, 2010 12:49 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian]
mondrian.rolap.RolapMemberBase cannot be cast
tomondrian.rolap.RolapCubeMember<BR></FONT><BR></DIV>
<DIV></DIV>Hello,
<DIV><BR></DIV>
<DIV>We are running a mondrian server with multiple datasources configured.
The XMLA protocol is used to execute MDX queries against mondrian with a
simple HTTP client written in python. This all works really well till at some
point the mondrian server wont execute anymore and returns with the following
exception:</DIV>
<DIV><BR></DIV>
<DIV>mondrian.rolap.RolapMemberBase cannot be cast to
mondrian.rolap.RolapCubeMember (code: 00HSBE03)</DIV>
<DIV><BR></DIV>
<DIV>From that point on we cannot execute the same MDX over XMLA till we clear
the mondrian cache and restart the tomcat server. While XMLA is still broken
we can however execute the MDX successfully in JPivot. Does this mean its a
XMLA problem? Another thing we noticed is that some dimensions are not
accessable anymore if we execute MDSCHEMA_HIERARCHIES. </DIV>
<DIV><BR></DIV>
<DIV>The WEB-INF/mondrian.properties has the default config and changing the
'mondrian.rolap.EnableRolapCubeMemberCache' to true or false doesnt change the
behaviour. </DIV>
<DIV><BR></DIV>
<DIV>We are working on a testcase to reproduce the problem but it seems very
hard to trigger. Any suggestions on how to debug this issue are welcome.
Thanks in advance. </DIV>
<DIV><BR></DIV>
<DIV><BR>-- <BR>Martijn van den Broek<BR></DIV>
<DIV><BR></DIV></BLOCKQUOTE></BODY></HTML>