JPivot pivot table by XMLA

[Quadratics]

Hi Feris,

I have been able to get eight out of the nine links on the mondrian
index page working fine now,it only remain the (JPivot pivot table by
XMLA) link.
After going through the guide at:
http://pentaho-en.phi-integration.com/mondrian/configuring-mondrian-sample/jpivot-pivot-table-by-xmla,
I edited my xmla.jsp as follows:

----------------------------
<%@ page session="true" pageEncoding="UTF-8" contentType="text/html;
charset=ISO-8859-1" %>
<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>


<jp:xmlaQuery id="query01"
uri="http://192.168.19.89:8080/mondrian/xmla"
dataSource="Provider=Mondrian;DataSource=MondrianFoodMart;"
catalog="FoodMart">

select
{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store
Sales]} on columns,
{([Promotion Media].[All Media], [Product].[All Products])} ON rows
from Sales
where ([Time].[1997])

</jp:xmlaQuery>

<c:set var="title01" scope="session">Accessing Mondrian By XMLA</
c:set>
-----------------------------

and whenever I try to load it by clicking on this(JPivot pivot table
by XMLA) from the index page, I got this error:

---------------------------
JPivot had an 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

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
at org.apache.jasper.servlet.JspServletWrapper.handleJspException
(JspServletWrapper.java:522)..........
........
Caused by: javax.xml.soap.SOAPException: Invalid Content-Type:text/
html
at com.sun.xml.messaging.saaj.soap.MessageImpl.verify
(MessageImpl.java:161)
at com.sun.xml.messaging.saaj.soap.MessageImpl.(MessageImpl.java:89)
... 53 more



javax.xml.soap.SOAPException: java.security.PrivilegedActionException:
javax.xml.soap.SOAPException: Unable to internalize message

javax.xml.soap.SOAPException: java.security.PrivilegedActionException:
javax.xml.soap.SOAPException: Unable to internalize message
at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection.call
(HttpSOAPConnection.java:120)
at com.tonbeller.jpivot.xmla.XMLA_SOAP.discover(XMLA_SOAP.java:1429)
.................
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
447)
at java.lang.Thread.run(Thread.java:595)
Caused by: javax.xml.soap.SOAPException: Invalid Content-Type:text/
html
at com.sun.xml.messaging.saaj.soap.MessageImpl.verify
(MessageImpl.java:161)
at com.sun.xml.messaging.saaj.soap.MessageImpl.(MessageImpl.java:89)
... 53 more



javax.xml.soap.SOAPException: Invalid Content-Type:text/html

javax.xml.soap.SOAPException: Invalid Content-Type:text/html
at com.sun.xml.messaging.saaj.soap.MessageImpl.verify
(MessageImpl.java:161)
at com.sun.xml.messaging.saaj.soap.MessageImpl.(MessageImpl.java:89)
at com.sun.xml.messaging.saaj.soap.MessageFactoryImpl.createMessage
(MessageFac........
---------------------------

This is the remaining challenge that is giving me problem now and I
tried to load my application which is openI may be it will connect to
the database since eight out of the nine links on the mondrian page
are working fine,
but it did not all what I can see after loading my openI is an error
dectating that is unable to render table.


Hope to hear from you soon.

Thanks,

Quadri.

[Feris Thia]

Hi Quadri,

Have you make sure that your datasources.xml contain :

    <DataSourceName>

    Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceName> 

?

And what is your JDK version ? I have found issues with JDK 1.6.. if you are using JDK 1.6 try to downgrade it to 1.5.

See this issue :

http://pentaho-en.phi-integration.com/troubleshoot/jpivot-pivot-table-by-xmla--jdk-1-6--tomcat-6-0-16-and-windows-xp

On Tue, Jan 6, 2009 at 1:35 AM, Quadratics <quad...@yahoo.com> wrote:

<jp:xmlaQuery id="query01"
   uri="http://192.168.19.89:8080/mondrian/xmla"
   dataSource="Provider=Mondrian;DataSource=MondrianFoodMart;"
  catalog="FoodMart">

--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483
Mobile : +628176-474-525
http://www.phi-integration.com
http://pentaho.phi-integration.com

[Quadratics]

Hi Feris,

Thanks for the quick reply and I'm very sorry for not responding
immediately.

This is my datasources.xml:
--------------------------------
<?xml version="1.0"?>

<DataSources>

<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=MondrianFoodMart;</
DataSourceName>

<DataSourceDescription>Mondrian FoodMart Data Warehouse</
DataSourceDescription>

<URL>http://localhost:8888/mondrian/xmla</URL>


<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/
foodmart;JdbcUser=foodmart;JdbcPassword=foodmart;JdbcDrivers=com.mysql.jdbc.Driver;Catalog=/
WEB-INF/queries/FoodMart.xml</DataSourceInfo>

<ProviderName>Mondrian</ProviderName>


<AuthenticationMode>Unauthenticated</AuthenticationMode>

<Catalogs>

<Catalog name="FoodMart">
<Definition>/WEB-INF/queries/FoodMart.xml</Definition>
</Catalog>
</Catalogs>

</DataSource>

</DataSources>
--------------------------------
and am using JDK 1.5, because I did this (java -version ) on my
terminal and I got this:
---------------
java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode, sharing)
---------------

Please am still getting the same error I posted before,I will be
expecting your relpy.

Thanks very much and God bless.

Cheers bye,

Quadri.

On Jan 5, 7:48 pm, "Feris Thia" <fe...@phi-integration.com> wrote:
> Hi Quadri,
> Have you make sure that your datasources.xml contain :
>
> <DataSourceName>
> Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceName>
>
> ?
>
> And what is your JDK version ? I have found issues with JDK 1.6.. if you are
> using JDK 1.6 try to downgrade it to 1.5.
>
> See this issue :
>

> http://pentaho-en.phi-integration.com/troubleshoot/jpivot-pivot-table...

[Feris Thia]

Hi Quadri,

Can you change this part in your datasources.xml :

On Tue, Jan 6, 2009 at 4:16 PM, Quadratics <quad...@yahoo.com> wrote:

<URL>http://localhost:8888/mondrian/xmla</URL>

into 

<URL>http://192.168.19.89:8080/mondrian/xmla</URL>

--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483

[Quadratics]

Feris, thanks for that I edited the default datasources.xml and I
forgot to change that, but I have done as you said by changine it now.
This is the default datasources.xml which I modified for use:
----------------------------------
<?xml version="1.0"?>
<!--
== $Id: //open/mondrian-release/3.0/webapp/WEB-INF/datasources.xml#2
$
== This software is subject to the terms of the Common Public
License
== Agreement, available at the following URL:
== http://www.opensource.org/licenses/cpl.html.
== (C) Copyright 2005-2006 Julian Hyde and others.
== All Rights Reserved.
== You must accept the terms of that agreement to use this software.
-->
<DataSources>
<!--
A data source is a collection of logically related Mondrian
catalogs.

The XMLA specification allows an XMLA provider to have
multiple data sources, but some clients, particularly ones
based on ADOMD.NET such as Simba's O2X client and Pentaho
Spreadsheet Services, can only connect to the first declared
data source. Therefore, we recommend that you use a single
data source, containing multiple catalogs if necessary.
-->
<DataSource>
<!--
Name of the data source.
-->

<DataSourceName>Provider=Mondrian;DataSource=MondrianFoodMart;</
DataSourceName>

<!--
Description of the data source.
-->

<DataSourceDescription>Mondrian FoodMart Data Warehouse</
DataSourceDescription>

<!--
The URL of the servlet.
-->

<URL>http://192.168.19.89:8080/mondrian/xmla</URL>

<!--
Mondrian connect string for the data source. If this data
source contains multiple catalogs, omit the 'Catalog'
property, and specify the URI of the schema.xml file in
the catalog's <Definition> element.

Catalogs can override the connect string with their own
<DataSourceInfo> element.
-->

<!-- for Oracle -->
<!--

<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:oracle:thin:foodmart/
foodmart@//marmalade.hydromatic.net:1521/
XE;JdbcUser=foodmart;JdbcPassword=foodmart;JdbcDrivers=oracle.jdbc.OracleDriver;Catalog=/
WEB-INF/queries/FoodMart.xml</DataSourceInfo>
-->

<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/
foodmart;JdbcUser=foodmart;JdbcPassword=foodmart;JdbcDrivers=com.mysql.jdbc.Driver;Catalog=/
WEB-INF/queries/FoodMart.xml</DataSourceInfo>

<!--
Provider name must be 'Mondrian'.
-->
<ProviderName>Mondrian</ProviderName>

<!--
Provider type must be 'MDP'.
-->
<ProviderType>MDP</ProviderType>

<!--
Authentication mode. Allowable values are
'Unauthenticated', 'Authenticated', 'Integrated'.
-->
<AuthenticationMode>Unauthenticated</AuthenticationMode>

<!--
A data source contains one or more catalogs.
-->
<Catalogs>
<!--
Catalog names must match the name inside the
schema.xml file, and must be unique across all data
sources defined in this datasources.xml file.
-->
<Catalog name="FoodMart">
<!--
Mondrian connect string for the data source. This
element is optional; if specified, it overrides
the
data source's <DataSourceInfo> element.
Typically,
you would use this element if the catalogs have
different JDBC data sources.
-->
<!--

<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:odbc:MondrianFoodMart;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver</
DataSourceInfo>
-->

<!--
URI of the schema definition file.
-->

<Definition>/WEB-INF/queries/FoodMart.xml</Definition>
</Catalog>
</Catalogs>

</DataSource>

</DataSources>

----------------------------------
I removed those comments in the first datasources.xml I posted.

Thanks but am still getting the same errorr after changing that,
hope to hear from you soon.

Thanks,

Quadri.

On Jan 6, 10:58 am, "Feris Thia" <fe...@phi-integration.com> wrote:
> Hi Quadri,
> Can you change this part in your datasources.xml :
>

[Feris Thia]

And Quadri,

Make sure localhost is also set to your 

On Tue, Jan 6, 2009 at 4:16 PM, Quadratics <quad...@yahoo.com> wrote:

<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost/
foodmart;JdbcUser=foodmart;JdbcPassword=foodmart;JdbcDrivers=com.mysql.jdbc.Driver;Catalog=/
WEB-INF/queries/FoodMart.xml</DataSourceInfo>

 

<DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://192.168.19.8/

foodmart;JdbcUser=foodmart;JdbcPassword=foodmart;JdbcDrivers=com.mysql.jdbc.Driver;Catalog=/
WEB-INF/queries/FoodMart.xml</DataSourceInfo>

--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483

[Quadratics]

Hi Feris,
Is like the last reply you posted is not completed or may be am the
one who doesn't get it. Please help me by making it clear.
Thanks, I will be expecting your reply soon.

Quadri.

On Jan 6, 3:13 pm, "Feris Thia" <fe...@phi-integration.com> wrote:
> And Quadri,
> Make sure localhost is also set to your
>

[Feris Thia]

Hi Quadri,

Try to search for localhost in your datasources.xml and make change to your current host (192.168.19.89) and also make sure the jdbc user / password are correct ones.

On Tue, Jan 6, 2009 at 6:03 PM, Quadratics <quad...@yahoo.com> wrote:

Feris, thanks for that I edited the default datasources.xml and I
forgot to change that, but I have done as you said by changine it now.
 This is the default datasources.xml which I modified for use:

--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483

[MTranchant]

Hi Quadratics,

You are using Mondrian 3.3, don't you ?
If so, you have an extra change to do :

Open web.xml
Change this sequence

<servlet>

<servlet-name>MondrianXmlaServlet</servlet-name>

<servlet-class>mondrian.xmla.impl.DefaultXmlaServlet</servlet-class>





by this one


<servlet>

<servlet-name>MondrianXmlaServlet</servlet-name>

<servlet-class>mondrian.xmla.impl.MondrianXmlaServlet</servlet-class>

Indeed, DefaultXmlaServlet is no longer a class you can instanciate (abstracted), but MondrianXmlaServlet inherits from it ;)

More about it (in French) : http://tranchant.name/2012/01/mondrian-3-3-xmla/

Hope it will help

Regards
Michael Tranchant