javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'.

Pentaho BI Platform Tracking | Elias Khabie | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    I have this schema Time dimension <Dimension type="TimeDimension" foreignKey="IDTIME" highCardinality="false" name="Time"> <Hierarchy name="Year" hasAll="true" allMemberName="All Years" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER"> </Table> <Level name="Year" column="DEIT" type="String" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'YYYY')]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="HalfYear" hasAll="true" allMemberName="All HalfYears" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER" alias=""> </Table> <Level name="HalfYear" column="DEIT" type="String" uniqueMembers="false" levelType="TimeHalfYear"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[FLOOR(TO_CHAR(DEIT,'MM')/6)+1]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="Quarter" hasAll="true" allMemberName="All Quarters" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER"> </Table> <Level name="Quarter" column="DEIT" type="String" uniqueMembers="false" levelType="TimeQuarters"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'Q')]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="Month" hasAll="true" allMemberName="All Months" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER" alias=""> </Table> <Level name="Month" column="DEIT" type="String" uniqueMembers="false" levelType="TimeMonths"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'MM')]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="Day" hasAll="true" allMemberName="All Days" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER" alias=""> </Table> <Level name="Day" column="DEIT" type="String" uniqueMembers="false" levelType="TimeDays"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'DD')]]> </SQL> </KeyExpression> </Level> </Hierarchy> </Dimension> And when I trying to drill down the cube, Fillter by year and get values from the OLAP navigator and select only to show values from 2010 (http://img266.imageshack.us/img266/8945/filter.png) . I get the following error. JPivot had an error ... org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:527) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:276) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) ... 20 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:823) at mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:188) at mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:73) at mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:246) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:106) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:217) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141) at mondrian.olap.Query.resolve(Query.java:596) at mondrian.olap.Query.resolve(Query.java:481) at mondrian.olap.Query.toString(Query.java:692) at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQueryAdapter.java:167) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:256) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1309) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:248) ... 23 more javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:276) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) Caused by: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:823) at mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:188) at mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:73) at mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:246) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:106) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:217) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141) at mondrian.olap.Query.resolve(Query.java:596) at mondrian.olap.Query.resolve(Query.java:481) at mondrian.olap.Query.toString(Query.java:692) at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQueryAdapter.java:167) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:256) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1309) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:248) ... 23 more mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:823) at mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:188) at mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:73) at mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:246) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:106) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:217) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141) at mondrian.olap.Query.resolve(Query.java:596) at mondrian.olap.Query.resolve(Query.java:481) at mondrian.olap.Query.toString(Query.java:692) at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQueryAdapter.java:167) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:256) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1309) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:248) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) The table description is the following: CREATE TABLE TIMEBMV( IDTIME INTEGER PRIMARY KEY , DEIT DATE );

    Pentaho BI Platform Tracking | 6 years ago | Elias Khabie
    javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'.
  2. 0

    I have this schema Time dimension <Dimension type="TimeDimension" foreignKey="IDTIME" highCardinality="false" name="Time"> <Hierarchy name="Year" hasAll="true" allMemberName="All Years" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER"> </Table> <Level name="Year" column="DEIT" type="String" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'YYYY')]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="HalfYear" hasAll="true" allMemberName="All HalfYears" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER" alias=""> </Table> <Level name="HalfYear" column="DEIT" type="String" uniqueMembers="false" levelType="TimeHalfYear"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[FLOOR(TO_CHAR(DEIT,'MM')/6)+1]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="Quarter" hasAll="true" allMemberName="All Quarters" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER"> </Table> <Level name="Quarter" column="DEIT" type="String" uniqueMembers="false" levelType="TimeQuarters"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'Q')]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="Month" hasAll="true" allMemberName="All Months" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER" alias=""> </Table> <Level name="Month" column="DEIT" type="String" uniqueMembers="false" levelType="TimeMonths"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'MM')]]> </SQL> </KeyExpression> </Level> </Hierarchy> <Hierarchy name="Day" hasAll="true" allMemberName="All Days" primaryKey="IDTIME"> <Table name="TIMEBMV" schema="ORCADWH_USER" alias=""> </Table> <Level name="Day" column="DEIT" type="String" uniqueMembers="false" levelType="TimeDays"> <KeyExpression> <SQL dialect="oracle"> <![CDATA[TO_CHAR(DEIT,'DD')]]> </SQL> </KeyExpression> </Level> </Hierarchy> </Dimension> And when I trying to drill down the cube, Fillter by year and get values from the OLAP navigator and select only to show values from 2010 (http://img266.imageshack.us/img266/8945/filter.png) . I get the following error. JPivot had an error ... org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:527) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:276) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) ... 20 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:823) at mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:188) at mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:73) at mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:246) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:106) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:217) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141) at mondrian.olap.Query.resolve(Query.java:596) at mondrian.olap.Query.resolve(Query.java:481) at mondrian.olap.Query.toString(Query.java:692) at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQueryAdapter.java:167) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:256) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1309) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:248) ... 23 more javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:276) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) Caused by: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:823) at mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:188) at mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:73) at mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:246) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:106) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:217) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141) at mondrian.olap.Query.resolve(Query.java:596) at mondrian.olap.Query.resolve(Query.java:481) at mondrian.olap.Query.toString(Query.java:692) at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQueryAdapter.java:167) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:256) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1309) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:248) ... 23 more mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'. at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:823) at mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:188) at mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:73) at mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:246) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:106) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:217) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141) at mondrian.olap.Query.resolve(Query.java:596) at mondrian.olap.Query.resolve(Query.java:481) at mondrian.olap.Query.toString(Query.java:692) at com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQueryAdapter.java:167) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:256) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54) at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1309) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:248) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:619) The table description is the following: CREATE TABLE TIMEBMV( IDTIME INTEGER PRIMARY KEY , DEIT DATE );

    Pentaho BI Platform Tracking | 6 years ago | Elias Khabie
    javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Mondrian 4.1.1.0 - Issue

    GitHub | 2 years ago | sanjayraja
    mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX parse failed

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.olap.MondrianException

      Mondrian Error:Tuple contains more than one member of hierarchy '[Time.Year]'.

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:823)
      1 frame
    3. mondrian.olap.type
      TupleType.checkHierarchies
      1. mondrian.olap.type.TupleType.checkHierarchies(TupleType.java:188)
      1 frame
    4. mondrian.olap.fun
      FunDefBase.createCall
      1. mondrian.olap.fun.TupleFunDef.getResultType(TupleFunDef.java:73)
      2. mondrian.olap.fun.FunDefBase.createCall(FunDefBase.java:246)
      2 frames
    5. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:106)
      1 frame
    6. mondrian.olap
      ValidatorImpl.validate
      1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
      1 frame
    7. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929)
      1 frame
    8. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103)
      1 frame
    9. mondrian.olap
      Query.toString
      1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
      2. mondrian.olap.QueryAxis.resolve(QueryAxis.java:217)
      3. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141)
      4. mondrian.olap.Query.resolve(Query.java:596)
      5. mondrian.olap.Query.resolve(Query.java:481)
      6. mondrian.olap.Query.toString(Query.java:692)
      6 frames
    10. com.tonbeller.jpivot
      TableComponent.render
      1. com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQueryAdapter.java:167)
      2. com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:256)
      3. com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
      4. com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48)
      5. com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
      6. com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246)
      7. com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251)
      8. com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235)
      8 frames
    11. com.tonbeller.wcf
      RendererTag.doEndTag
      1. com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
      1 frame
    12. org.apache.jsp
      testpage_jsp._jspService
      1. org.apache.jsp.testpage_jsp._jspx_meth_wcf_005frender_005f6(testpage_jsp.java:1309)
      2. org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:248)
      2 frames
    13. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      1 frame
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame
    15. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
      3 frames
    16. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    18. com.tonbeller.wcf
      RequestFilter.doFilter
      1. com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
      2. com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
      3. com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
      3 frames
    19. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      8 frames
    20. Grizzly HTTP
      AprEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
      2. org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
      3. org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
      3 frames
    21. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame