mondrian.xmla.XmlaException

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

  • JPalo, unable to create view
    via by Unknown author,
  • Sergei Mazin wrote: I got [an exception] when executed the same query above from http://localhost:8080/mondrian/xmlaTest.jsp utility <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"> <Command> <Statement> WITH SET [XL_Row_Dim_0] as 'VisualTotals(Distinct(Hierarchize({ Ascendants([Customers].[All Customers].[USA].[CA].[Beverly Hills].[Ari Tweten]), Descendants([Customers].[All Customers].[USA].[CA].[Beverly Hills].[Ari Tweten]), Ascendants([Customers].[All Customers].[Mexico]), Descendants([Customers].[All Customers].[Mexico]) })))' select NON EMPTY Hierarchize(Intersect(DrilldownMember({{DrilldownMember({{DrilldownLevel({[C ustomers].[All Customers]})}}, {[Customers].[All Customers].[USA]})}}, {[Customers].[All Customers].[USA].[CA]}), [XL_Row_Dim_0])) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS from [Sales] where [Measures].[Unit Sales] </Statement> </Command> <Properties> <PropertyList> <Catalog>FoodMart</Catalog> <DataSourceInfo>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceIn fo> <Format>Multidimensional</Format> <AxisFormat>TupleFormat</AxisFormat> </PropertyList> </Properties> </Execute> mondrian.xmla.XmlaException: Mondrian Error:XMLA Execute unparse results error at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:704) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:554) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:415) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:311) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:342) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.apache.jsp.xmla_jsp._jspService(xmla_jsp.java:68) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.ClassCastException: mondrian.olap.fun.VisualTotalsFunDef$VisualTotalMember cannot be cast to mondrian.rolap.RolapCubeMember at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:533) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:646) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:166) at mondrian.rolap.RolapMember.getPropertyValue(RolapMember.java:619) at mondrian.rolap.RolapMember.getPropertyValue(RolapMember.java:545) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.writeMember(XmlaHandler.java:2133) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axis(XmlaHandler.java:2102) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axes(XmlaHandler.java:1973) at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.unparse(XmlaHandler.java:1788) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:698) ... 30 more It got fixed by changing file mondrian/rolap/RolapCubeHierarchy.java: /* old final List<RolapCubeMember> parentRolapCubeMemberList = Util.cast(parentMembers); for (RolapCubeMember member : parentRolapCubeMemberList) { lookup.put( getUniqueNameForMemberWithoutHierarchy( member.getRolapMember()), member); rolapParents.add(member.getRolapMember()); } */ //new for (Object o : parentMembers) { if(o instanceof VisualTotalMember) { // always skip VisualTotalMembers continue; } else { RolapCubeMember member = (RolapCubeMember)o; lookup.put( getUniqueNameForMemberWithoutHierarchy( member.getRolapMember()), member); rolapParents.add(member.getRolapMember()); } }
    via by Julian Hyde,
  • 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
    via by Murtaza Ghodawala,
  • Environment: mysql Ver 14.7 Distrib 4.1.14, for Win32 (ia32) RolapAggregator.java rev 11 code: public static class AvgFromSum extends BaseAggor { public AvgFromSum(String factCountExpr) { super("AvgFromSum", factCountExpr); } public String getExpression(String operand) { StringBuffer buf = new StringBuffer(64); buf.append("sum("); buf.append(operand); buf.append(") / sum ("); buf.append(factCountExpr); buf.append(')'); return buf.toString(); } } error: 2006-07-27 14:49:59,765 ERROR [mondrian.xmla.XmlaServlet] Errors when handling XML/A message mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:993) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:201) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:119) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:402) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:312) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select from [Cheques] where [Measures].[Avg Amount] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:830) at mondrian.olap.Util.newInternal(Util.java:899) at mondrian.olap.Util.newError(Util.java:915) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:376) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:989) ... 24 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum(`agg_l_time_cheques`.`Amount_AVG`) / sum (`agg_l_time_cheques`.`FACT_COUNT`) as `m0` from `agg_l_time_cheques` as `agg_l_time_cheques`] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:830) at mondrian.olap.Util.newInternal(Util.java:899) at mondrian.rolap.agg.Segment.load(Segment.java:378) at mondrian.rolap.agg.Aggregation.load(Aggregation.java:130) at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:81) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:340) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:201) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:242) at mondrian.rolap.RolapResult.<init>(RolapResult.java:157) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:351) ... 25 more Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`agg_l_time_cheques`.`FACT_COUNT`) as `m0` from `agg_l_time_cheques` as `agg_l_' at line 1 at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:237) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:197) at mondrian.rolap.agg.Segment.load(Segment.java:265) ... 32 more summary: Mysql 4.1.14 do not eat select sum (...) from ... Mysql 4.1.14 eat select sum(...) from ...
    via by Old Triage User,
  • [Mondrian] xmla issues
    via by Unknown author,
    • mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2737) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:549) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:411) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:311) 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.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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.Http11AprProcessor.process(Http11AprProcessor.java:879) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1778) at java.lang.Thread.run(Thread.java:619)
    No Bugmate found.