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
  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