<!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.18928"></HEAD>
<BODY>
<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> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <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></BLOCKQUOTE></FONT></BODY></HTML>