[Mondrian] Test suite on MySQL

Luc Boudreau lucboudreau at gmail.com
Tue Aug 10 12:12:24 EDT 2010


Hello,

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.

mondrian.olap.MondrianException: Mondrian Error:Member '[Store].[USA].[CA]'
> not found
>     at
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838)
>     at mondrian.olap.Util.lookupCompound(Util.java:586)
>

Looking at the sql logs, I can confirm that the actual row was retrieved.

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]
>
> 2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec 15 ms
>
> 2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec+fetch 15 ms, 1 rows
>

If I copy / paste that query in a MySQL terminal window, I get the results
as well.

Someone encountered this before? Insights? Suspicions? Ideas?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100810/8aebab8a/attachment.html 


More information about the Mondrian mailing list