JasperServer and MS Analysis Services?

oswalxy · May 16, 2007

I'm trying to configure JasperServer to navigate some cubes made in MS Analysis Services.

Everything should be fine from the MS side.

Then I go to JasperServer and:

1) from within repository.olap.connections I add a new "OLAP Client connection" of type "XML/A Connection" where I specify:

-DataSource=Provider=MSOLAP.2;DataSource=localhost;Catalog=Foodmart 2000

-URI=http://localhost/xmla/msxisapi.dll

2) from within olap.views I add a new "Analysis view" where I specify:

-OLAP Client Connection from Content Repository=the formerly defined connection

- MDX Query=select

{[Measures].[unit Sales]} on columns,

order(except([Promotion Media].[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].[unit Sales],DESC) on rows

from Sales

3) Then I try to navigate the cube clicking on the defined view but I've got an "error" saying

"Error Message:

com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=HTTP fault string=(401)Unauthorized fault actor=null

Error Trace:

com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=HTTP fault string=(401)Unauthorized fault actor=null...."

By the way I tried exacly the same configuration both with "JasperServer 1.2.1 OpenSource" and "JasperServer Professional 1.2 Evaluation": same results and same error.

Any idea, sample or any suggestion on how to connect to Microsoft Analysis Services?

A.

bamazur · May 18, 2007

Hi A-

We are currently investigating the issue connecting JasperAnalysis to Microsoft Analysis Services. I should have an update soon, and will make sure to let you know what we find.

Thanks,

Beth

sbirney · May 19, 2007

Try testing that your analysis services is set up correctly by hitting the url in your browser (use firefox because IE will display its own error page) and you should see something like this

Code:


<soap:Envelope xmlns:Â«Â»soap="http://schemas.xmlsoap.org/soap/envelope/">
 <soap:Body>
  <soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <faultcode>XMLAnalysisError.0xc10e0002</faultcode>
  <faultstring>Parser: The syntax for 'GET' is incorrect.</faultstring>
  <detail>
   <Error ErrorCode="3238920194" Description="Parser: The syntax for 'GET' is incorrect." Source="Unknown" HelpFile=""/>
  </detail>
  </soap:Fault>
 </soap:Body>
</soap:Envelope>

swood · May 19, 2007

A 401 error means unauthorized.

Analysis Services will want a user name and password as part of the XML/A Connection.

Were you including a valid username/password?

Sherman

JasperSoft

oswalxy · May 24, 2007

Yes it's something related to authentication but there's something more I can't understand.

To explore the problem I installed a brand new jPivot just inside the TomCat that comes with JasperServer.

I create a: "jasperserver-1.2.1apache-tomcatwebappsjpivotWEB-INFqueriesMyTest.jsp"

with this content:

<%@ page session="true" 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://MyServer/xmla/msxisapi.dll"

dataSource="Provider=MSOLAP.2;DataSource=MyServer;"

catalog="FoodMart 2000">

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="title" scope="session">MyTest</c:set>

Then I test it inside my browser and everything works like a charm. I use this URL:

"http://MyServer:8081/jpivot/testpage.jsp?query=MyTest"

OK, so TomCat works and either jPivot and MS Analysis Services do the same.

In Jasper Server I had some trouble because I dont' understand where to configure the OLAP Client in the unauthenticated mode. I tried to go straight inside the MySQL repository to make some modification to connection...

But in any case now the authentication issue should be fixed as I don't have any 401 error but I always have this new one that I can't figure how to solve:

"Error Message:

com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=XMLAnalysisError.88BA0807 fault string=The Web Service does not support the method 'Discover' with URI 'urn:schemas-microsoft-com:xml-analysis' and SOAPAction '""urn:schemas-microsoft-com:xml-analysis:Discover""'. fault actor=XML for Analysis Provider

Error Trace:

com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=XMLAnalysisError.88BA0807 fault string=The Web Service does not support the method 'Discover' with URI 'urn:schemas-microsoft-com:xml-analysis' and SOAPAction '""urn:schemas-microsoft-com:xml-analysis:Discover""'. fault actor=XML for Analysis Provider

at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:248)

at com.jaspersoft.jasperserver

"

Any idea?

swood · May 25, 2007

We have gotten the OLAP configuration to work with Analysis Services 2005, but have not tested it out with 2000.

The errors you are seeing are coming from Analysis Services 2000 sending SOAP/XML that JasperAnalysis does not understand.

For a connection to the Analysis Services 2005 demo cube, Adventure Works, create an XML/A Connection in JasperAnalysis as follows:

Catalog: Adventure Works DW Standard Edition

DataSource: Provider=MSOLAP;DataSource=localhost

URI: http://<server>/xmla/msmdpump.dll

Username and password: as set up on the Analysis Services server.

JasperAnalysis will send the user name/password via HTTP Basic.

Sherman

JasperSoft

oswalxy · June 5, 2007

I'm stuck with the same problem and can't figure out how to solve.

I HAVE a jpivot installed onto the same tomcat that work perfectly over a MS AS cube.

For that I have setup a JSP with some parameter (URI, datasource, catalog...). See my previous post for all the details.

Then I entered EXACTLY the same parameters inside jasperserver repository but when I open the view I have the "88BA0807" error I already explained.

I think should be something related on the way jasperserver communicate with its embedded jpivot: maybe jasperserver add some default parameters or something that jpivot in that specific configuration doesn't like.

Can we have some details on how jasperserver build the communication with jpivot starting from its jixmlaconnection table?

Does jasperserver use any filesystem based definition or work just from its database repository?

Can we have some more specification on this and some handle to put hands on?

I think many others like me wanted to use this environment to build analysis portal and you know MS is very strong on the OLAP engine.

Thanx.

swood · June 5, 2007

It looks like JPivot is having troubles communicating with MSAS 2000. I know this used to work in the past, but maybe the upgrade related to MSAS 2005 broke things. we will have to recreate the environment to see what is going on.

Sherman

JasperSoft

oswalxy · June 6, 2007

I have further investigated. I went to log4j and activated the "### jpivot loggers" and "### enable to see XMLA server messages". Then I went to jasperserver and tried to run my MS AS view. Got the same error but now I have a much more detailed log maybe some expert can understand.

I'm wondering if it's ok to have this doble quoted discover property that i found inside the log:

'""urn:schemas-microsoft-com:xml-analysis:Discover""'

The double quotes come directly from the log. Are they OK?

In any case have a look at my error log:

The source of the configuration was classpath.

The diskStore path for this CacheManager will be set to C:Programmijasperserver-1.2.1apache-tomcattempehcache_auto_created_1181141586180.

To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.

16:53:40,703 WARN LoggerListener,http-8081-Processor25:55 - Authentication event AuthenticationSuccessEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@b364: RemoteIpAddress: 192.168.1.188; SessionId: 7C947970ECEB6D0DC98FF75EBBD1F186

16:53:40,703 WARN LoggerListener,http-8081-Processor25:55 - Authentication event InteractiveAuthenticationSuccessEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@b364: RemoteIpAddress: 192.168.1.188; SessionId: 7C947970ECEB6D0DC98FF75EBBD1F186

16:53:44,366 DEBUG XMLA_SOAP,http-8081-Processor25:108 - Constructor: given dataSource= Provider=MSOLAP;DataSource=KINGBC0;

16:53:44,382 DEBUG XMLA_SOAP,http-8081-Processor25:1201 - determineProvider from dataSourceString: Provider=MSOLAP;DataSource=KINGBC0;

16:53:44,382 DEBUG XMLA_SOAP,http-8081-Processor25:1223 - Provider is Microsoft

16:53:44,570 DEBUG XMLA_SOAP,http-8081-Processor25:1451 - Discover Request for MDSCHEMA_DIMENSIONS

16:53:44,648 DEBUG XMLA_SOAP,http-8081-Processor25:1625 - <?xml version="1.0" encoding="UTF-8"?>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<RequestType xmlns="urn:schemas-microsoft-com:xml-analysis">MDSCHEMA_DIMENSIONS</RequestType>

<CATALOG_NAME xmlns="urn:schemas-microsoft-com:xml-analysis">FoodMart 2000</CATALOG_NAME>

<CUBE_NAME xmlns="urn:schemas-microsoft-com:xml-analysis">Sales</CUBE_NAME>

</RestrictionList>

</Restrictions>

<Catalog xmlns="urn:schemas-microsoft-com:xml-analysis">FoodMart 2000</Catalog>

<DataSourceInfo xmlns="urn:schemas-microsoft-com:xml-analysis">Provider=MSOLAP;DataSource=KINGBC0;</DataSourceInfo>

<Content xmlns="urn:schemas-microsoft-com:xml-analysis">SchemaData</Content>

</PropertyList>

</Properties>

</Discover>

</soapenv:Body>

</soapenv:Envelope>

16:53:44,774 DEBUG XMLA_SOAP,http-8081-Processor25:1460 - Discover Response for MDSCHEMA_DIMENSIONS

16:53:44,774 DEBUG XMLA_SOAP,http-8081-Processor25:1625 - <?xml version="1.0" encoding="UTF-8"?>

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

<SOAP-ENV:Body>

<SOAP-ENV:Fault>

<faultcode>XMLAnalysisError.88BA0807</faultcode>

<faultstring>The Web Service does not support the method 'Discover' with URI 'urn:schemas-microsoft-com:xml-analysis' and SOAPAction '""urn:schemas-microsoft-com:xml-analysis:Discover""'.</faultstring>

<faultactor>XML for Analysis Provider</faultactor>

</faultstring>

</detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

16:53:44,774 ERROR OlapModelProxy,http-8081-Processor25:80 -

com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=XMLAnalysisError.88BA0807 fault string=The Web Service does not support the method 'Discover' with URI 'urn:schemas-microsoft-com:xml-analysis' and SOAPAction '""urn:schemas-microsoft-com:xml-analysis:Discover""'. fault actor=XML for Analysis Provider

at com.tonbeller.jpivot.xmla.XMLA_SOAP.errorCheck(XMLA_SOAP.java:1515)

at com.tonbeller.jpivot.xmla.XMLA_SOAP.discover(XMLA_SOAP.java:1464)

at com.tonbeller.jpivot.xmla.XMLA_SOAP.discoverDim(XMLA_SOAP.java:345)

at com.tonbeller.jpivot.xmla.XMLA_Model.initCubeMetaData(XMLA_Model.java:751)

at com.tonbeller.jpivot.xmla.XMLA_Model.initialize(XMLA_Model.java:182)

at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)

at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:78)

at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:44)

at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:187)

at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:246)

at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:142)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:434)

at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:372)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:140)

at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)

at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:272)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:83)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)

at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

16:53:44,789 ERROR JSErrorPage_jsp,http-8081-Processor25:146 -