[Mondrian] XML/A support in mondrian not working
jhyde at pentaho.com
Mon Mar 7 12:54:23 EST 2011
I am surprised that Mondrian is generating
select count(*) from (select distinct "customer"."fullname" from
"customer" as "customer") as "init"
select count(distinct "customer"."fullname") from "customer"
If it generated the latter I think it would work. So I think there is a bug
in Mondrian's Derby dialect (or Mondrian can't identify that it is talking
I confess that I've never run mondrian against a Derby instance embedded in
the jar file. You might try hypersonic and its variants (hsqldb, h2)
> -----Original Message-----
> From: mondrian-bounces at pentaho.org
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Robert Lemmen
> Sent: Monday, March 07, 2011 3:07 AM
> To: mondrian at pentaho.org
> Subject: Re: [Mondrian] XML/A support in mondrian not working
> hi julian,
> On Fri, Mar 04, 2011 at 11:33:48AM -0800, Julian Hyde wrote:
> > I looked more closely at this. I don't think it has
> anything to do with
> > distinct-count. That just happens to be the first query
> Mondrian executes.
> > I see you got the error "Container was opened in read-only
> mode". According
> > to
> http://db.apache.org/derby/releases/release-10.1.3.1.html this is a
> > symptom of bug DERBY-541.
> > Suggest you upgrade Derby.
> thanks, that was it! I thought i had a recent derby, but indeed i was
> confused about the different CLASSPATH (as always).
> however, i am still not quite there yet. i now get a different error
> message "The Mondrian XML: Feature not implemented"
> if i look in catalina.out, more detail is provided:
> mondrian.xmla.XmlaServlet#doPost: Errors when handling XML/A message
> mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse
> results error
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal
> error: while counting members of level '[Customers].[Name];
> count(*) from (select distinct "customer"."fullname" from
> "customer" as
> "customer") as "init"]
> Caused by: java.sql.SQLException: Feature not implemented
> Caused by: ERROR XSAI3: Feature not implemented
> at org.apache.derby.impl.store.raw.RawStore.checkVersion(Unknown
> at org.apache.derby.iapi.store.access.DiskHashtable.<init>(Unknown
> spillToDisk() is probably not going to work if the database
> is embedded
> in the jjar, right? I set the memory params of tomcat to ridiculously
> high based on the assumption that it wouldn't "spill" then, but to no
> avail... any ideas?
> thanks robert
> Robert Lemmen http://www.semistable.com
> Mondrian mailing list
> Mondrian at pentaho.org
More information about the Mondrian