oswalxy

Dont't know with MS SQL Server 2005: I'm trying to make it work with MS AS 2000 that's still mostly used out there. My MSAS and the XMLA inside IIS have been configured as described by Microsoft. Everything works fine: demos, direct calls to SOAP and even JPIVOT (not the one provided with JasperServer) navigates well MSAS 2000 cubes. But I have this error (discover method invalid) with OLAP view navigation in JasperServer: I think should be something related to the integration between JasperServer and the embedded jPivot. As I said in my previous post I noticed a strange double quoted urn schemas generated by JasperServer calling jPivot. Any other idea? A.

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> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> <RequestType xmlns="urn:schemas-microsoft-com:xml-analysis">MDSCHEMA_DIMENSIONS</RequestType> <Restrictions xmlns="urn:schemas-microsoft-com:xml-analysis"> <RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis"> <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> <Properties xmlns="urn:schemas-microsoft-com:xml-analysis"> <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"> <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> <detail> <faultstring> <Error Description="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""'." ErrorCode="2293893127" Source="XML for Analysis Provider"/> </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 - 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.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) Caused by: 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) ... 63 more 16:53:44,805 ERROR JSErrorPage_jsp,http-8081-Processor25:146 - 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)

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.

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 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?

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.

I realize now that there is a much more appropriate group "JasperIntelligence Discussion/Help" to discuss about this so I'm moving there. A.

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 or any suggestion on how to connect to Microsoft Analysis Services? A.