US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: XML for Analysis tester: can't connect to the database

  1. #1

    Default XML for Analysis tester: can't connect to the database

    Hello!
    I configured mondrain as it's described in the documentation, and everything seems to work fine except for the "XML for Analysis tester".
    When I try to make request through the xmla interface I get this error:

    <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: Mondrian Error:Internal error: Unknown database 'FoodMart'
    </desc>
    </XA:error>
    </detail>
    </SOAP-ENV:Fault>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    Does anyone have a suggestion?


    Mondrian ver.: 3.4.1
    Sql connector:
    mysql-connector-java-5.1.24-bin

    DataSources.xml:

    <?xml version="1.0"?>
    <DataSources>
    <DataSource>
    <DataSourceName>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceName>
    <DataSourceDescription>Mondrian FoodMart Data Warehouse</DataSourceDescription>
    <URL>http://localhost:8080/mondrian/xmla</URL>
    <DataSourceInfo>Provider=mondrian; Jdbc=jdbc:mysql://localhost/foodmart?user=foodmart&amp;password=foodmart; JdbcDrivers=com.mysql.jdbc.Driver</DataSourceInfo>
    <ProviderName>Mondrian</ProviderName>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    <Catalogs>
    <Catalog name="FoodMart">
    <!--
    <DataSourceInfo>Provider=mondrian;Jdbc=jdbcdbc:MondrianFoodMart;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver</DataSourceInfo>
    -->
    <Definition>/WEB-INF/queries/FoodMart.xml</Definition>
    </Catalog>
    </Catalogs>
    </DataSource>
    </DataSources>

  2. #2

    Default Same Problem

    Hi ,
    I face the same error.
    Can some one help me out??

    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Unkno
    wn database 'FoodMart'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:939
    )
    at mondrian.olap.Util.newInternal(Util.java:2254)
    at mondrian.olap.Util.newError(Util.java:2269)
    at mondrian.server.FileRepository.getConnection(FileRepository.java:112)
    at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.j
    ava:243)
    at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2947)
    at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:155)
    at mondrian.xmla.Rowset.populate(Rowset.java:218)
    at mondrian.xmla.Rowset.unparse(Rowset.java:193)
    at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2869)
    ... 30 more
    [JPivot] 13 Mar 2014 00:28:00,995 ERROR [Session ] mondrian.xmla.XmlaServlet#doPost: Errors when handling XML/A message
    mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error
    at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2875)
    at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:643)




    Quote Originally Posted by fromcelticpark View Post
    Hello!
    I configured mondrain as it's described in the documentation, and everything seems to work fine except for the "XML for Analysis tester".
    When I try to make request through the xmla interface I get this error:

    <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: Mondrian Error:Internal error: Unknown database 'FoodMart'
    </desc>
    </XA:error>
    </detail>
    </SOAP-ENV:Fault>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    Does anyone have a suggestion?


    Mondrian ver.: 3.4.1
    Sql connector:
    mysql-connector-java-5.1.24-bin

    DataSources.xml:

    <?xml version="1.0"?>
    <DataSources>
    <DataSource>
    <DataSourceName>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceName>
    <DataSourceDescription>Mondrian FoodMart Data Warehouse</DataSourceDescription>
    <URL>http://localhost:8080/mondrian/xmla</URL>
    <DataSourceInfo>Provider=mondrian; Jdbc=jdbc:mysql://localhost/foodmart?user=foodmart&amp;password=foodmart; JdbcDrivers=com.mysql.jdbc.Driver</DataSourceInfo>
    <ProviderName>Mondrian</ProviderName>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    <Catalogs>
    <Catalog name="FoodMart">
    <!--
    <DataSourceInfo>Provider=mondrian;Jdbc=jdbcdbc:MondrianFoodMart;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver</DataSourceInfo>
    -->
    <Definition>/WEB-INF/queries/FoodMart.xml</Definition>
    </Catalog>
    </Catalogs>
    </DataSource>
    </DataSources>

  3. #3
    Join Date
    Jan 2013
    Posts
    512

    Default

    You'll get that error if a catalog is not found in the datasource you've specified. I'd first want to verify that FoodMart is in your datasource.xml. Second I'd want to check whether the contents of the <DataSourceName> specified in datasource.xml is consistent with the <DataSourceInfo> tag in your XMLA request.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •