java.sql.SQLException: After end of result set

runawfe | gritsenko_s | 3 years ago
  1. 0

    Agg Tables: Column Index Out Of Range problem

    pentaho.com | 1 year 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] ]
  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 | 6 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. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    JavaからMySQLに接続できません。その後のエラー・・・連投申し訳ござ... - Yahoo!知恵袋

    co.jp | 6 months ago
    java.sql.SQLException: Operation not allowed after ResultSet closed
  5. 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 | 6 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] ]

    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

      After end of result set

      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.checkRowPos(ResultSet.java:726)
      3. com.mysql.jdbc.ResultSet.getObject(ResultSet.java:4791)
      3 frames
    3. JBoss Application Server Connector
      WrappedResultSet.getObject
      1. org.jboss.resource.adapter.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:750)
      1 frame
    4. ru.runa.wfe
      ExecutionServiceBean.startProcess
      1. ru.runa.wfe.extension.handler.SQLActionHandler.extractResults(SQLActionHandler.java:149)
      2. ru.runa.wfe.extension.handler.SQLActionHandler.execute(SQLActionHandler.java:133)
      3. ru.runa.wfe.lang.Action.execute(Action.java:64)
      4. ru.runa.wfe.lang.GraphElement.executeActions(GraphElement.java:163)
      5. ru.runa.wfe.lang.GraphElement.fireEvent(GraphElement.java:152)
      6. ru.runa.wfe.lang.Transition.take(Transition.java:91)
      7. ru.runa.wfe.lang.Node.leave(Node.java:193)
      8. ru.runa.wfe.execution.ProcessFactory.startProcessInternal(ProcessFactory.java:169)
      9. ru.runa.wfe.execution.ProcessFactory.startProcess(ProcessFactory.java:77)
      10. ru.runa.wfe.execution.logic.ExecutionLogic.startProcess(ExecutionLogic.java:173)
      11. ru.runa.wfe.service.impl.ExecutionServiceBean.startProcess(ExecutionServiceBean.java:93)
      11 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    6. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
      1 frame
    7. org.jboss.ejb3
      InvocationContextImpl.proceed
      1. org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
      1 frame
    8. ru.runa.wfe
      EjbTransactionSupport.process
      1. ru.runa.wfe.service.interceptors.EjbTransactionSupport.invokeWithRetry(EjbTransactionSupport.java:67)
      2. ru.runa.wfe.service.interceptors.EjbTransactionSupport.process(EjbTransactionSupport.java:46)
      2 frames
    9. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:606)
      3 frames
    10. org.jboss.ejb3
      InvocationContextImpl.proceed
      1. org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
      1 frame
    11. ru.runa.wfe
      PerformanceObserver.process
      1. ru.runa.wfe.service.interceptors.PerformanceObserver.process(PerformanceObserver.java:15)
      1 frame
    12. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:606)
      3 frames
    13. org.jboss.ejb3
      InvocationContextImpl.proceed
      1. org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
      1 frame
    14. ru.runa.wfe
      EjbExceptionSupport.process
      1. ru.runa.wfe.service.interceptors.EjbExceptionSupport.process(EjbExceptionSupport.java:42)
      1 frame
    15. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:606)
      3 frames
    16. org.jboss.ejb3
      EJB3InterceptorsInterceptor.invoke
      1. org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
      2. org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
      2 frames
    17. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    18. org.jboss.ejb3
      TransactionScopedEntityManagerInterceptor.invoke
      1. org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
      1 frame
    19. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    20. org.jboss.ejb3
      AllowedOperationsInterceptor.invoke
      1. org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
      1 frame
    21. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    22. org.jboss.ejb3
      BMTInterceptor.invoke
      1. org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
      2. org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
      2 frames
    23. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    24. org.jboss.aspects
      TxPropagationInterceptor.invoke
      1. org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
      1 frame
    25. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    26. org.jboss.ejb3
      StatelessInstanceInterceptor.invoke
      1. org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
      1 frame
    27. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    28. org.jboss.aspects
      AuthenticationInterceptor.invoke
      1. org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
      1 frame
    29. org.jboss.ejb3
      Ejb3AuthenticationInterceptor.invoke
      1. org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
      1 frame
    30. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    31. org.jboss.ejb3
      ENCPropagationInterceptor.invoke
      1. org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
      1 frame
    32. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    33. org.jboss.ejb3
      AsynchronousInterceptor.invoke
      1. org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
      1 frame
    34. org.jboss.aop
      MethodInvocation.invokeNext
      1. org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      1 frame
    35. org.jboss.ejb3
      StatelessLocalProxy.invoke
      1. org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240)
      2. org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210)
      3. org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84)
      3 frames
    36. com.sun.proxy
      $Proxy100.startProcess
      1. com.sun.proxy.$Proxy100.startProcess(Unknown Source)
      1 frame
    37. ru.runa.wfe
      ExecutionServiceDelegate.startProcess
      1. ru.runa.wfe.service.delegate.ExecutionServiceDelegate.startProcess(ExecutionServiceDelegate.java:53)
      1 frame
    38. ru.runa.wf
      StartProcessAction.execute
      1. ru.runa.wf.web.action.StartProcessAction.execute(StartProcessAction.java:71)
      1 frame
    39. struts
      RequestProcessor.process
      1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
      2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
      2 frames
    40. ru.runa.common
      UTF8RequestProcessor.process
      1. ru.runa.common.web.UTF8RequestProcessor.process(UTF8RequestProcessor.java:41)
      1 frame
    41. struts
      ActionServlet.doGet
      1. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
      2. org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
      2 frames
    42. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      2 frames
    43. 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
    44. ru.runa.common
      HTTPFilterBase.doFilter
      1. ru.runa.common.web.filter.XSSFilter.doFilter(XSSFilter.java:18)
      2. ru.runa.common.web.filter.HTTPFilterBase.doFilter(HTTPFilterBase.java:50)
      2 frames
    45. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    46. ru.runa.common
      HTTPFilterBase.doFilter
      1. ru.runa.common.web.filter.HTTPSessionFilter.doFilter(HTTPSessionFilter.java:49)
      2. ru.runa.common.web.filter.HTTPFilterBase.doFilter(HTTPFilterBase.java:50)
      2 frames
    47. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    48. ru.runa.af
      NTLMFilter.doFilter
      1. ru.runa.af.web.filter.NTLMFilter.doFilter(NTLMFilter.java:54)
      1 frame
    49. ru.runa.common
      HTTPFilterBase.doFilter
      1. ru.runa.common.web.filter.HTTPFilterBase.doFilter(HTTPFilterBase.java:50)
      1 frame
    50. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    51. net.bull.javamelody
      MonitoringFilter.doFilter
      1. net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:206)
      2. net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:179)
      2 frames
    52. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    53. JBoss Application Server Tomcat
      ReplyHeaderFilter.doFilter
      1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      1 frame
    54. Glassfish Core
      StandardContextValve.invoke
      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:230)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      4 frames
    55. JBoss Application Server Tomcat
      JaccContextValve.invoke
      1. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
      2. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
      2 frames
    56. Glassfish Core
      ErrorReportValve.invoke
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      2 frames
    57. JBoss Application Server Tomcat
      CachedConnectionValve.invoke
      1. org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
      1 frame
    58. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      2. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
      2 frames
    59. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
      3 frames
    60. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:724)
      1 frame