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

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: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Unable to create envelope from given source:

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: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Unable to create envelope from given source:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Unable to create envelope from given source:
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:263)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
… 20 more

Below the list of some configuration file of my mondrian environments

file located in the folder [TOMCAT_HOME]\webapps\mondrian\WEB-INF\
datasources.xml
mondrian.properties
web.xml
**rename the file extension according to the above

file located in the folder [TOMCAT_HOME]\webapps\mondrian\WEB-INF\queries\
xmla.jsp
mondrianXMLA.jsp
**rename it to .jsp

2 Responses

  1. […] Error on Mondrian – JPivot pivot table by XMLA […]

  2. For how to install & config Mondrian OLAP server, please see my blog at:
    http://spagobi.blogspot.com/2010/07/how-to-install-config-mondrian-olap.html

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: