com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] ]

Pentaho BI Platform Tracking | gunter rombauts | 7 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

    To test change Employee dimension of the Foodmart.mondrian.xml file to use the caption: change <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" nameColumn="full_name" nullParentValue="0"> into <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" captionColumn="full_name" nullParentValue="0"> {noformat} Run MDX : [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] {noformat} The error is shown below. {noformat} 2010-10-18 12:18:55,582 ERROR [com.tonbeller.wcf.component.RendererTag] trouble rendering table1536b248-daa1-11df-86c7-9d315f5c4f99 com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] ] at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:305) 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.jsp.Pivot_jsp._jspService(Pivot_jsp.java:2497) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1492) at mondrian.olap.Util.newError(Util.java:1508) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:633) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279) ... 70 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[select `employee`.`employee_id` as `c0`, `employee`.`marital_status` as `c1`, `employee`.`position_title` as `c2`, `employee`.`gender` as `c3`, `employee`.`salary` as `c4`, `employee`.`education_level` as `c5`, `employee`.`management_role` as `c6` from `employee` as `employee` where `supervisor_id` = 0 group by `employee`.`employee_id`, `employee`.`marital_status`, `employee`.`position_title`, `employee`.`gender`, `employee`.`salary`, `employee`.`education_level`, `employee`.`management_role` order by ISNULL(`employee`.`employee_id`), `employee`.`employee_id` ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1492) at mondrian.olap.Util.newError(Util.java:1508) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:226) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:973) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:855) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:829) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:532) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:629) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:173) at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:155) at mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:205) at mondrian.olap.fun.FunUtil.getNonEmptyMemberChildren(FunUtil.java:2038) at mondrian.olap.fun.BuiltinFunTable$28$1.evaluateMemberList(BuiltinFunTable.java:1001) at mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87) at mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:59) at mondrian.calc.impl.AbstractListCalc.evaluateMemberList(AbstractListCalc.java:84) at mondrian.olap.fun.HierarchizeFunDef$1.evaluateMemberList(HierarchizeFunDef.java:54) at mondrian.calc.impl.AbstractExpCompiler$MemberListIterCalc.evaluateMemberIterable(AbstractExpCompiler.java:569) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540) at mondrian.rolap.RolapResult.<init>(RolapResult.java:273) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:604) ... 71 more Caused by: java.sql.SQLException: Column Index out of range, 8 > 7. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkColumnBounds(ResultSet.java:690) at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:4792) at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:286) at mondrian.rolap.SqlMemberSource.makeMember(SqlMemberSource.java:1022) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:961) ... 94 more {noformat}

    Pentaho BI Platform Tracking | 7 years ago | gunter rombauts
    com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] ]
  2. 0

    To test change Employee dimension of the Foodmart.mondrian.xml file to use the caption: change <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" nameColumn="full_name" nullParentValue="0"> into <Level name="Employee Id" type="Numeric" uniqueMembers="true" column="employee_id" parentColumn="supervisor_id" captionColumn="full_name" nullParentValue="0"> {noformat} Run MDX : [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] {noformat} The error is shown below. {noformat} 2010-10-18 12:18:55,582 ERROR [com.tonbeller.wcf.component.RendererTag] trouble rendering table1536b248-daa1-11df-86c7-9d315f5c4f99 com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] ] at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:305) 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.jsp.Pivot_jsp._jspService(Pivot_jsp.java:2497) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1492) at mondrian.olap.Util.newError(Util.java:1508) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:633) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279) ... 70 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[select `employee`.`employee_id` as `c0`, `employee`.`marital_status` as `c1`, `employee`.`position_title` as `c2`, `employee`.`gender` as `c3`, `employee`.`salary` as `c4`, `employee`.`education_level` as `c5`, `employee`.`management_role` as `c6` from `employee` as `employee` where `supervisor_id` = 0 group by `employee`.`employee_id`, `employee`.`marital_status`, `employee`.`position_title`, `employee`.`gender`, `employee`.`salary`, `employee`.`education_level`, `employee`.`management_role` order by ISNULL(`employee`.`employee_id`), `employee`.`employee_id` ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816) at mondrian.olap.Util.newInternal(Util.java:1492) at mondrian.olap.Util.newError(Util.java:1508) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:226) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:973) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:855) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:829) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:532) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:629) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:173) at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:155) at mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:205) at mondrian.olap.fun.FunUtil.getNonEmptyMemberChildren(FunUtil.java:2038) at mondrian.olap.fun.BuiltinFunTable$28$1.evaluateMemberList(BuiltinFunTable.java:1001) at mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87) at mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:59) at mondrian.calc.impl.AbstractListCalc.evaluateMemberList(AbstractListCalc.java:84) at mondrian.olap.fun.HierarchizeFunDef$1.evaluateMemberList(HierarchizeFunDef.java:54) at mondrian.calc.impl.AbstractExpCompiler$MemberListIterCalc.evaluateMemberIterable(AbstractExpCompiler.java:569) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540) at mondrian.rolap.RolapResult.<init>(RolapResult.java:273) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:604) ... 71 more Caused by: java.sql.SQLException: Column Index out of range, 8 > 7. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkColumnBounds(ResultSet.java:690) at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:4792) at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:286) at mondrian.rolap.SqlMemberSource.makeMember(SqlMemberSource.java:1022) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:961) ... 94 more {noformat}

    Pentaho BI Platform Tracking | 7 years ago | gunter rombauts
    com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Org Salary]} ON COLUMNS, NON EMPTY Hierarchize(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children)) ON ROWS from [HR] ]
  3. 0

    Agg Tables: Column Index Out Of Range problem

    pentaho.com | 2 years ago
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[NumDeOpsPGAH2008q1]} ON COLUMNS, NON EMPTY Crossjoin(Hierarchize(Union(Union({[Per�*odos].[Per�*odos Todos]}, [Per�*odos].[Per�*odos Todos].Children), [Per�*odos].[Per�*odos Todos].[2008].Children)), {([Oficinas].[Oficinas Todas], [Asesores].[Asesores Todos], [Clientes].[Clientes Todos], [Productos].[Productos Todos], [GruposSocioEcon].[GruposSocioEcon Todos], [Género].[Género Todos])}) ON ROWS from [CuboGenericoPosGlobAh2008Q1] ]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQLException: After end of result set

    runawfe | 3 years ago | gritsenko_s
    java.lang.RuntimeException: java.sql.SQLException: After end of result set

    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. java.sql.SQLException

      Column Index out of range, 8 > 7.

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      ResultSet.getObject
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
      2. com.mysql.jdbc.ResultSet.checkColumnBounds(ResultSet.java:690)
      3. com.mysql.jdbc.ResultSet.getObject(ResultSet.java:4792)
      3 frames
    3. Commons DBCP
      DelegatingResultSet.getObject
      1. org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:286)
      1 frame
    4. mondrian.rolap
      RolapSchemaReader.getMemberChildren
      1. mondrian.rolap.SqlMemberSource.makeMember(SqlMemberSource.java:1022)
      2. mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:961)
      3. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:855)
      4. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:829)
      5. mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247)
      6. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210)
      7. mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:532)
      8. mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:629)
      9. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176)
      10. mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:173)
      11. mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:155)
      11 frames
    5. mondrian.olap
      DelegatingSchemaReader.getMemberChildren
      1. mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:205)
      1 frame
    6. mondrian.olap.fun
      BuiltinFunTable$28$1.evaluateMemberList
      1. mondrian.olap.fun.FunUtil.getNonEmptyMemberChildren(FunUtil.java:2038)
      2. mondrian.olap.fun.BuiltinFunTable$28$1.evaluateMemberList(BuiltinFunTable.java:1001)
      2 frames
    7. mondrian.calc.impl
      AbstractMemberListCalc.evaluateList
      1. mondrian.calc.impl.AbstractMemberListCalc.evaluateList(AbstractMemberListCalc.java:87)
      1 frame
    8. mondrian.olap.fun
      UnionFunDef$1.evaluateList
      1. mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:59)
      1 frame
    9. mondrian.calc.impl
      AbstractListCalc.evaluateMemberList
      1. mondrian.calc.impl.AbstractListCalc.evaluateMemberList(AbstractListCalc.java:84)
      1 frame
    10. mondrian.olap.fun
      HierarchizeFunDef$1.evaluateMemberList
      1. mondrian.olap.fun.HierarchizeFunDef$1.evaluateMemberList(HierarchizeFunDef.java:54)
      1 frame
    11. mondrian.calc.impl
      AbstractMemberIterCalc.evaluate
      1. mondrian.calc.impl.AbstractExpCompiler$MemberListIterCalc.evaluateMemberIterable(AbstractExpCompiler.java:569)
      2. mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52)
      2 frames
    12. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731)
      2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574)
      3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:273)
      5. mondrian.rolap.RolapConnection.execute(RolapConnection.java:604)
      5 frames
    13. com.tonbeller.jpivot
      TableComponent.render
      1. com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279)
      2. com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
      3. com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48)
      4. com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
      5. com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246)
      6. com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251)
      7. com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235)
      7 frames
    14. com.tonbeller.wcf
      RendererTag.doEndTag
      1. com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
      1 frame
    15. org.apache.jsp
      Pivot_jsp._jspService
      1. org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:2497)
      1 frame
    16. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
      1 frame
    17. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      1 frame
    18. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
      3 frames
    19. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      1 frame
    20. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    21. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
      1 frame
    22. org.springframework.security
      FilterSecurityInterceptor.doFilter
      1. org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
      2. org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
      2 frames
    23. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    24. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    25. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    26. org.pentaho.platform
      SecurityStartupFilter.doFilter
      1. org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
      1 frame
    27. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    28. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    29. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    30. org.pentaho.platform
      RequestParameterAuthenticationFilter.doFilter
      1. org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
      1 frame
    31. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    32. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    33. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    34. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    35. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    36. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    37. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    38. org.pentaho.platform
      HttpSessionReuseDetectionFilter.doFilter
      1. org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
      1 frame
    39. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    40. Spring Security - Portlet support
      HttpSessionContextIntegrationFilter.doFilterHttp
      1. org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
      1 frame
    41. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      1 frame
    42. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    43. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    44. spring-security-core
      FilterToBeanProxy.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      2. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
      3. org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
      3 frames
    45. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    46. org.pentaho.platform
      SystemStatusFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
      1 frame
    47. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    48. org.pentaho.platform
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
      1 frame
    49. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
      9 frames
    50. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
      2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      4 frames
    51. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      1 frame
    52. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame