[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-3.2.1.13885-derby.zip 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 0.9.8.343 and create a connection like
this:

Connection connection = DriverManager.getConnection(
    "jdbc:xmla:Server=http://localhost:8080/mondrian-embedded/xmla;"
    + "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:

<DataSourceInfo>Provider=mondrian;Jdbc='jdbc:derby:classpath:/foodmart';Catalog=/WEB-INF/queries/FoodMart.xml;JdbcDrivers=org.apache.derby.jdbc.EmbeddedDriver;JdbcUser=sa;JdbcPassword=sa;PoolNeeded=false;</DataSourceInfo>

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: 
<SOAP-ENV:Fault>
    <faultcode>
        SOAP-ENV:Server.00HSBE02
    </faultcode>
    <faultstring>
        XMLA Discover unparse results error
    </faultstring>
    <faultactor>
        Mondrian
    </faultactor>
    <detail>
        <XA:error xmlns:XA="http://mondrian.sourceforge.net">
            <code>
                00HSBE02
            </code>
            <desc>
                The Mondrian XML: Container was opened in read-only
mode.
            </desc>
        </XA:error>
    </detail>
</SOAP-ENV:Fault>

Request was:
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope
    xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <SOAP-ENV:Body>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
        SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <RequestType>MDSCHEMA_DIMENSIONS</RequestType>
    <Restrictions>
      <RestrictionList>
<CATALOG_NAME>FoodMart</CATALOG_NAME><SCHEMA_NAME>FoodMart</SCHEMA_NAME><CUBE_NAME>Sales
Ragged</CUBE_NAME>      </RestrictionList>
    </Restrictions>
    <Properties>
      <PropertyList>
        <DataSourceInfo>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceInfo>
        <Catalog>FoodMart</Catalog>
        <Content>Data</Content>
      </PropertyList>
    </Properties>
    </Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

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