XMLA error when defining more than 1 DataSource in datasources.xml

[ratio1]

Hi,

not sure, if this is a problem of mondrian or olap4j-xmla or olap4j-xmlaserver project:

I'm running Saiku from trunk (http://ci.analytical-labs.com/job/saiku-mondrian4/), including

• Mondrian 4.0
• olap4j-1.2.0-SNAPSHOT.jar
• olap4j-xmla-1.2.0-SNAPSHOT.jar
• olap4j-xmlaserver-1.2.0.jar
• foodmart database.

When I set up datasources.xml with only 1 DataSource section, everythin works fine. Connecting to the XMLA-server works with different datasources, each in combination with different frontends.

When I set up datasources.xml with 2 DataSource sections, I get the following error. The error occurs independently from frontends, so it should be a matter of mondrian or xmla components. I both tried with an own datasource as 2nd DataSource section and (to eleminate other sources of error) with just a copy of the 1st datasource as 2nd DataSource.

Here is the error message:

2014-07-08 09:04:07,674 DEBUG [mondrian.xmla.XmlaServlet] XML/A response content
<?xml version="1.0" encoding="ISO-8859-1"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
<SOAP-ENV:Header>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<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: java.lang.AssertionError</desc>
    </XA:error>
  </detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

This datasources.xml is working without errors:

<?xml version="1.0"?>
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=FoodMart</DataSourceName>
<DataSourceDescription>Foodmart Data Warehouse</DataSourceDescription>
<URL>http://localhost:8080/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:hsqldb:res:foodmart/foodmart;JdbcDrivers=org.hsqldb.jdbcDriver;Catalog=/WEB-INF/classes/foodmart/FoodMart.xml</DataSourceInfo>
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Authenticated</AuthenticationMode>
<Catalogs>
<Catalog name="FoodMart">
<Definition>/WEB-INF/classes/foodmart/FoodMart.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>

This one works, but only 1 datasource ist shown up in the frontend (1:1 copy of the 1st DataSource section)

<?xml version="1.0"?>
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=FoodMart</DataSourceName>
<DataSourceDescription>Foodmart Data Warehouse</DataSourceDescription>
<URL>http://localhost:8080/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:hsqldb:res:foodmart/foodmart;JdbcDrivers=org.hsqldb.jdbcDriver;Catalog=/WEB-INF/classes/foodmart/FoodMart.xml</DataSourceInfo>
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Authenticated</AuthenticationMode>
<Catalogs>
<Catalog name="FoodMart">
<Definition>/WEB-INF/classes/foodmart/FoodMart.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=FoodMart</DataSourceName>
<DataSourceDescription>Foodmart Data Warehouse</DataSourceDescription>
<URL>http://localhost:8080/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:hsqldb:res:foodmart/foodmart;JdbcDrivers=org.hsqldb.jdbcDriver;Catalog=/WEB-INF/classes/foodmart/FoodMart.xml</DataSourceInfo>
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Authenticated</AuthenticationMode>
<Catalogs>
<Catalog name="FoodMart">
<Definition>/WEB-INF/classes/foodmart/FoodMart.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>

This one gives the error message, no datasource ist shown up in the frontend (1:1 copy of the 1st DataSource section, modified in DataSourceName only)

<?xml version="1.0"?>
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=FoodMart</DataSourceName>
<DataSourceDescription>Foodmart Data Warehouse</DataSourceDescription>
<URL>http://localhost:8080/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:hsqldb:res:foodmart/foodmart;JdbcDrivers=org.hsqldb.jdbcDriver;Catalog=/WEB-INF/classes/foodmart/FoodMart.xml</DataSourceInfo>
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Authenticated</AuthenticationMode>
<Catalogs>
<Catalog name="FoodMart">
<Definition>/WEB-INF/classes/foodmart/FoodMart.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=FoodMart2</DataSourceName>
<DataSourceDescription>Foodmart Data Warehouse</DataSourceDescription>
<URL>http://localhost:8080/mondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:hsqldb:res:foodmart/foodmart;JdbcDrivers=org.hsqldb.jdbcDriver;Catalog=/WEB-INF/classes/foodmart/FoodMart.xml</DataSourceInfo>
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Authenticated</AuthenticationMode>
<Catalogs>
<Catalog name="FoodMart">
<Definition>/WEB-INF/classes/foodmart/FoodMart.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>

[PCLhoc]

Were you able to fix this?

[arbocdi]

Confirming the same problem,is there anyone to help?
The error comes from here at mondrian.olap4j.MondrianOlap4jConnection.(MondrianOlap4jConnection.java:183)
where datasource limit is set exactly to one.

[julianhyde]

I'm not actively developing this code anymore. But if someone has a solution or a fix, please post it.