Mondrian 4.1.1.0 - Issue #410

sanjayraja · 2014-12-17T13:41:52Z

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 Mondrian

Can someone please help me in understanding what I am doing wrong ?

Regards,
Sanjay

lucboudreau · 2014-12-17T14:38:08Z

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 notifications@github.com
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 Mondrian

Can someone please help me in understanding what I am doing wrong ?

Regards,
Sanjay

—
Reply to this email directly or view it on GitHub
#410.

sanjayraja · 2014-12-18T03:49:11Z

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.

julianhyde · 2014-12-18T21:13:57Z

If I'm not mistaken, minor version should be 1. An int field is not capable of holding both minor version and patch version.

sanjayraja · 2014-12-22T15:08:10Z

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.

sanjayraja · 2015-01-06T13:30:06Z

Issue resolved by clearing up a few dependencies - Thanks

Backlog-32242 9.0 shared lib update

sanjayraja closed this as completed Jan 6, 2015

buildguy pushed a commit that referenced this issue Jan 24, 2024

Merge pull request #410 from hbfernandes/BACKLOG-32242-9.0

f6b2e9b

Backlog-32242 9.0 shared lib update

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Mondrian 4.1.1.0 - Issue #410

Mondrian 4.1.1.0 - Issue #410

sanjayraja commented Dec 17, 2014

lucboudreau commented Dec 17, 2014

sanjayraja commented Dec 18, 2014

julianhyde commented Dec 18, 2014

sanjayraja commented Dec 22, 2014

sanjayraja commented Jan 6, 2015

Mondrian 4.1.1.0 - Issue #410

Mondrian 4.1.1.0 - Issue #410

Comments

sanjayraja commented Dec 17, 2014

lucboudreau commented Dec 17, 2014

sanjayraja commented Dec 18, 2014

julianhyde commented Dec 18, 2014

sanjayraja commented Dec 22, 2014

sanjayraja commented Jan 6, 2015