PAT completely unstable

[FSch]

Hi,

I installed the pat server, connected to an existing (very small) cube
via XMLA and tried to play arround with queries.
Unfortunately nearly none of my queries is working, even a simple
expanding of a dimension results to 'Query Execution Failed: An
exception was encountered while executing the query'. Unusable for me.

With JPivot everything works fine, the cube seems to be ok.
How do you do to make pat working correctly??

Regards
Florian

[Paul Stoellberger]

What datasource / cube are you connecting to?

Mondrian? Palo? SSAS? SAP BW?

Currently only Mondrian is really stable.
we're working on better support of the other XMLA datasources too, but there is still some work needed

-Paul

> --
> You received this message because you are subscribed to the Google Groups "pentahoanalysistool-users" group.
> To post to this group, send email to pentahoanaly...@googlegroups.com.
> To unsubscribe from this group, send email to pentahoanalysistoo...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/pentahoanalysistool-users?hl=en.
>

[FSch]

I'm connecting to a Mondrian server!

What I do is simply expanding 2 dimensions, the first works, the
second not.

MDX looks like that:

SELECT

NON EMPTY { { [DIM_1.H_1].[All], [DIM_1.H_1].[All].Children } } ON
COLUMNS,
NON EMPTY { { [DIM_2.H_1].[All], [DIM_2.H_1].[All].Children } } ON
ROWS FROM
[MYCUBE]


The server output shows the following exception:

09:29:42,714 ERROR [AbstractServlet] A RPC call resulted in the
following except
ion :
com.google.gwt.user.server.rpc.UnexpectedException: Service method
'public abstr
act org.pentaho.pat.rpc.dto.CellDataSet
org.pentaho.pat.rpc.IQuery.executeQuery(
java.lang.String,java.lang.String) throws
org.pentaho.pat.rpc.exceptions.RpcExce
ption' threw an unexpected exception: java.lang.NullPointerException
at
com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:
360)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:5
46)
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:
637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
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:278)
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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:852)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint
$Worker.run(JIoEndpoint.java:48
9)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at
org.pentaho.pat.server.util.PatCellSetFormatter.formatPage(PatCellSet
Formatter.java:290)
at
org.pentaho.pat.server.util.PatCellSetFormatter.format(PatCellSetForm
atter.java:178)
at
org.pentaho.pat.server.util.OlapUtil.cellSet2Matrix(OlapUtil.java:62)

at
org.pentaho.pat.server.services.impl.QueryServiceImpl.executeQuery(Qu
eryServiceImpl.java:677)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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 $Proxy19.executeQuery(Unknown Source)
at
org.pentaho.pat.server.servlet.QueryServlet.executeQuery(QueryServlet
.java:366)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:5
27)
... 52 more

On 2 Jul., 09:08, Paul Stoellberger <p.stoellber...@googlemail.com>
wrote:

[Paul Stoellberger]

what version of pat are you using?

[FSch]

Sorry should have say that directly...using 0.7!

On 2 Jul., 10:35, Paul Stoellberger <p.stoellber...@googlemail.com>
wrote:

> what version of pat are you using?
>

> ...
>
> Erfahren Sie mehr »

[Paul Stoellberger]

We have fixed a lot of bugs and made the whole thing more stable/usable since we released 0.7

You should try a SNAPSHOT build from our CI build server

pat-server : http://ci.analytical-labs.com/job/pat-standalone-server/
pat-war : http://ci.analytical-labs.com/job/pat-standalone-war/

I remember seeing this error a while back and i'm confident that we fixed it

let us know if its resolved

p.s we're currently fixing the last bits before we release 0.8

-Paul

> --
> You received this message because you are subscribed to the Google Groups "pentahoanalysistool-users" group.
> To post to this group, send email to pentahoanaly...@googlegroups.com.
> To unsubscribe from this group, send email to pentahoanalysistoo...@googlegroups.com.

[FSch]

This looks much better, obviously the error is gone. And 0.8 looks
pretty nice!
But when playing arround, I run into OutOfMemory(Java Heap Space)
quite fast, even with my testcube (3430 entries in fact table).

On 2 Jul., 12:46, Paul Stoellberger <p.stoellber...@googlemail.com>
wrote:

> ...
>
> Erfahren Sie mehr »

[Paul -]

Are you using the WAR or the patserver ?
What have you set the heap space to?

-Paul

2010/7/2 FSch <fs22...@googlemail.com>

> ...
>
> Erfahren Sie mehr »