mondrian.xmla.XmlaException: XMLA MDX execute failed

Pentaho BI Platform Tracking | Sebastian Penhouet | 7 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    As described (<ReferenceLink> Links a Dimension to a MeasureGroup via another Dimension) and in the FoodMart example cube 'HR' (https://github.com/pentaho/mondrian/blob/4.5.0.4/demo/FoodMart.mondrian.xml) i tried to use the <ReferenceLink>. My database tables do look something like this: {panel} |*allocation_slices_monthly*| |_id_| |*resource*| |resource_code|---|_id_| |*resource*| |allocation| |primaryroleid|---|_id_| | | |title| |title| {panel} Facttable: {{allocation_slices_monthly}} Resource and Role are both in the table {{resource}} I tried to break down my schema to make it as short as possible for a minimal example: {code:xml} <Schema name="Meisterplan" metamodelVersion="4.0"> <PhysicalSchema> <Table name="allocation_slices_monthly" schema="reporting"/> <Table name="resource" schema="public" keyColumn="id"/> <Table name="resource" schema="public" keyColumn="id" alias="role"/> <Link target="resource" source="role" foreignKeyColumn="primaryroleid"/> </PhysicalSchema> <Cube name="Allocations"> <Dimensions> <Dimension name="Resource" key="Title"> <Attributes> <Attribute name="Title" table="resource" keyColumn="id" nameColumn="title"/> <Attribute name="Role Id" table="resource" keyColumn="primaryroleid"/> </Attributes> </Dimension> <Dimension name="Role" key="Title"> <Attributes> <Attribute name="Title" table="resource" keyColumn="id" nameColumn="title"/> </Attributes> </Dimension> </Dimensions> <MeasureGroups> <MeasureGroup name="AllocationMeasures" table="allocation_slices_monthly"> <Measures> <Measure name="Allocation Value" column="allocation" aggregator="sum" dataType="Numeric"/> </Measures> <DimensionLinks> <ForeignKeyLink dimension="Resource" foreignKeyColumn="resource_code"/> <ReferenceLink dimension="Role" viaDimension="Resource" viaAttribute="Role Id"/> </DimensionLinks> </MeasureGroup> </MeasureGroups> </Cube> </Schema> {code} Everything works create (for example the resource title) until i open the "All Title" of: {noformat}[Role].[Title]{noformat} Then the following error appears: {code:xml} 17:02:21,213 DEBUG XmlaServlet,qtp721748895-14:179 - Invoking validate http header callbacks 17:02:21,213 DEBUG XmlaServlet,qtp721748895-14:179 - Invoking validate http header callbacks 17:02:21,213 DEBUG XmlaServlet,qtp721748895-14:218 - Unmarshalling SOAP message 17:02:21,213 DEBUG XmlaServlet,qtp721748895-14:218 - Unmarshalling SOAP message 17:02:21,215 DEBUG XmlaServlet,qtp721748895-14:197 - XML/A request content <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"><Header/><Body><Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><Command><Statement>SELECT NON EMPTY {[Measures].[Allocation Value]} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Role].[Title].[All Title],[Role].[Title].[All Title].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS FROM [Allocations]</Statement></Command><Properties><PropertyList><Catalog>Meisterplan</Catalog><Format>Multidimensional</Format></PropertyList></Properties></Execute></Body></Envelope> 17:02:21,215 DEBUG XmlaServlet,qtp721748895-14:197 - XML/A request content <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"><Header/><Body><Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><Command><Statement>SELECT NON EMPTY {[Measures].[Allocation Value]} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Role].[Title].[All Title],[Role].[Title].[All Title].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS FROM [Allocations]</Statement></Command><Properties><PropertyList><Catalog>Meisterplan</Catalog><Format>Multidimensional</Format></PropertyList></Properties></Execute></Body></Envelope> 17:02:21,216 DEBUG XmlaServlet,qtp721748895-14:260 - Handling XML/A message header 17:02:21,216 DEBUG XmlaServlet,qtp721748895-14:260 - Handling XML/A message header 17:02:21,216 DEBUG XmlaServlet,qtp721748895-14:282 - Invoking callbacks preAction 17:02:21,216 DEBUG XmlaServlet,qtp721748895-14:282 - Invoking callbacks preAction 17:02:21,216 DEBUG XmlaServlet,qtp721748895-14:313 - Handling XML/A message body 17:02:21,216 DEBUG XmlaServlet,qtp721748895-14:313 - Handling XML/A message body 17:02:21,216 DEBUG XmlaHandler,qtp721748895-14:1642 - mdx: "SELECT NON EMPTY {[Measures].[Allocation Value]} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Role].[Title].[All Title],[Role].[Title].[All Title].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS FROM [Allocations]" 17:02:21,216 DEBUG XmlaHandler,qtp721748895-14:1642 - mdx: "SELECT NON EMPTY {[Measures].[Allocation Value]} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Role].[Title].[All Title],[Role].[Title].[All Title].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS FROM [Allocations]" 17:02:21,216 DEBUG XmlaHandler,qtp721748895-14:90 - Creating new connection for user [null] and session [<no_session>] 17:02:21,216 DEBUG XmlaHandler,qtp721748895-14:90 - Creating new connection for user [null] and session [<no_session>] 17:02:21,225 ERROR XmlaServlet,qtp721748895-14:323 - Errors when handling XML/A message mondrian.xmla.XmlaException: XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1695) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:718) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:633) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:505) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:317) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:533) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:514) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:920) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:856) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1066) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450) at java.lang.Thread.run(Thread.java:745) Caused by: org.olap4j.OlapException: mondrian gave exception while executing query at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:842) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:421) at mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1671) ... 29 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Allocation Value]} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Role].[Title].[All Title], [Role].[Title].[All Title].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS from [Allocations] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992) at mondrian.olap.Util.newInternal(Util.java:2543) at mondrian.olap.Util.newError(Util.java:2559) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:535) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:45) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:448) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:446) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: java.lang.NullPointerException at mondrian.rolap.SqlMemberSource.chooseAggStar(SqlMemberSource.java:895) at mondrian.rolap.SqlMemberSource.makeChildMemberSql(SqlMemberSource.java:588) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:1073) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:1005) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:979) at mondrian.rolap.NoCacheMemberReader.getMemberChildren(NoCacheMemberReader.java:163) at mondrian.rolap.NoCacheMemberReader.getMemberChildren(NoCacheMemberReader.java:144) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:192) at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:174) at mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:236) at mondrian.olap.fun.FunUtil.getNonEmptyMemberChildren(FunUtil.java:2143) at mondrian.olap.fun.BuiltinFunTable$22$1.evaluateList(BuiltinFunTable.java:839) at mondrian.olap.fun.SetFunDef$SetListCalc$1.evaluateVoid(SetFunDef.java:140) at mondrian.olap.fun.SetFunDef$SetListCalc.evaluateList(SetFunDef.java:193) at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:856) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:693) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:649) at mondrian.rolap.RolapResult.<init>(RolapResult.java:279) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:500) ... 7 more 17:02:21,225 ERROR XmlaServlet,qtp721748895-14:323 - Errors when handling XML/A message mondrian.xmla.XmlaException: XMLA MDX execute failed at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1695) at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:718) at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:633) at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:505) at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:317) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:533) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:514) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:920) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:856) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1066) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450) at java.lang.Thread.run(Thread.java:745) Caused by: org.olap4j.OlapException: mondrian gave exception while executing query at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:842) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:421) at mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72) at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1671) ... 29 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Allocation Value]} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Role].[Title].[All Title], [Role].[Title].[All Title].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS from [Allocations] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992) at mondrian.olap.Util.newInternal(Util.java:2543) at mondrian.olap.Util.newError(Util.java:2559) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:535) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:45) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:448) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:446) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: java.lang.NullPointerException at mondrian.rolap.SqlMemberSource.chooseAggStar(SqlMemberSource.java:895) at mondrian.rolap.SqlMemberSource.makeChildMemberSql(SqlMemberSource.java:588) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:1073) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:1005) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:979) at mondrian.rolap.NoCacheMemberReader.getMemberChildren(NoCacheMemberReader.java:163) at mondrian.rolap.NoCacheMemberReader.getMemberChildren(NoCacheMemberReader.java:144) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:192) at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:174) at mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:236) at mondrian.olap.fun.FunUtil.getNonEmptyMemberChildren(FunUtil.java:2143) at mondrian.olap.fun.BuiltinFunTable$22$1.evaluateList(BuiltinFunTable.java:839) at mondrian.olap.fun.SetFunDef$SetListCalc$1.evaluateVoid(SetFunDef.java:140) at mondrian.olap.fun.SetFunDef$SetListCalc.evaluateList(SetFunDef.java:193) at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:856) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:693) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:649) at mondrian.rolap.RolapResult.<init>(RolapResult.java:279) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:500) ... 7 more 17:02:21,232 DEBUG XmlaServlet,qtp721748895-14:625 - XML/A response content <?xml version="1.0" encoding="ISO-8859-1"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" > <SOAP-ENV:Header> </SOAP-ENV:Header> <SOAP-ENV:Body> <SOAP-ENV:Fault> <faultcode>SOAP-ENV:Server.00HSBD02</faultcode> <faultstring>XMLA MDX execute failed</faultstring> <faultactor>Mondrian</faultactor> <detail> <XA:error xmlns:XA="http://mondrian.sourceforge.net"> <code>00HSBD02</code> <desc>The Mondrian XML: java.lang.NullPointerException</desc> </XA:error> </detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> 17:02:21,232 DEBUG XmlaServlet,qtp721748895-14:625 - XML/A response content <?xml version="1.0" encoding="ISO-8859-1"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" > <SOAP-ENV:Header> </SOAP-ENV:Header> <SOAP-ENV:Body> <SOAP-ENV:Fault> <faultcode>SOAP-ENV:Server.00HSBD02</faultcode> <faultstring>XMLA MDX execute failed</faultstring> <faultactor>Mondrian</faultactor> <detail> <XA:error xmlns:XA="http://mondrian.sourceforge.net"> <code>00HSBD02</code> <desc>The Mondrian XML: java.lang.NullPointerException</desc> </XA:error> </detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> {code} I would need help to solve this as quick as possible. If i can provide any further information please let me know.

    Pentaho BI Platform Tracking | 7 months ago | Sebastian Penhouet
    mondrian.xmla.XmlaException: XMLA MDX execute failed
  2. 0

    When browsing a dimension with <Join> that is bound at different level in two cubes, as well as for some queries the following NPE is thrown. The attached patch seems to fix it. ERROR [com.tonbeller.wcf.component.RendererTag] - <trouble rendering navi01> java.lang.NullPointerException at mondrian.rolap.RolapCubeLevel.getBaseStarKeyColumn(RolapCubeLevel.java:159) at mondrian.rolap.SqlConstraintUtils.generateSingleValueInExpr(SqlConstraintUtils.java:911) at mondrian.rolap.SqlConstraintUtils.addMemberConstraint(SqlConstraintUtils.java:294) at mondrian.rolap.SqlConstraintUtils.addMemberConstraint(SqlConstraintUtils.java:218) at mondrian.rolap.DefaultMemberChildrenConstraint.addMemberConstraint(DefaultMemberChildrenConstraint.java:42) at mondrian.rolap.SqlMemberSource.makeChildMemberSql(SqlMemberSource.java:506) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:719) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:653) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:628) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:237) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:201) at mondrian.rolap.RolapCubeHierarchy$RolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:472) at mondrian.rolap.RolapCubeHierarchy$RolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:568) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:169) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:155) at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:146) at mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:139) at mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:60) at com.tonbeller.jpivot.mondrian.MondrianMemberTree.internalGetChildren(MondrianMemberTree.java:209)

    Pentaho BI Platform Tracking | 8 years ago | calinm
    java.lang.NullPointerException

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at mondrian.rolap.SqlMemberSource.chooseAggStar()
    2. mondrian.rolap
      RolapSchemaReader.getMemberChildren
      1. mondrian.rolap.SqlMemberSource.chooseAggStar(SqlMemberSource.java:895)
      2. mondrian.rolap.SqlMemberSource.makeChildMemberSql(SqlMemberSource.java:588)
      3. mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:1073)
      4. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:1005)
      5. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:979)
      6. mondrian.rolap.NoCacheMemberReader.getMemberChildren(NoCacheMemberReader.java:163)
      7. mondrian.rolap.NoCacheMemberReader.getMemberChildren(NoCacheMemberReader.java:144)
      8. mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:192)
      9. mondrian.rolap.RolapSchemaReader.getMemberChildren(RolapSchemaReader.java:174)
      9 frames
    3. mondrian.olap
      DelegatingSchemaReader.getMemberChildren
      1. mondrian.olap.DelegatingSchemaReader.getMemberChildren(DelegatingSchemaReader.java:236)
      1 frame
    4. mondrian.olap.fun
      SetFunDef$SetListCalc.evaluateList
      1. mondrian.olap.fun.FunUtil.getNonEmptyMemberChildren(FunUtil.java:2143)
      2. mondrian.olap.fun.BuiltinFunTable$22$1.evaluateList(BuiltinFunTable.java:839)
      3. mondrian.olap.fun.SetFunDef$SetListCalc$1.evaluateVoid(SetFunDef.java:140)
      4. mondrian.olap.fun.SetFunDef$SetListCalc.evaluateList(SetFunDef.java:193)
      4 frames
    5. mondrian.calc.impl
      AbstractListCalc.evaluateIterable
      1. mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71)
      1 frame
    6. mondrian.rolap
      RolapConnection$1.call
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:856)
      2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:693)
      3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:649)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:279)
      5. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:500)
      6. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:45)
      7. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:448)
      8. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:446)
      8 frames
    7. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask.run(FutureTask.java:266)
      2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      4. java.lang.Thread.run(Thread.java:745)
      4 frames