[Mondrian] XML/A support in mondrian not working

Robert Lemmen robertle at semistable.com
Thu Mar 3 09:26:29 EST 2011

hi folks,

I have just installed the mondrian-embedded.war from
mondrian- into a apache-tomcat-7.0.8 the general
system seems to be working, because i can use the "mdxquery" servlet to
query the embedded database. i want to access the server remotely using
xml/a, to do this i use olap4j and create a connection like

Connection connection = DriverManager.getConnection(
    + "Catalog=FoodMart");

originally this gave me errors, which i fixed by changing the
datasources.xml and replaced the original DataSourceInfo (which pointed
to some oracle db) with this:


this seems to have done the trick, as i now get a different error which
i was hoping one of you could help me with. the olap4j seems to do some
sort of metadata discovery before sending teh actual query, whcih fails
with an exception:

XMLA provider gave exception: 
        XMLA Discover unparse results error
        <XA:error xmlns:XA="http://mondrian.sourceforge.net">
                The Mondrian XML: Container was opened in read-only

Request was:
<?xml version="1.0" encoding="UTF-8"?>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
Ragged</CUBE_NAME>      </RestrictionList>

the tomcat log gives some extra info:

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal
error: while counting members of level '[Customers].[Name]; sql=[select
count(*) from (select distinct "customer"."fullname" from "customer" as
"customer") as "init"]

any ideas?

thanks  robert

Robert Lemmen                               http://www.semistable.com 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20110303/6388cbb2/attachment.bin 

More information about the Mondrian mailing list