Error on Mondrian – JPivot pivot table by XMLA

I have installed Mondrian 3.1.6.13364 with environments :
– Apache Tomcat 6.0.26 on port 8123 (D:\oss\apache-tomcat-6.0.26)
– Java version 1.6.0_17 (C:\Program Files\Java\jdk1.6.0_17)
– Access Database with ODBC MondrianFoodMart (D:\pentaho\mondrian\demo\access\MondrianFoodMart.mdb)

I run on http://localhost:8123/mondrian/, i see :
Mondrian examples:

* JPivot pivot table
* JPivot pivot table by XMLA
* JPivot with 4 hierarchies
* JPivot with role ‘California Manager’ set
* JPivot with arrows
* JPivot with colors
* Various queries formatted using the Mondrian tag-library
* Basic interface for ad hoc queries
* XML for Analysis tester

Other links:

* Mondrian home page
* Mondrian project page
* JPivot home page
* JPivot project page

Every Mondrian examples link is OK, except JPivot pivot table by XMLA

I’ve search and found a lot of discussion about this issue, but the most help are the following link :
1. http://lists.pentaho.org/pipermail/mondrian/2009-January/001550.html

rem for JDK 1.6 – force the use of Axis for SOAP not the internal JDK web services implementation
set JAVA_OPTS=%JAVA_OPTS%
-Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl
-Djavax.xml.soap.SOAPConnectionFactory=org.apache.axis.soap.SOAPConnectionFactoryImpl
-Djavax.xml.soap.SOAPFactory=org.apache.axis.soap.SOAPFactoryImpl

rem for JDK 1.6 – use xalan, not JDK 1.6 internal Xalan implementation
set JAVA_OPTS=%JAVA_OPTS%
-Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl

2. http://lists.pentaho.org/pipermail/mondrian/2009-January/001553.html

add the following jars into mondrian web app library :
– axis-1.4.jar
– commons-discovery-0.4.jar
– jaxrpc-api-1.1.jar
– wsdl4j-1.6.2.jar

Below the error when i click JPivot pivot table by XMLA

Continue reading

Advertisements