Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error While using 'Non Empty' function in MDX

  1. #1

    Default Error While using 'Non Empty' function in MDX

    Hi All,

    I am getting the error when I am using 'non empty' function in MDX.

    Actually, I am using XMLA service of the latest Mondrian 3.2.1.

    But it works fine when i use XMLA service of Biserver-3.9.

    Please find the error stack below,

    2011-09-21 14:28:43,173 DEBUG [mondrian.rolap.FastBatchingCellReader$Batch] Batch.loadAggregation (millis) 109
    2011-09-21 14:28:43,173 DEBUG [mondrian.rolap.FastBatchingCellReader] loadAggregation (millis): 109
    2011-09-21 14:28:43,173 DEBUG [mondrian.olap.ResultBase] RolapResult<init>: FREE_MEMORY: 487179kb 88.00%
    2011-09-21 14:28:43,189 DEBUG [mondrian.mdx] 1: exec: 297 ms
    2011-09-21 14:28:43,204 ERROR [mondrian.xmla.XmlaServlet] Errors when handling XML/A message
    mondrian.xmla.XmlaException: Mondrian Error:XMLA Execute unparse results error
    at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:697)
    at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:551)
    at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:426)
    at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:329)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember
    at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:569)
    at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:679)
    at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176)
    at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:166)
    at mondrian.rolap.RolapMemberBase.getPropertyValue(RolapMemberBase.java:368)
    at mondrian.rolap.RolapMemberBase.getPropertyValue(RolapMemberBase.java:294)
    at mondrian.rolap.DelegatingRolapMember.getPropertyValue(DelegatingRolapMember.java:105)
    at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.writeMember(XmlaHandler.java:2137)
    at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axis(XmlaHandler.java:2107)
    at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axes(XmlaHandler.java:1974)
    at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.unparse(XmlaHandler.java:1784)
    at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:690)
    ... 23 more
    2011-09-21 14:28:43,204 DEBUG [mondrian.xmla.impl.DefaultXmlaServlet] XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
    <SOAP-ENV:Header>
    </SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <SOAP-ENV:Fault>
    <faultcode>SOAP-ENV:Server.00HSBE03</faultcode>
    <faultstring>XMLA Execute unparse results error</faultstring>
    <faultactor>Mondrian</faultactor>
    <detail>
    <XA:error xmlns:XA="http://mondrian.sourceforge.net">
    <code>00HSBE03</code>
    <desc>The Mondrian XML: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember</desc>
    </XA:error>
    </detail>
    </SOAP-ENV:Fault>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>




    Please help me to solve this error,


    Thanks & Regards,
    Dhanesh
    Last edited by dhaneshmkumar; 09-28-2011 at 02:59 AM.

  2. #2

  3. #3

    Default

    Hi,

    I have tried rewritting my MDX query by [All Member].Children ,But this also dint work.

    This is bit strange as with XMLA of BI server its working fine...

    My mondrian server is the one manually deployed on JBOSS server. Is there anything to do because of this?


    Regards,
    Dhanesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.