javax.servlet.ServletException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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 );
    via by Elias Khabie,
  • 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 );
    via by Elias Khabie,
  • Mondrian 4.1.1.0 - Issue
    via GitHub by sanjayraja
    ,
  • Error loading pentaho cube using saiku
    via Stack Overflow by haki
    ,
  • Use saiku with apache hive
    via Stack Overflow by He Bai
    ,
  • Jasper OLAP desinger 4.0 connection with hive
    via Stack Overflow by yyny
    ,
    • 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

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,