PAT and XMLA (MSAS 2K)

[ss4...@yahoo.co.uk]

Hi,

i've tried your latest release of PAT and i'm very impressed.
I'd like to thank you all for I've been searching for a replacement of
our current proprietary, windows/IE-only olap solution. PAT looks very
promising. The different user modes are just perfect! Can't wait for
the 0.5 and 0.6 releases.

I have a question about the current functionality. Are XMLA
connections supposed to work? I've tried to connect to our MSAS 2K
server but was unable to.

[Luc]

Hello,

I test it regularly against MSAS 2008 and so far it always worked. Can
you provide us a more detailed stack trace or log message so we can
help you?

Luc

On Jul 28, 10:36 am, "ss4m...@yahoo.co.uk" <ss4m...@yahoo.co.uk>
wrote:

[ss4...@yahoo.co.uk]

Hi Luc,

is this log message helpful?

ERROR - Cannot establish the connection.
org.olap4j.OlapException: This connection encountered an exception
while executi
ng a query.
at org.olap4j.driver.xmla.XmlaHelper.createException
(XmlaHelper.java:35)

at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx
(XmlaOlap4jConnection.
java:651)
at
org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getMetadata(XmlaOla
p4jDatabaseMetaData.java:131)
at
org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getDatasources(Xmla
Olap4jDatabaseMetaData.java:976)
at
org.olap4j.driver.xmla.XmlaOlap4jConnection.getDataSourceInfo(XmlaOla
p4jConnection.java:268)
at org.olap4j.driver.xmla.XmlaOlap4jConnection.generateRequest
(XmlaOlap4
jConnection.java:789)
at org.olap4j.driver.xmla.XmlaOlap4jConnection.populateList
(XmlaOlap4jCo
nnection.java:621)
at org.olap4j.driver.xmla.DeferredNamedListImpl.populateList
(DeferredNam
edListImpl.java:100)
at org.olap4j.driver.xmla.DeferredNamedListImpl.getList
(DeferredNamedLis
tImpl.java:69)
at org.olap4j.driver.xmla.DeferredNamedListImpl.size
(DeferredNamedListIm
pl.java:88)
at org.olap4j.driver.xmla.XmlaOlap4jConnection.getCatalog
(XmlaOlap4jConn
ection.java:392)
at org.olap4j.driver.xmla.XmlaOlap4jConnection.getSchema
(XmlaOlap4jConne
ction.java:566)
at
org.pentaho.pat.server.services.impl.DiscoveryServiceImpl.getCubes(Di
scoveryServiceImpl.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at
org.springframework.security.intercept.method.aopalliance.MethodSecur
ityInterceptor.invoke(MethodSecurityInterceptor.java:66)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke
(JdkDynami
cAopProxy.java:204)
at $Proxy16.getCubes(Unknown Source)
at
org.pentaho.pat.server.services.impl.SessionServiceImpl.createConnect
ion(SessionServiceImpl.java:160)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at
org.springframework.security.intercept.method.aopalliance.MethodSecur
ityInterceptor.invoke(MethodSecurityInterceptor.java:66)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke
(JdkDynami
cAopProxy.java:204)
at $Proxy15.createConnection(Unknown Source)
at org.pentaho.pat.server.servlet.SessionServlet.connect
(SessionServlet.
java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse
(RPC.java:5
27)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(Remot
eServiceServlet.java:166)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost
(RemoteServ
iceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
820)
at org.mortbay.jetty.servlet.ServletHolder.handle
(ServletHolder.java:502
)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(Servlet
Handler.java:1157)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:378)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.
invoke(FilterSecurityInterceptor.java:109)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.
doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.SessionFixationProtectionFilter.doFil
terHttp(SessionFixationProtectionFilter.java:67)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.ExceptionTranslationFilter.doFilterHt
tp(ExceptionTranslationFilter.java:101)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.providers.anonymous.AnonymousProcessingF
ilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.rememberme.RememberMeProcessingFilter
.doFilterHttp(RememberMeProcessingFilter.java:116)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.wrapper.SecurityContextHolderAwareReques
tFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.basicauth.BasicProcessingFilter.doFil
terHttp(BasicProcessingFilter.java:174)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
(AbstractProcessingFilter.java:277)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(Logo
utFilter.java:89)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.context.HttpSessionContextIntegrationFil
ter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter
(FilterCha
inProxy.java:175)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
elegatingFilterProxy.java:236)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
ingFilterProxy.java:167)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(Servlet
Handler.java:1148)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:3
87)
at org.mortbay.jetty.security.SecurityHandler.handle
(SecurityHandler.jav
a:216)
at org.mortbay.jetty.servlet.SessionHandler.handle
(SessionHandler.java:1
81)
at org.mortbay.jetty.handler.ContextHandler.handle
(ContextHandler.java:7
65)
at org.mortbay.jetty.webapp.WebAppContext.handle
(WebAppContext.java:417)

at org.mortbay.jetty.handler.ContextHandlerCollection.handle
(ContextHand
lerCollection.java:230)
at org.mortbay.jetty.handler.HandlerCollection.handle
(HandlerCollection.
java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle
(HandlerWrapper.java:1
52)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest
(HttpConnection.java:53
5)
at org.mortbay.jetty.HttpConnection$RequestHandler.content
(HttpConnectio
n.java:880)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:
218)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:
404)
at org.mortbay.io.nio.SelectChannelEndPoint.run
(SelectChannelEndPoint.ja
va:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run
(QueuedThreadPool.j
ava:520)
Caused by: org.olap4j.driver.xmla.proxy.XmlaOlap4jProxyException: This
proxy enc
ountered an exception while processing the query.
at org.olap4j.driver.xmla.proxy.XmlaOlap4jHttpProxy.getResponse
(XmlaOlap
4jHttpProxy.java:125)
at org.olap4j.driver.xmla.proxy.XmlaOlap4jAbstractHttpProxy.get
(XmlaOlap
4jAbstractHttpProxy.java:169)
at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx
(XmlaOlap4jConnection.
java:640)
... 97 more
Caused by: java.io.IOException: Server returned HTTP response code:
500 for URL:
http://10.1.1.6/xmla/msxisapi.dll
at sun.net.www.protocol.http.HttpURLConnection.getInputStream
(Unknown So
urce)
at org.olap4j.driver.xmla.proxy.XmlaOlap4jHttpProxy.getResponse
(XmlaOlap
4jHttpProxy.java:90)
... 99 more

[Luc Boudreau]

Browsing through our database, I found the following related bug.

http://sourceforge.net/tracker/?func=detail&aid=2105859&group_id=168953&atid=848534

We really don't have many users using MSAS 2000. Close to none actually. But it's your lucky day and I feel generous... =) I fixed this issue. It was a very simple fix, but as I said, since no one sends us feedback for SSAS 2k compliance, this issue had slipped out of memory.

It is now fixed in the olap4j XMLA driver. The changes should be available for PAT soon enough too. Thanks for reporting this. It's really appreciated. Feel free to send us more feedback.

Cheers!
_____________________________
Luc Boudreau

[Luc]

If you have time to try it again, grab the latest PAT build right
there :

http://ci.pentaho.com/job/Pentaho_Analysis_Tool/301/org.pentaho$pat/artifact/org.pentaho/pat/0.5.0-SNAPSHOT/pat-0.5.0-SNAPSHOT.war

These are CI builds, so I really don't know how usable it is. It does
include the olap4j fix for MSAS2k though.

Enjoy!

On Jul 28, 11:31 am, Luc Boudreau <lucboudr...@gmail.com> wrote:
> Browsing through our database, I found the following related bug.
>

> http://sourceforge.net/tracker/?func=detail&aid=2105859&group_id=1689...

>
> We really don't have many users using MSAS 2000. Close to none actually. But
> it's your lucky day and I feel generous... =) I fixed this issue. It was a
> very simple fix, but as I said, since no one sends us feedback for SSAS 2k
> compliance, this issue had slipped out of memory.
>
> It is now fixed in the olap4j XMLA driver. The changes should be available
> for PAT soon enough too. Thanks for reporting this. It's really appreciated.
> Feel free to send us more feedback.
>
> Cheers!
> _____________________________
> Luc Boudreau
>

> On Tue, Jul 28, 2009 at 10:58 AM, ss4m...@yahoo.co.uk
> <ss4m...@yahoo.co.uk>wrote:

> ...
>
> read more »

[ss4...@yahoo.co.uk]

Hi Luc,

thanks for your effort. I've tried to connect again and still no
luck.
The error message in the app says: "Connection could not be
established: Invalid type signature for
org.pentaho.pat.rpc.dto.CubeConnection"

2009-07-29 07:12:42.973:/:WARN: SessionServlet: An
IncompatibleRemoteServiceException was thrown while processing this
call.
com.google.gwt.user.client.rpc.IncompatibleRemoteServiceException:
Invalid type signature for org.pentaho.pat.rpc.dto.CubeConnection
at com.google.gwt.user.server.rpc.RPC.decodeRequest(RPC.java:298)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall
(RemoteServiceServlet.java:164)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost
(RemoteServiceServlet.java:86)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
502)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter
(ServletHandler.java:1157)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:378)

at
org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke
(FilterSecurityInterceptor.java:109)
at
org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter
(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at
org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp
(SessionFixationProtectionFilter.java:67)
at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at
org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp
(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp
(AnonymousProcessingFilter.java:105)

at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp
(RememberMeProcessingFilter.java:116)

at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp
(SecurityContextHolderAwareRequestFilter.java:91)

at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp
(BasicProcessingFilter.java:174)

at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
(AbstractProcessingFilter.java:277)

at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp
(LogoutFilter.java:89)

at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy

$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp
(HttpSessionContextIntegrationFilter.java:235)

at org.springframework.security.ui.SpringSecurityFilter.doFilter
(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.springframework.security.util.FilterChainProxy.doFilter
(FilterChainProxy.java:175)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate
(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter
(DelegatingFilterProxy.java:167)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter
(ServletHandler.java:1148)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:387)
at org.mortbay.jetty.security.SecurityHandler.handle
(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle
(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle
(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
417)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle
(ContextHandlerCollection.java:230)
at org.mortbay.jetty.handler.HandlerCollection.handle
(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle
(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
535)
at org.mortbay.jetty.HttpConnection$RequestHandler.content
(HttpConnection.java:880)

at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run
(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run
(QueuedThreadPool.java:520)

Caused by: com.google.gwt.user.client.rpc.SerializationException:
Invalid type signature for org.pentaho.pat.rpc.dto.CubeConnection
at
com.google.gwt.user.server.rpc.impl.ServerSerializationStreamReader.validateTypeVersions
(ServerSerializationStreamReader.java:737)
at
com.google.gwt.user.server.rpc.impl.ServerSerializationStreamReader.deserialize
(ServerSerializationStreamReader.java:492)
at
com.google.gwt.user.client.rpc.impl.AbstractSerializationStreamReader.readObject
(AbstractSerializationStreamReader.java:61)
at com.google.gwt.user.server.rpc.impl.ServerSerializationStreamReader
$ValueReader$8.readValue(ServerSerializationStreamReader.java:131)
at
com.google.gwt.user.server.rpc.impl.ServerSerializationStreamReader.deserializeValue
(ServerSerializationStreamReader.java:372)
at com.google.gwt.user.server.rpc.RPC.decodeRequest(RPC.java:287)
... 57 more

[Luc Boudreau]

"Caused by: com.google.gwt.user.client.rpc.SerializationException: Invalid type signature for org.pentaho.pat.rpc.dto.CubeConnection"

This is an entirely different exception, most probably caused by the current unstability of PAT. We're in the middle of a major refactoring (again...) so testing it now would be more trouble than what it's worth. Keep an eye out for our next release and it should be working A1.

In the meantime, if you can test olap4j without the PAT GUI, that would be greatly appreciated. Olap4j's CI builds are available at this adress :

http://ci.pentaho.com/view/Analysis/job/OLAP4J/

Cheers!

_____________________________
Luc Boudreau

[ss4...@yahoo.co.uk]

Hi Luc,

I will try to test olap4j. I'd have to say though, I have minimal
programming experience (and none in java programming).
I noticed the olap4j specification html on olap4j.org. There are some
pieces of code to help me in the right direction.

By the way, i noticed yesterday that the msas 2k server i'm testing
against is configured in a a-typical way. It has multiple datasources
specified in the datasources.xml for a single connection string. Some
olap clients (like jpivot, jpalo2) seem to be having difficulties with
this. Don't know about pat/olap4j yet.

Kind regards

On 29 jul, 15:54, Luc Boudreau <lucboudr...@gmail.com> wrote:
> "Caused by: com.google.gwt.user.client.rpc.SerializationException: Invalid
> type signature for org.pentaho.pat.rpc.dto.CubeConnection"
>