mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select [Store].[Store].[Store Name].Members ON COLUMNS from [Sales] ]

Pentaho BI Platform Tracking | Matt Campbell | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    The [Store Name] dimension in the attached schema includes a single #null member. Running a query including this dimension causes a class cast exception while sorting. For example, simply running select Store.[Store Name].members on 0 from Sales causes the exception below. mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select [Store].[Store].[Store Name].Members ON COLUMNS from [Sales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:982) at mondrian.olap.Util.newInternal(Util.java:2477) at mondrian.olap.Util.newError(Util.java:2493) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:733) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:646) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:644) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.ClassCastException: mondrian.rolap.RolapUtil$RolapUtilComparable cannot be cast to java.lang.String at java.lang.String.compareTo(String.java:108) at mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1899) at mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1852) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3286) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3279) at java.util.TimSort.countRunAndMakeAscending(TimSort.java:324) at java.util.TimSort.sort(TimSort.java:189) at java.util.TimSort.sort(TimSort.java:173) at java.util.Arrays.sort(Arrays.java:659) at java.util.Collections.sort(Collections.java:217) at mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:816) at mondrian.olap.fun.FunUtil.hierarchizeTupleList(FunUtil.java:836) at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2164) at mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37) at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:859) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:696) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:652) at mondrian.rolap.RolapResult.<init>(RolapResult.java:288) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:698) ... 8 more

    Pentaho BI Platform Tracking | 3 years ago | Matt Campbell
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select [Store].[Store].[Store Name].Members ON COLUMNS from [Sales] ]
  2. 0

    The [Store Name] dimension in the attached schema includes a single #null member. Running a query including this dimension causes a class cast exception while sorting. For example, simply running select Store.[Store Name].members on 0 from Sales causes the exception below. mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select [Store].[Store].[Store Name].Members ON COLUMNS from [Sales] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:982) at mondrian.olap.Util.newInternal(Util.java:2477) at mondrian.olap.Util.newError(Util.java:2493) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:733) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:646) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:644) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.ClassCastException: mondrian.rolap.RolapUtil$RolapUtilComparable cannot be cast to java.lang.String at java.lang.String.compareTo(String.java:108) at mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1899) at mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1852) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3286) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3279) at java.util.TimSort.countRunAndMakeAscending(TimSort.java:324) at java.util.TimSort.sort(TimSort.java:189) at java.util.TimSort.sort(TimSort.java:173) at java.util.Arrays.sort(Arrays.java:659) at java.util.Collections.sort(Collections.java:217) at mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:816) at mondrian.olap.fun.FunUtil.hierarchizeTupleList(FunUtil.java:836) at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2164) at mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37) at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:859) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:696) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:652) at mondrian.rolap.RolapResult.<init>(RolapResult.java:288) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:698) ... 8 more

    Pentaho BI Platform Tracking | 3 years ago | Matt Campbell
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select [Store].[Store].[Store Name].Members ON COLUMNS from [Sales] ]
  3. 0

    After restart elasticsearch reads double as array of string

    GitHub | 3 years ago | alexey-medvedchikov
    org.elasticsearch.search.query.QueryPhaseExecutionException: [logstash-2014.04.14.10][3]: query[ConstantScore(*:*)],from[0],size[0]: Query Failed [Failed to execute main query]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    String's compareTO() query

    Coderanch | 4 years ago | Ivan Jozsef Balazs
    java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
  6. 0

    rain preprocessing fails for local project

    GitHub | 5 years ago | danhammer
    cascading.CascadingException: unable to compare Tuples, likely a CoGroup is being attempted on fields of different types or custom comparators are incorrectly set on Fields
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.ClassCastException

    mondrian.rolap.RolapUtil$RolapUtilComparable cannot be cast to java.lang.String

    at java.lang.String.compareTo()
  2. Java RT
    String.compareTo
    1. java.lang.String.compareTo(String.java:108)
    1 frame
  3. mondrian.olap.fun
    FunUtil$HierarchizeComparator.compare
    1. mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1899)
    2. mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1852)
    3. mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3286)
    4. mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3279)
    4 frames
  4. Java RT
    Collections.sort
    1. java.util.TimSort.countRunAndMakeAscending(TimSort.java:324)
    2. java.util.TimSort.sort(TimSort.java:189)
    3. java.util.TimSort.sort(TimSort.java:173)
    4. java.util.Arrays.sort(Arrays.java:659)
    5. java.util.Collections.sort(Collections.java:217)
    5 frames
  5. mondrian.olap.fun
    LevelMembersFunDef$1.evaluateList
    1. mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:816)
    2. mondrian.olap.fun.FunUtil.hierarchizeTupleList(FunUtil.java:836)
    3. mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2164)
    4. mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37)
    4 frames
  6. mondrian.calc.impl
    AbstractListCalc.evaluateIterable
    1. mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71)
    1 frame
  7. mondrian.rolap
    RolapConnection$1.call
    1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:859)
    2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:696)
    3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:652)
    4. mondrian.rolap.RolapResult.<init>(RolapResult.java:288)
    5. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:698)
    6. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
    7. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:646)
    8. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:644)
    8 frames
  8. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:166)
    3. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    5. java.lang.Thread.run(Thread.java:724)
    5 frames