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

Thread: Problem with Mondrian XMLA

  1. #1
    Join Date
    Jun 2013
    Posts
    1

    Default Problem with Mondrian XMLA

    Hi,
    when i open the first page mondrian (http://localhost:8080/mondrian/index.jsp):



    doesn't working.
    First have a error:
    org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Unable to internalize message
    I cannot connect with Mondrian by ADOMD (connection string: Data Source=http://localhost:8080/mondrian/xmla/)

    Whats can be wrong?
    I use mondrian 3.3 and biserver-ce-3.9.0 (with tomcat 6).
    The advice from the network, i use JDK 1.5.
    My datasources.xml:
    Code:
    <?xml version="1.0"?>
    <DataSources>
      <DataSource>
     <DataSourceName>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceName> 
        
        <DataSourceDescription>FoodMart 2000 Data Warehouse From MS Analysis Services</DataSourceDescription>
        <URL>http://localhost:8080/mondrian/xmla</URL>
        <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/foodmart;JdbcUser=foodmart;JdbcPassword=foodmart;JdbcDrivers=com.mysql.jdbc.Driver;</DataSourceInfo>
        <ProviderType>MDP</ProviderType>
        <AuthenticationMode>Unauthenticated</AuthenticationMode>
        <Catalogs>
            <Catalog name="FoodMart">
                <Definition>/WEB-INF/schema/FoodMart.xml</Definition>
            </Catalog>
    
        </Catalogs>
      </DataSource>
    and web.xml
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <!--
    $Id: //open/mondrian/webapp/WEB-INF/web-jpivot.xml#15 $
    
    This software is subject to the terms of the Eclipse Public License v1.0
    Agreement, available at the following URL:
    http://www.eclipse.org/legal/epl-v10.html.
    (C) Copyright 2003-2009 Julian Hyde and others
    All Rights Reserved.
    You must accept the terms of that agreement to use this software.
    -->
    
    <!DOCTYPE web-app
        PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
        "http://java.sun.com/dtd/web-app_2_3.dtd">
    
    <web-app>
    
      <display-name>Mondrian</display-name>
      <description/>
    
      <!-- optional? now in JPivot by default  -->
      <context-param>
        <param-name>contextFactory</param-name>
        <param-value>com.tonbeller.wcf.controller.RequestContextFactoryImpl</param-value>
      </context-param>
    
      <context-param>
        <param-name>connectString</param-name>
        <param-value>@mondrian.webapp.connectString@</param-value> 
    
      </context-param>
    
    
    
      <filter>
        <filter-name>JPivotController</filter-name>
        <filter-class>com.tonbeller.wcf.controller.RequestFilter</filter-class>
        <init-param>
          <param-name>errorJSP</param-name>
          <param-value>/error.jsp</param-value>
          <description>URI of error page</description>
        </init-param>
        <init-param>
          <param-name>busyJSP</param-name>
          <param-value>/busy.jsp</param-value>
          <description>This page is displayed if a the user clicks
            on a query before the previous query has finished</description>
        </init-param>
    
      </filter>
    
      <filter-mapping>
        <filter-name>JPivotController</filter-name>
        <url-pattern>/testpage.jsp</url-pattern>
      </filter-mapping>
    
      <listener>
        <listener-class>mondrian.web.taglib.Listener</listener-class>
      </listener>
    
      <!-- resources initializer -->
      <listener>
        <listener-class>com.tonbeller.tbutils.res.ResourcesFactoryContextListener</listener-class>
      </listener>
    
      <servlet>
        <servlet-name>MDXQueryServlet</servlet-name>
        <servlet-class>mondrian.web.servlet.MdxQueryServlet</servlet-class>
        <init-param>
          <param-name>connectString</param-name>
          <param-value>@mondrian.webapp.connectString@</param-value>
        </init-param>
      </servlet>
    
      <servlet>
        <servlet-name>MondrianXmlaServlet</servlet-name>
        <servlet-class>mondrian.xmla.impl.MondrianXmlaServlet</servlet-class>
            <init-param>
            <param-name>DataSourcesConfig</param-name>
            <param-value>'D:\biserver-ce-3.9.0-stable\biserver-ce\tomcat\webapps\mondrian\WEB-INF\datasources.xml'</param-value>
            </init-param>
      </servlet>
    
    
      <!-- jfreechart provided servlet -->
      <servlet>
        <servlet-name>DisplayChart</servlet-name>
        <servlet-class>org.jfree.chart.servlet.DisplayChart</servlet-class>
      </servlet>
    
      <!-- jfreechart provided servlet -->
      <servlet>
        <servlet-name>GetChart</servlet-name>
        <display-name>GetChart</display-name>
        <description>Default configuration created for servlet.</description>
        <servlet-class>com.tonbeller.jpivot.chart.GetChart</servlet-class>
      </servlet>
      <servlet>
        <servlet-name>Print</servlet-name>
        <display-name>Print</display-name>
        <description>Default configuration created for servlet.</description>
        <servlet-class>com.tonbeller.jpivot.print.PrintServlet</servlet-class>
      </servlet>
    
      <servlet-mapping>
        <servlet-name>DisplayChart</servlet-name>
        <url-pattern>/DisplayChart</url-pattern>
      </servlet-mapping>
      <servlet-mapping>
        <servlet-name>Print</servlet-name>
        <url-pattern>/Print</url-pattern>
      </servlet-mapping>
      <servlet-mapping>
        <servlet-name>GetChart</servlet-name>
        <url-pattern>/GetChart</url-pattern>
      </servlet-mapping>
    
      <servlet-mapping>
        <servlet-name>MDXQueryServlet</servlet-name>
        <url-pattern>/mdxquery</url-pattern>
      </servlet-mapping>
    
      <servlet-mapping>
        <servlet-name>MondrianXmlaServlet</servlet-name>
        <url-pattern>/xmla</url-pattern>
      </servlet-mapping>
    
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
      </welcome-file-list>
    
      <taglib>
        <taglib-uri>http://www.tonbeller.com/wcf</taglib-uri>
        <taglib-location>/WEB-INF/wcf/wcf-tags.tld</taglib-location>
      </taglib>
    
      <taglib>
        <taglib-uri>http://www.tonbeller.com/jpivot</taglib-uri>
        <taglib-location>/WEB-INF/jpivot/jpivot-tags.tld</taglib-location>
      </taglib>
    
    </web-app>
    Have you any idea? I use sample data MondrianFoodMart with MySQL.

    I try answer in the internet, try many of solutions but its still don't working.

  2. #2
    Join Date
    Aug 2013
    Posts
    1

    Default

    I am also Facing one Problem

    The demo.xml is
    <?xml version="1.0"?>
    <Schema name="SudeepSchema">


    <Cube name="DivyaCubeReal">
    <Table name="StateWiseZone"/>

    <Dimension name="State">
    <Hierarchy hasAll="true" allMemberName="All State">
    <Level name="State" column="state" uniqueMembers="true"/>
    </Hierarchy>
    </Dimension>
    <Dimension name="Zone">
    <Hierarchy hasAll="true" allMemberName="All Zone">
    <Level name="Zone" column="zone" uniqueMembers="true"/>
    </Hierarchy>
    </Dimension>
    <Dimension name="type">
    <Hierarchy hasAll="true" allMemberName="All Type">
    <Level name="Type" column="type" uniqueMembers="true"/>
    </Hierarchy>
    </Dimension>


    <Measure name="Total Count" column="type" aggregator="count" formatString="Standard"/>
    </Cube>
    </Schema>

    and the Query is SELECT {
    ([type])
    } ON COLUMNS,
    {
    ([Zone].[All Zone],[State].[All State])
    } ON ROWS
    FROM [DivyaCubeReal]

    The Report gets generated ,but When I expand All State colum I am getting this error below :


    Caused by: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[type].[All Type]} ON COLUMNS,
    Hierarchize(Union(Crossjoin({[Zone].[All Zone]}, {[State].[All State]}), Crossjoin({[Zone].[All Zone]}, [State].[All State].Children))) ON ROWS
    from [DivyaCubeReal]
    ]
    at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:305)
    at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
    at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48)
    at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at javax.el.BeanELResolver.getValue(BeanELResolver.java:87)
    ... 110 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[type].[All Type]} ON COLUMNS,
    Hierarchize(Union(Crossjoin({[Zone].[All Zone]}, {[State].[All State]}), Crossjoin({[Zone].[All Zone]}, [State].[All State].Children))) ON ROWS
    from [DivyaCubeReal]
    ]
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.Util.newInternal(Util.java:1340)
    at mondrian.olap.Util.newError(Util.java:1356)
    at mondrian.rolap.RolapConnection.execute(RolapConnection.java:471)
    at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279)
    ... 118 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:782)
    at mondrian.olap.Util.newInternal(Util.java:1333)
    at mondrian.olap.Util.assertTrue(Util.java:1314)
    at mondrian.olap.fun.FunUtil$HierarchizeArrayComparator.compare(FunUtil.java:2144)
    at mondrian.olap.fun.FunUtil$HierarchizeArrayComparator.compare(FunUtil.java:2126)
    at mondrian.olap.fun.FunUtil$LoggingTupleComparator.compare(FunUtil.java:2008)
    at mondrian.olap.fun.FunUtil$LoggingTupleComparator.compare(FunUtil.java:1984)
    at java.util.TimSort.countRunAndMakeAscending(Unknown Source)
    at java.util.TimSort.sort(Unknown Source)
    at java.util.TimSort.sort(Unknown Source)
    at java.util.Arrays.sort(Unknown Source)
    at java.util.Collections.sort(Unknown Source)
    at mondrian.olap.fun.FunUtil.hierarchize(FunUtil.java:536)
    at mondrian.olap.fun.HierarchizeFunDef$1.evaluateList(HierarchizeFunDef.java:49)
    at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:67)
    at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:696)
    at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:559)
    at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:534)
    at mondrian.rolap.RolapResult.<init>(RolapResult.java:256)
    at mondrian.rolap.RolapConnection.execute(RolapConnection.java:443)
    ... 119 more

    Any idea why this error is coming. I feel that the mdx query is not getting executed and I am missing some join or connection b/w 2 tables.

  3. #3
    Join Date
    Jan 2013
    Posts
    471

    Default

    What version of Mondrian are you running? The class that fails the assert is (HierarchizeArrayComparator), which hasn't existed for awhile. It's possible you're seeing a bug that was fixed in earlier versions. Can you see whether you still see an error with with 3.5?

  4. #4

    Default

    I have same problem.
    Please help us.

  5. #5
    Join Date
    Jan 2013
    Posts
    471

    Default

    Hi Chetan,
    If you've got the same problem, I've got the same question: What version of Mondrian are you running?

  6. #6
    Join Date
    Aug 2013
    Posts
    120

    Default

    TRY this

    Replace the follwing

    param-name>connectString</param-name>
    <param-value>@mondrian.webapp.connectString@</param-value>
    with the following

    <param-name>connectString</param-name>
    <param-value>Provider=mondrian;Jdbc=jdbc:mysql://localhost:3306/foodmart;Jdbcuser=root;Jdbcpassword=admin;Catalog=/WEB-INF/queries/FoodMart.xml;JdbcDrivers=com.mysql.jdbc.Driver;</param-value>



    it worked for me hope it works for u......
    Last edited by suresh84c; 09-03-2013 at 01:15 AM.

  7. #7
    Join Date
    Nov 2013
    Posts
    5

    Default

    HI,

    I am having a problem with XMLA. The error I am getting is Mondrian Error:Internal error: invalid URL path '/WEB-INF/datasources.xml'
    No matter what and how I try , I am unable to proceed further.

    If I comment out the ConfigDatasources - I get an IllegalArgumentException.

    Basically notable to move forward.

    I am running tomcat8x, jdk7,and
    mondrian-3.5.0.

    Anyhelp would be appreciated.

  8. #8
    Join Date
    Nov 2013
    Posts
    5

    Default

    Got past the above issue - but now stuck with

    <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.NullPointerException</desc>

    </XA:error>



    </detail>



    </SOAP-ENV:Fault>



    </SOAP-ENV:Body>



    </SOAP-ENV:Envelope>

    Any advice ?

Posting Permissions

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