Comments (5)
Sounds like a bad build. Check the class MondrianServerVersion. It is auto
generated according to the contents of build.properties.
The ant script should take care of updating the server version file. If
it's not the case, there might be a build issue.
On Wed, Dec 17, 2014 at 8:41 AM, sanjayraja [email protected]
wrote:
Hi,
I am moving from 3.x to 4.x and have build the mondrian.war from the
4.1.1.0 branch.
I have made the appropriate schema changes as per what is required by 4.0
spec.When I try to execute an MDX Query I get the following error
The Mondrian XML: Mondrian Error:Internal error: Schema version '4.0' is
later than schema version '3.x' supported by this version of MondrianCan someone please help me in understanding what I am doing wrong ?
Regards,
Sanjay—
Reply to this email directly or view it on GitHub
#410.
from mondrian.
Hi Luc,
I have changed both the revision and version to 4.x.x in the build.properties and rebuilt.
I still get the same error. It works without any issues with older schema files.
from mondrian.
If I'm not mistaken, minor version should be 1. An int field is not capable of holding both minor version and patch version.
from mondrian.
Hi,
I have made the necessary changes and kept the minor version as 1. The Build was successful and we got both mondrian.jar and mondrian.war files. The new schema structure is still not being recognised.
I have stopped getting the Schema version '4.0' is later than schema version '3.x' supported by this version of Mondrian.
I now get The Mondrian XML: Mondrian Error:MDX cube 'avignapurchasesCube' not found
I get a cube not found error. I am using Mondrian over XMLA and the Cube name is present
and as above. The debug logs do not give more than
2014-12-22 18:05:25 ERROR XmlaServlet:324 - Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX parse failed
at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1704)
at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:759)
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:674)
at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507)
at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:729)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:467)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:359)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:319)
at org.apache.jsp.xmla_jsp._jspService(xmla_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:403)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:347)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:107)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:76)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:934)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:90)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:515)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1012)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:642)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:282)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2461)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2450)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.olap4j.OlapException: mondrian gave exception while parsing query
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:375)
at mondrian.olap4j.MondrianOlap4jPreparedStatement.<init>(MondrianOlap4jPreparedStatement.java:64)
at mondrian.olap4j.FactoryJdbc4Plus$AbstractPreparedStatement.<init>(FactoryJdbc4Plus.java:682)
at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jPreparedStatementJdbc41.<init>(FactoryJdbc41Impl.java:188)
at mondrian.olap4j.FactoryJdbc41Impl.newPreparedStatement(FactoryJdbc41Impl.java:70)
at mondrian.olap4j.MondrianOlap4jConnection.prepareOlapStatement(MondrianOlap4jConnection.java:505)
at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1700)
... 40 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query '
SELECT {[Measures].[Number Of Purchases]} ON columns, {[Purchase Item Type].Children} ON rows FROM [avignapurchasesCube]
'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:101)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:362)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:360)
at mondrian.server.Locus.execute(Locus.java:86)
at mondrian.server.Locus.execute(Locus.java:71)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356)
... 46 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX cube 'avignapurchasesCube' not found
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:974)
at mondrian.olap.Util.lookupCube(Util.java:1054)
at mondrian.olap.Query.<init>(Query.java:162)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1074)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:97)
... 51 more
2014-12-22 18:05:25 DEBUG monitor:982 - ConnectionEndEvent(6)
2014-12-22 18:05:25 DEBUG monitor:613 - ConnectionInfo{cellCacheHitCount=0, cellCacheRequestCount=0, cellCacheMissCount=0, cellCachePendingCount=0, statementStartCount=0, statementEndCount=0, executeStartCount=0, executeEndCount=0}
Here is the schema file:
<Schema name="avignapurchases" metamodelVersion="4.0">
<PhysicalSchema>
<Table name="avignapurchases"/>
<Table name="dim_date"/>
</PhysicalSchema>
<Cube name="avignapurchasesCube">
<Dimensions>
<Dimension name="Purchase Item" table="avignapurchases" key="PurchaseItemCode">
<Attributes>
<Attribute name="Purchase Item Type" column="PurchaseItemType"/>
<Attribute name="Purchase Item Group" column="PurchaseItemGroup"/>
<Attribute name="Purchase Item Category" column="PurchaseItemCategory"/>
<Attribute name="Purchase Item Code" column="PurchaseItemCode"/>
</Attributes>
</Dimension>
<Dimension name="Purchase Voucher Date" table="dim_date" key="date_key">
<Attributes>
<Attribute name="Year" column="Year"/>
<Attribute name="Quarter" column="CalendarQuarterName"/>
<Attribute name="Month" column="Month"/>
<Attribute name="Week" column="WeekNameOfYear"/>
<Attribute name="Day" column="DayNumberOfYear"/>
</Attributes>
<Hierarchies>
<Hierarchy name="Year" hasAll="false">
<Level attribute="Year"/>
</Hierarchy>
<Hierarchy name="Quarter" hasAll="false">
<Level attribute="Quarter"/>
</Hierarchy>
<Hierarchy name="Month" hasAll="false">
<Level attribute="Month"/>
</Hierarchy>
<Hierarchy name="Week" hasAll="false">
<Level attribute="Week"/>
</Hierarchy>
<Hierarchy name="Day" hasAll="false">
<Level attribute="Day"/>
</Hierarchy>
</Hierarchies>
</Dimension>
</Dimensions>
<MeasureGroups>
<MeasureGroup name="Purchases" table="avignapurchases">
<Measures>
<Measure name="Number of Purchases" column="PurchaseOrderNumber" aggregator="distinct-count" visible="true">
</Measure>
</Measures>
<DimensionLinks>
<ForeignKeyLink dimension="Purchase Item" foreignKeyColumn="PurchaseItemCode"/>
<ForeignKeyLink dimension="Purchase Voucher Date" foreignKeyColumn="PurchaseVoucherDate_date_dim"/>
</DimensionLinks>
</MeasureGroup>
</MeasureGroups>
</Cube>
</Schema>
Please advise.
from mondrian.
Issue resolved by clearing up a few dependencies - Thanks
from mondrian.
Related Issues (20)
- Are there any documents related to the mondrian source code? I hope to share one . email:[email protected]
- Are there any documents related to the mondrian source code? I hope to share one. email:[email protected]
- help me. What is the problem with this MDX query
- Aggregate tables for columnar DB
- can mondrian used LookupCube
- Latest mondrian version HOT 1
- Enable grouping sets in Mondrian 3.X for MonetDB database
- Mondrian link on description is not working
- Official Link is not working
- CacheControl.flushSchema apparently not working HOT 1
- NullPointerException in Sorter.logTuples
- OSGi Bundles
- Check whether the log4j1 vulnerability is involved in mondrian 8.2.0.5: CVE-2022-23302/23305/23307
- Pentaho data integration 9.3
- Mondrian 9.5 in Maven HOT 1
- Pentaho Maven Repository temporarily unavailable HOT 1
- How can I write an mdx query that slices by both a date range and dimension member value
- Unable to download mondrian 9 from hitachivantara maven repo HOT 1
- Issues with Dependency Access and Possible Closed Source Concerns for Mondrian
- Mondrian: Is It Heading Towards Closed-Source? HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mondrian.