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
  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 | 3 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 | 4 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

  1. mortalman7 1 times, last 4 months ago
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