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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

Solutions on the web

via Pentaho BI Platform Tracking by gunter rombauts, 1 year ago
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] ]
via Pentaho BI Platform Tracking by gunter rombauts, 1 year ago
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] ]
via Pentaho BI Platform Tracking by Gerald E Butler, 1 year ago
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [Territories of Interest] as 'Extract(NonEmptyCrossJoin([Markets].[Territory].Members, [Product].[Line].Members), [Markets])' select ({[Time].[2005]} * {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, NON EMPTY [Territories of Interest] ON ROWS from [SteelWheelsSales] ]
via Pentaho BI Platform Tracking by Gerald E Butler, 1 year ago
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with set [Territories of Interest] as 'Extract(NonEmptyCrossJoin([Markets].[Territory].Members, [Product].[Line].Members), [Markets])' select ({[Time].[2005]} * {[Measures].[Quantity], [Measures].[Sales]}) ON COLUMNS, NON EMPTY [Territories of Interest] ON ROWS from [SteelWheelsSales] ]
via Coderanch by matias casal, 11 months ago
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[SUM of exped.ID]} ON COLUMNS, NON EMPTY Crossjoin(Hierarchize(Crossjoin({[exped.ID.exped.ID].[All exped.id]}, Union
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.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 mondrian.rolap.SqlMemberSource.makeMember(SqlMemberSource.java:1022)
at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:961)
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.(RolapResult.java:273)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:604)
at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279)
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 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 javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
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.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
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.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
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.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 java.lang.Thread.run(Thread.java:619)

Users with the same issue

3 times, 14 hours ago
16 times, 5 days ago
Once, 1 week ago
Once, 1 week ago
116 times, 1 week ago
164 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.