mondrian.olap.MondrianException: Mondrian Error...

        at $Proxy6.getMemberByUniqueName(Unknown Source)
        at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:781)
        at mondrian.rolap.RolapSchema.load(RolapSchema.java:582)
        at mondrian.rolap.RolapSchema.load(RolapSchema.java:436)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:234)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:225)
        at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:1094)
        at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:900)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:90)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:50)
        at mondrian.web.servlet.MdxQueryServlet.processRequest(MdxQueryServlet.java:85)
        at mondrian.web.servlet.MdxQueryServlet.doGet(MdxQueryServlet.java:238)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at mondrian.rolap.RolapUtil$1.invoke(RolapUtil.java:98)
        ... 33 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Member '[Region D].[云南省].[昆明市]' not found
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:939)
        at mondrian.olap.Util.lookupCompound(Util.java:876)
        at mondrian.rolap.RolapSchemaReader.lookupCompoundInternal(RolapSchemaReader.java:426)
        at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:411)
        at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getMemberByUniqueName(RolapCube.java:2894)
        at mondrian.rolap.RolapSchemaReader.getMemberByUniqueName(RolapSchemaReader.java:371)
        ... 38 more
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at mondrian.rolap.RolapUtil$1.invoke(RolapUtil.java:98)
        at $Proxy6.getMemberByUniqueName(Unknown Source)
        at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:781)
        at mondrian.rolap.RolapSchema.load(RolapSchema.java:582)
        at mondrian.rolap.RolapSchema.load(RolapSchema.java:436)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:234)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:225)
        at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:1094)
        at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:900)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:90)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:50)
        at mondrian.web.servlet.MdxQueryServlet.processRequest(MdxQueryServlet.java:85)
        at mondrian.web.servlet.MdxQueryServlet.doGet(MdxQueryServlet.java:238)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Member '[Region D].[云南省].[昆明市]' not found
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:939)
        at mondrian.olap.Util.lookupCompound(Util.java:876)
        at mondrian.rolap.RolapSchemaReader.lookupCompoundInternal(RolapSchemaReader.java:426)
        at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:411)
        at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getMemberByUniqueName(RolapCube.java:2894)
        at mondrian.rolap.RolapSchemaReader.getMemberByUniqueName(RolapSchemaReader.java:371)
        ... 38 more
mondrian.olap.MondrianException: Mondrian Error:Member '[Region D].[云南省].[昆明市]' not found
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:939)
        at mondrian.olap.Util.lookupCompound(Util.java:876)
        at mondrian.rolap.RolapSchemaReader.lookupCompoundInternal(RolapSchemaReader.java:426)
        at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:411)
        at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getMemberByUniqueName(RolapCube.java:2894)
        at mondrian.rolap.RolapSchemaReader.getMemberByUniqueName(RolapSchemaReader.java:371)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at mondrian.rolap.RolapUtil$1.invoke(RolapUtil.java:98)
        at $Proxy6.getMemberByUniqueName(Unknown Source)
        at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:781)
        at mondrian.rolap.RolapSchema.load(RolapSchema.java:582)
        at mondrian.rolap.RolapSchema.load(RolapSchema.java:436)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:234)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:225)
        at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:1094)
        at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:900)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:90)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:50)
        at mondrian.web.servlet.MdxQueryServlet.processRequest(MdxQueryServlet.java:85)
        at mondrian.web.servlet.MdxQueryServlet.doGet(MdxQueryServlet.java:238)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)


原因：把数据从Oracle迁移到MySQL后，导致D_Region表的字段PARENTID一些在Oracle中值为NULL行在导入到MySQL后
变成了空值（即''),而在MDX Schema中又采用如下配置
        <Dimension name="Region D" caption="区域" foreignKey="REGION_ID">
           <Hierarchy hasAll="true" allMemberName="All Regions D" allMemberCaption="云南省"  primaryKey="ID">
              <Table name="D_REGION"/>
          <Level name="Region Id" uniqueMembers="true" type="Numeric" column="ID" 
                         nameColumn="NAME" parentColumn="PARENTID" nullParentValue="null">
         <Closure parentColumn="PARENT_ID" childColumn="ID">
            <Table name="C_REGION_CLOSURE"/>
         </Closure>
            <Property name="Name" column="NAME"/>
            <Property name="Div Level" column="DIVLEVEL"/>
               </Level>
           </Hierarchy>
         </Dimension>
红字部分导致MDX语句在MySQL中获取'[Region D].[云南省].[昆明市]'的Member找不到父节点标识。
解决：把MySQL中表D_REGION中所有PARENTID为空的字段改为一个特殊标识值，如-1。
然后，更改MDX Schema为如下配置
......
                nullParentValue="-1"


......
 

转载于:https://my.oschina.net/u/1377774/blog/175092