org.olap4j.OlapException: mondrian gave exception while executing query

Pentaho BI Platform Tracking | Murtaza Ghodawala | 2 years ago
  1. 0

    We are trying to use Cloudera 5.x IMPALA with Mondrian using Pentaho EE 5.x. There are two problems we are facing, 1. Cloudera IMPALA drivers in Pentaho is not able to connect to specific database in IMPALA. It is always connecting to "default" database. To overcome this, we have created JNDI using our Cloudera Impala JDBCv3 drivers. Now we are able to see other databases in IMPALA and can create star schema. 2. We can create Analysis report in Pentaho User Console using the IMPALA datasource created above and all the dimensions and measures (Star Schema) is showing perfectly fine. Data is coming appropriately in Pentaho Analysis report. 3. When we try to access this Datasource as Catalogue using XML/A in Excel file, it gives error on choosing any field from pivot table. On checking Pentaho logs, there are errors in MDX queries of Mondrian. Below are some of the errors from log files. Please suggest us how can we access Mondrian cubes in Excel using XML/A. 2015/04/30 15:09:51 - ImpalaDefault - Creating database connection pool for 'ImpalaDefault'... 2015/04/30 15:09:51 - ImpalaDefault - Successfully created database connection pool for 'ImpalaDefault' 15:12:33,048 ERROR [XmlaServlet] Errors when handling XML/A message mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1734) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:759) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:674) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318) at javax.servlet.http.HttpServlet.service(HttpServlet.java:643) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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.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:191) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115) 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 com.pentaho.platform.security.a.doFilterHttp(SourceFile:62) 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:133) 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.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) Caused by: org.olap4j.OlapException: mondrian gave exception while executing query at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423) at mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1711) ... 74 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY Hierarchize(AddCalculatedMembers({DrilldownLevel({[CUSTOMERS.CUSTOMERNAME].[All CUSTOMERS.CUSTOMERNAMEs]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS from [ImpalaDS] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.Util.newInternal(Util.java:2404) at mondrian.olap.Util.newError(Util.java:2420) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: mondrian.olap.MondrianException: Mondrian Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:240) at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:51) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:166) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:140) ... 4 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:643) at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195) ... 7 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum(`ORDERFACT`.`ORDERLINENUMBER`) as `m0` from `bigdata`.`ORDERFACT` `ORDERFACT`] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.Util.newInternal(Util.java:2404) at mondrian.olap.Util.newError(Util.java:2420) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:352) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625) ... 8 more Caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 at java.util.ArrayList.rangeCheck(Unknown Source) at java.util.ArrayList.get(Unknown Source) at mondrian.rolap.SqlStatement.guessTypes(SqlStatement.java:419) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:241) ... 10 more

    Pentaho BI Platform Tracking | 2 years ago | Murtaza Ghodawala
    org.olap4j.OlapException: mondrian gave exception while executing query
  2. 0

    We are trying to use Cloudera 5.x IMPALA with Mondrian using Pentaho EE 5.x. There are two problems we are facing, 1. Cloudera IMPALA drivers in Pentaho is not able to connect to specific database in IMPALA. It is always connecting to "default" database. To overcome this, we have created JNDI using our Cloudera Impala JDBCv3 drivers. Now we are able to see other databases in IMPALA and can create star schema. 2. We can create Analysis report in Pentaho User Console using the IMPALA datasource created above and all the dimensions and measures (Star Schema) is showing perfectly fine. Data is coming appropriately in Pentaho Analysis report. 3. When we try to access this Datasource as Catalogue using XML/A in Excel file, it gives error on choosing any field from pivot table. On checking Pentaho logs, there are errors in MDX queries of Mondrian. Below are some of the errors from log files. Please suggest us how can we access Mondrian cubes in Excel using XML/A. 2015/04/30 15:09:51 - ImpalaDefault - Creating database connection pool for 'ImpalaDefault'... 2015/04/30 15:09:51 - ImpalaDefault - Successfully created database connection pool for 'ImpalaDefault' 15:12:33,048 ERROR [XmlaServlet] Errors when handling XML/A message mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1734) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:759) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:674) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318) at javax.servlet.http.HttpServlet.service(HttpServlet.java:643) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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.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:191) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115) 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 com.pentaho.platform.security.a.doFilterHttp(SourceFile:62) 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:133) 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.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) Caused by: org.olap4j.OlapException: mondrian gave exception while executing query at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423) at mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1711) ... 74 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY Hierarchize(AddCalculatedMembers({DrilldownLevel({[CUSTOMERS.CUSTOMERNAME].[All CUSTOMERS.CUSTOMERNAMEs]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS from [ImpalaDS] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.Util.newInternal(Util.java:2404) at mondrian.olap.Util.newError(Util.java:2420) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: mondrian.olap.MondrianException: Mondrian Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:240) at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:51) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:166) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:140) ... 4 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:643) at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195) ... 7 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum(`ORDERFACT`.`ORDERLINENUMBER`) as `m0` from `bigdata`.`ORDERFACT` `ORDERFACT`] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.Util.newInternal(Util.java:2404) at mondrian.olap.Util.newError(Util.java:2420) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:352) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625) ... 8 more Caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 at java.util.ArrayList.rangeCheck(Unknown Source) at java.util.ArrayList.get(Unknown Source) at mondrian.rolap.SqlStatement.guessTypes(SqlStatement.java:419) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:241) ... 10 more

    Pentaho BI Platform Tracking | 2 years ago | Murtaza Ghodawala
    org.olap4j.OlapException: mondrian gave exception while executing query
  3. 0

    Crash when opening HQM book

    GitHub | 2 years ago | Painstouch
    net.minecraft.util.ReportedException: Rendering screen
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PacketPlayInClientCommand Problems

    GitHub | 2 years ago | aaomidi
    java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
  6. 0

    javascript pop() method in java

    Stack Overflow | 3 years ago | user2295443
    java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

  1. bmacedo 4 times, last 3 days ago
  2. mhicauber 1 times, last 4 days ago
  3. filpgame 2 times, last 7 days ago
  4. tvrmsmith 1 times, last 1 week ago
  5. Indri Yunita 12 times, last 1 week ago
67 more registered users
28 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.lang.IndexOutOfBoundsException

    Index: 1, Size: 1

    at java.util.ArrayList.rangeCheck()
  2. Java RT
    ArrayList.get
    1. java.util.ArrayList.rangeCheck(Unknown Source)
    2. java.util.ArrayList.get(Unknown Source)
    2 frames
  3. mondrian.rolap
    RolapUtil.executeQuery
    1. mondrian.rolap.SqlStatement.guessTypes(SqlStatement.java:419)
    2. mondrian.rolap.SqlStatement.execute(SqlStatement.java:241)
    3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350)
    3 frames
  4. mondrian.rolap.agg
    SegmentLoader$SegmentLoadCommand.call
    1. mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625)
    2. mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195)
    3. mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:51)
    4. mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:166)
    5. mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:140)
    5 frames
  5. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.FutureTask.run(Unknown Source)
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    3 frames
  6. mondrian.xmla
    XmlaHandler.executeQuery
    1. mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1711)
    1 frame