<html><body bgcolor="#FFFFFF"><div><br>This issue dates back many weeks. I tried stepping through the code quickly but gave up and decided to test against Oracle. Only yesterday did I decide to revisit the issue. <br>__________________<div>
Luc Boudreau</div></div><div><br>On 2010-08-11, at 2:28 AM, "Julian Hyde" <<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>
<div><span class="205461223-10082010"><font color="#000080" size="2" face="Lucida Sans">I may have broken something. Did this error occur before my
recent change?</font></span></div>
<div><span class="205461223-10082010"><font color="#000080" size="2" face="Lucida Sans"></font></span> </div>
<div><span class="205461223-10082010"><font color="#000080" size="2" face="Lucida Sans">Julian</font></span></div><br>
<blockquote style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<div dir="ltr" lang="en-us" class="OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Luc
Boudreau<br><b>Sent:</b> Tuesday, August 10, 2010 9:12 AM<br><b>To:</b>
Mondrian developer mailing list<br><b>Subject:</b> [Mondrian] Test suite on
MySQL<br></font><br></div>
<div></div>Hello,<br><br>I'm having troubles running the test suite against
MySQL and I'm out of ideas on what to try next to fix it. I can run it fine on
Oracle or Access. MySQL has a strange exception popping up.<br><br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><span style="FONT-FAMILY: courier new,monospace">mondrian.olap.MondrianException:
Mondrian Error:Member '[Store].[USA].[CA]' not found</span><br style="FONT-FAMILY: courier new,monospace"><span style="FONT-FAMILY: courier new,monospace"> at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838)</span><br style="FONT-FAMILY: courier new,monospace"><span style="FONT-FAMILY: courier new,monospace"> at
mondrian.olap.Util.lookupCompound(Util.java:586)</span><br style="FONT-FAMILY: courier new,monospace"></blockquote><br>Looking at the sql
logs, I can confirm that the actual row was retrieved.<br><br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><font face="courier new,monospace">2010-08-10 11:50:27,648
DEBUG [mondrian.sql] 7: SqlMemberSource.getMemberChildren: executing sql
[select `store`.`store_country` as `c0` from `store` as `store` where
UPPER(`store`.`store_country`) = UPPER('USA') group by
`store`.`store_country` order by ISNULL(`store`.`store_country`),
`store`.`store_country` ASC]</font><br><br><font face="courier new,monospace">2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7:
, exec 15 ms</font><br><br><font face="courier new,monospace">2010-08-10
11:50:27,663 DEBUG [mondrian.sql] 7: , exec+fetch 15 ms, 1
rows</font><br></blockquote><font face="arial,helvetica,sans-serif"><br>If I
copy / paste that query in a MySQL terminal window, I get the results as well.
<br><br>Someone encountered this before? Insights? Suspicions?
Ideas?<br></font></blockquote><font face="arial,helvetica,sans-serif"></font>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Mondrian mailing list</span><br><span><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a></span><br>
<span><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a></span><br></div></blockquote></body></html>