java.lang.Comparable

Pentaho BI Platform Tracking | Golda David | 4 years ago
  1. 0

    Used the Insta view RDBMS template and a postgres SQL table, getting a " .monetdb.jdbc.MonetClob cannot be cast to java.lang.Comparable" when adding the field to make analyzer report. In insta view use the RDBMS template Use your local postgres Sql data base and the attached table. CREATE TABLE public."Fruits" ( "Fruit_name" text, "Quanity_in_Stock" numeric, "Price" numeric ) Run the template it runs successfully and you are in the analyzer visualization. Drag "Fruitname" from the available fields to the workspace. you get the following error in the workspace and in the console. INFO 25-10 16:24:05,447 - C:\PROGRA~1\pentaho\design-tools\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\sys tem\instaview\templates\Samples\RDBMS.ktr : RDBMS - Dispatching started for transformation [C:\PROGRA~1\pentaho\design-tools\data- integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Samples\RDBMS.ktr : RDBMS] INFO 25-10 16:24:05,514 - Input - Finished reading query, closing connection. INFO 25-10 16:24:05,515 - Input - Finished processing (I=4, O=0, R=0, W=4, U=0, E=0) INFO 25-10 16:24:05,517 - dummy - Finished processing (I=0, O=0, R=4, W=4, U=0, E=0) INFO 25-10 16:24:27,055 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:27,190 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:27,226 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:28,358 - Output - Exit Value of psql: 0 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121025042427029 rowCount=-1 INFO 25-10 16:24:29,458 - Output - Exit Value of psql: 0 INFO 25-10 16:24:29,843 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:30,798 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:30,836 - Input - Finished reading query, closing connection. INFO 25-10 16:24:30,838 - Input - Finished processing (I=4, O=0, R=0, W=4, U=0, E=0) INFO 25-10 16:24:30,841 - Do Not Edit - Finished processing (I=0, O=0, R=4, W=4, U=0, E=0) INFO 25-10 16:24:31,915 - Output - Exit Value of psql: 0 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121025042427029 rowCount=-1 INFO 25-10 16:24:32,998 - Output - Exit Value of psql: 0 INFO 25-10 16:24:32,998 - Output - Executing command: C:\PROGRA~1\pentaho\monetdb\mclient.bat /STARTED-FROM-MENU -lsql "--encodin g=UTF-8" "--host=localhost" "--port=50006" "--database=pentaho-instaview" INFO 25-10 16:24:34,477 - Output - OUTPUT 4 affected rows INFO 25-10 16:24:34,486 - Output - Exit Value of psql: 0 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121025042427029 rowCount=4 INFO 25-10 16:24:34,491 - Output - Exit Value of psql: 0 INFO 25-10 16:24:34,492 - Output - Finished processing (I=0, O=4, R=4, W=4, U=0, E=0) ERROR 25-10 16:24:34,738 - Error Start: Pentaho Pentaho Platform Engine Core 4.8.0-GA.51092 ERROR 25-10 16:24:34,739 - fda80cf5-1ee1-11e2-8454-c786e9f40921:ANALYZER:: Exception occurred in Pentaho Analyzer content generato r. Please check the server log files. org.mortbay.jetty.EofException at org.mortbay.jetty.HttpGenerator.flush(HttpGenerator.java:787) at org.mortbay.jetty.AbstractGenerator$Output.flush(AbstractGenerator.java:568) at org.mortbay.jetty.HttpConnection$Output.flush(HttpConnection.java:997) at org.mortbay.jetty.AbstractGenerator$Output.write(AbstractGenerator.java:648) at org.mortbay.jetty.AbstractGenerator$Output.write(AbstractGenerator.java:589) at com.pentaho.analyzer.content.controller.zj.writeString(SourceFile:100) at com.pentaho.analyzer.content.controller.yf.px(SourceFile:259) at com.pentaho.analyzer.content.controller.yf.yb(SourceFile:105) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:150) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 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.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) 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(RequestParameterAuthenticationFilt er.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) 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 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:13 4) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilt er.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.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareReq uestFilter.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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:915) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at org.mortbay.io.ByteArrayBuffer.writeTo(ByteArrayBuffer.java:368) at org.mortbay.io.bio.StreamEndPoint.flush(StreamEndPoint.java:122) at org.mortbay.io.bio.StreamEndPoint.flush(StreamEndPoint.java:142) at org.mortbay.jetty.HttpGenerator.flush(HttpGenerator.java:710) ... 70 more ERROR 25-10 16:24:34,770 - Error end: INFO 25-10 16:24:40,497 - // Request ID: 01215539-1ee2-11e2-8454-c786e9f40921 - RUN_REPORT With Set [*NATIVE_CJ_SET] as '[*BASE_MEMBERS_Fruitname]' Set [*SORTED_ROW_AXIS] as 'Order([*CJ_ROW_AXIS],[Fruitname].CurrentMember.OrderKey,BASC)' Set [*BASE_MEMBERS_Fruitname] as '[Fruitname].[Fruitname].Members' Set [*BASE_MEMBERS_Measures] as '{[Measures].[*ZERO]}' Set [*CJ_ROW_AXIS] as 'Generate([*NATIVE_CJ_SET], {([Fruitname].currentMember)})' Set [*CJ_COL_AXIS] as '[*NATIVE_CJ_SET]' Member [Measures].[*ZERO] as '0', SOLVE_ORDER=0 Select [*BASE_MEMBERS_Measures] on columns, [*SORTED_ROW_AXIS] on rows From [Untitled 3] ERROR 25-10 16:24:40,554 - Ticket Number: 1351196680554 ERROR 25-10 16:24:40,554 - Exception in AJAX handler. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.ClassCastException: nl. cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Comparable at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:216) at com.pentaho.analyzer.content.controller.mc.yf(SourceFile:282) at com.pentaho.analyzer.content.controller.lv.lf(SourceFile:187) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:176) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 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.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) 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(RequestParameterAuthenticationFilt er.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) 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 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:13 4) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilt er.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.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareReq uestFilter.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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.ClassCastException: nl.cwi.monetdb.jdbc. MonetClob cannot be cast to java.lang.Comparable at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:174) ... 66 more Caused by: java.lang.RuntimeException: java.lang.ClassCastException: nl.cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Com parable at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:299) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:298) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:358) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:122) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:93) at com.pentaho.analyzer.report.ReportRequestService$mc.ex(SourceFile:268) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:258) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassCastException: nl.cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Comparable at mondrian.olap.Util.compareKey(Util.java:526) at mondrian.rolap.RolapMemberBase.compareTo(RolapMemberBase.java:546) at mondrian.rolap.RolapCubeMember.compareTo(RolapCubeMember.java:97) at mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1952) at mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1896) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3129) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3122) at java.util.Arrays.mergeSort(Unknown Source) at java.util.Arrays.sort(Unknown Source) at java.util.Collections.sort(Unknown Source) at mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:848) at mondrian.olap.fun.FunUtil.hierarchizeTupleList(FunUtil.java:868) at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2221) at mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:109) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:201) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:817) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:642) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:598) at mondrian.rolap.RolapResult.<init>(RolapResult.java:286) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630) ... 5 more

    Pentaho BI Platform Tracking | 4 years ago | Golda David
    java.lang.Comparable
  2. 0

    Used the Insta view RDBMS template and a postgres SQL table, getting a " .monetdb.jdbc.MonetClob cannot be cast to java.lang.Comparable" when adding the field to make analyzer report. In insta view use the RDBMS template Use your local postgres Sql data base and the attached table. CREATE TABLE public."Fruits" ( "Fruit_name" text, "Quanity_in_Stock" numeric, "Price" numeric ) Run the template it runs successfully and you are in the analyzer visualization. Drag "Fruitname" from the available fields to the workspace. you get the following error in the workspace and in the console. INFO 25-10 16:24:05,447 - C:\PROGRA~1\pentaho\design-tools\data-integration\plugins\spoon\agile-bi\platform\pentaho-solutions\sys tem\instaview\templates\Samples\RDBMS.ktr : RDBMS - Dispatching started for transformation [C:\PROGRA~1\pentaho\design-tools\data- integration\plugins\spoon\agile-bi\platform\pentaho-solutions\system\instaview\templates\Samples\RDBMS.ktr : RDBMS] INFO 25-10 16:24:05,514 - Input - Finished reading query, closing connection. INFO 25-10 16:24:05,515 - Input - Finished processing (I=4, O=0, R=0, W=4, U=0, E=0) INFO 25-10 16:24:05,517 - dummy - Finished processing (I=0, O=0, R=4, W=4, U=0, E=0) INFO 25-10 16:24:27,055 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:27,190 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:27,226 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:28,358 - Output - Exit Value of psql: 0 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121025042427029 rowCount=-1 INFO 25-10 16:24:29,458 - Output - Exit Value of psql: 0 INFO 25-10 16:24:29,843 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:30,798 - Untitled 3 - Dispatching started for transformation [Untitled 3] INFO 25-10 16:24:30,836 - Input - Finished reading query, closing connection. INFO 25-10 16:24:30,838 - Input - Finished processing (I=4, O=0, R=0, W=4, U=0, E=0) INFO 25-10 16:24:30,841 - Do Not Edit - Finished processing (I=0, O=0, R=4, W=4, U=0, E=0) INFO 25-10 16:24:31,915 - Output - Exit Value of psql: 0 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121025042427029 rowCount=-1 INFO 25-10 16:24:32,998 - Output - Exit Value of psql: 0 INFO 25-10 16:24:32,998 - Output - Executing command: C:\PROGRA~1\pentaho\monetdb\mclient.bat /STARTED-FROM-MENU -lsql "--encodin g=UTF-8" "--host=localhost" "--port=50006" "--database=pentaho-instaview" INFO 25-10 16:24:34,477 - Output - OUTPUT 4 affected rows INFO 25-10 16:24:34,486 - Output - Exit Value of psql: 0 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121025042427029 rowCount=4 INFO 25-10 16:24:34,491 - Output - Exit Value of psql: 0 INFO 25-10 16:24:34,492 - Output - Finished processing (I=0, O=4, R=4, W=4, U=0, E=0) ERROR 25-10 16:24:34,738 - Error Start: Pentaho Pentaho Platform Engine Core 4.8.0-GA.51092 ERROR 25-10 16:24:34,739 - fda80cf5-1ee1-11e2-8454-c786e9f40921:ANALYZER:: Exception occurred in Pentaho Analyzer content generato r. Please check the server log files. org.mortbay.jetty.EofException at org.mortbay.jetty.HttpGenerator.flush(HttpGenerator.java:787) at org.mortbay.jetty.AbstractGenerator$Output.flush(AbstractGenerator.java:568) at org.mortbay.jetty.HttpConnection$Output.flush(HttpConnection.java:997) at org.mortbay.jetty.AbstractGenerator$Output.write(AbstractGenerator.java:648) at org.mortbay.jetty.AbstractGenerator$Output.write(AbstractGenerator.java:589) at com.pentaho.analyzer.content.controller.zj.writeString(SourceFile:100) at com.pentaho.analyzer.content.controller.yf.px(SourceFile:259) at com.pentaho.analyzer.content.controller.yf.yb(SourceFile:105) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:150) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 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.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) 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(RequestParameterAuthenticationFilt er.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) 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 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:13 4) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilt er.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.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareReq uestFilter.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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:915) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at org.mortbay.io.ByteArrayBuffer.writeTo(ByteArrayBuffer.java:368) at org.mortbay.io.bio.StreamEndPoint.flush(StreamEndPoint.java:122) at org.mortbay.io.bio.StreamEndPoint.flush(StreamEndPoint.java:142) at org.mortbay.jetty.HttpGenerator.flush(HttpGenerator.java:710) ... 70 more ERROR 25-10 16:24:34,770 - Error end: INFO 25-10 16:24:40,497 - // Request ID: 01215539-1ee2-11e2-8454-c786e9f40921 - RUN_REPORT With Set [*NATIVE_CJ_SET] as '[*BASE_MEMBERS_Fruitname]' Set [*SORTED_ROW_AXIS] as 'Order([*CJ_ROW_AXIS],[Fruitname].CurrentMember.OrderKey,BASC)' Set [*BASE_MEMBERS_Fruitname] as '[Fruitname].[Fruitname].Members' Set [*BASE_MEMBERS_Measures] as '{[Measures].[*ZERO]}' Set [*CJ_ROW_AXIS] as 'Generate([*NATIVE_CJ_SET], {([Fruitname].currentMember)})' Set [*CJ_COL_AXIS] as '[*NATIVE_CJ_SET]' Member [Measures].[*ZERO] as '0', SOLVE_ORDER=0 Select [*BASE_MEMBERS_Measures] on columns, [*SORTED_ROW_AXIS] on rows From [Untitled 3] ERROR 25-10 16:24:40,554 - Ticket Number: 1351196680554 ERROR 25-10 16:24:40,554 - Exception in AJAX handler. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.ClassCastException: nl. cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Comparable at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:216) at com.pentaho.analyzer.content.controller.mc.yf(SourceFile:282) at com.pentaho.analyzer.content.controller.lv.lf(SourceFile:187) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:176) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 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.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) 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(RequestParameterAuthenticationFilt er.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) 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 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:13 4) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilt er.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.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareReq uestFilter.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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.ClassCastException: nl.cwi.monetdb.jdbc. MonetClob cannot be cast to java.lang.Comparable at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:174) ... 66 more Caused by: java.lang.RuntimeException: java.lang.ClassCastException: nl.cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Com parable at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:299) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:298) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:358) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:122) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:93) at com.pentaho.analyzer.report.ReportRequestService$mc.ex(SourceFile:268) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:258) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassCastException: nl.cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Comparable at mondrian.olap.Util.compareKey(Util.java:526) at mondrian.rolap.RolapMemberBase.compareTo(RolapMemberBase.java:546) at mondrian.rolap.RolapCubeMember.compareTo(RolapCubeMember.java:97) at mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1952) at mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1896) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3129) at mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3122) at java.util.Arrays.mergeSort(Unknown Source) at java.util.Arrays.sort(Unknown Source) at java.util.Collections.sort(Unknown Source) at mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:848) at mondrian.olap.fun.FunUtil.hierarchizeTupleList(FunUtil.java:868) at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2221) at mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:109) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:201) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:817) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:642) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:598) at mondrian.rolap.RolapResult.<init>(RolapResult.java:286) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630) ... 5 more

    Pentaho BI Platform Tracking | 4 years ago | Golda David
    java.lang.Comparable
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Find out the cheapest item

    Stack Overflow | 1 month ago | Ivan C
    java.lang.ClassCastException: com.java.school.B cannot be cast to java.lang.Comparable
  5. 0

    GitHub comment 1147#257371921

    GitHub | 1 month ago | dizzzz
    java.lang.ClassCastException: org.exist.yajsw.Main cannot be cast to java.lang.Comparable

    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

      nl.cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Comparable

      at mondrian.olap.Util.compareKey()
    2. mondrian.olap
      Util.compareKey
      1. mondrian.olap.Util.compareKey(Util.java:526)
      1 frame
    3. mondrian.rolap
      RolapCubeMember.compareTo
      1. mondrian.rolap.RolapMemberBase.compareTo(RolapMemberBase.java:546)
      2. mondrian.rolap.RolapCubeMember.compareTo(RolapCubeMember.java:97)
      2 frames
    4. mondrian.olap.fun
      FunUtil$HierarchizeComparator.compare
      1. mondrian.olap.fun.FunUtil.compareSiblingMembers(FunUtil.java:1952)
      2. mondrian.olap.fun.FunUtil.compareHierarchically(FunUtil.java:1896)
      3. mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3129)
      4. mondrian.olap.fun.FunUtil$HierarchizeComparator.compare(FunUtil.java:3122)
      4 frames
    5. Java RT
      Collections.sort
      1. java.util.Arrays.mergeSort(Unknown Source)
      2. java.util.Arrays.sort(Unknown Source)
      3. java.util.Collections.sort(Unknown Source)
      3 frames
    6. mondrian.olap.fun
      LevelMembersFunDef$1.evaluateList
      1. mondrian.olap.fun.FunUtil.hierarchizeMemberList(FunUtil.java:848)
      2. mondrian.olap.fun.FunUtil.hierarchizeTupleList(FunUtil.java:868)
      3. mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2221)
      4. mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37)
      4 frames
    7. mondrian.calc.impl
      AbstractListCalc.evaluate
      1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
      1 frame
    8. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61)
      3 frames
    9. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    10. mondrian.calc.impl
      AbstractIterCalc.evaluate
      1. mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
      1 frame
    11. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61)
      3 frames
    12. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    13. mondrian.olap.fun
      GenerateFunDef$GenerateListCalcImpl.evaluateList
      1. mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:109)
      1 frame
    14. mondrian.calc.impl
      AbstractListCalc.evaluate
      1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
      1 frame
    15. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61)
      3 frames
    16. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    17. mondrian.olap.fun
      OrderFunDef$CalcImpl.evaluateList
      1. mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:201)
      1 frame
    18. mondrian.calc.impl
      AbstractListCalc.evaluate
      1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
      1 frame
    19. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61)
      3 frames
    20. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    21. mondrian.rolap
      RolapConnection$1.call
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:817)
      2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:642)
      3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:598)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:286)
      5. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680)
      6. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
      7. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631)
      8. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630)
      8 frames
    22. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      2. java.util.concurrent.FutureTask.run(Unknown Source)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      5. java.lang.Thread.run(Unknown Source)
      5 frames