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

    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.Comparable

      No message provided

      at com.pentaho.analyzer.report.ReportRequestService.get()
    2. com.pentaho.analyzer
      AnalyzerContentGenerator.createContent
      1. com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:216)
      2. com.pentaho.analyzer.content.controller.mc.yf(SourceFile:282)
      3. com.pentaho.analyzer.content.controller.lv.lf(SourceFile:187)
      4. com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:176)
      4 frames
    3. org.pentaho.platform
      GenericServlet.doPost
      1. org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
      2. org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80)
      2 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    5. Jetty Server
      ServletHandler$CachedChain.doFilter
      1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      2. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
      2 frames
    6. org.pentaho.platform
      PentahoWebContextFilter.doFilter
      1. org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142)
      1 frame
    7. Jetty Server
      ServletHandler$CachedChain.doFilter
      1. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      1 frame
    8. org.pentaho.platform
      PentahoRequestContextFilter.doFilter
      1. org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
      1 frame
    9. Jetty Server
      ServletHandler$CachedChain.doFilter
      1. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      1 frame
    10. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
      1 frame
    11. org.springframework.security
      FilterSecurityInterceptor.doFilter
      1. org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
      2. org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
      2 frames
    12. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    13. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    14. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    15. org.pentaho.platform
      SecurityStartupFilter.doFilter
      1. org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108)
      1 frame
    16. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    17. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    18. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    19. org.pentaho.platform
      RequestParameterAuthenticationFilter.doFilter
      1. org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
      1 frame
    20. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    21. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    22. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    23. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    24. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    25. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    26. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    27. org.pentaho.platform
      HttpSessionReuseDetectionFilter.doFilter
      1. org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
      1 frame
    28. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    29. Spring Security - Portlet support
      HttpSessionContextIntegrationFilter.doFilterHttp
      1. org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
      1 frame
    30. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      1 frame
    31. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    32. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    33. spring-security-core
      FilterToBeanProxy.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      2. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
      3. org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
      3 frames
    34. Jetty Server
      ServletHandler$CachedChain.doFilter
      1. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      1 frame
    35. org.pentaho.platform
      SystemStatusFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
      1 frame
    36. Jetty Server
      ServletHandler$CachedChain.doFilter
      1. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      1 frame
    37. org.pentaho.platform
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
      1 frame
    38. Jetty Server
      SocketConnector$Connection.run
      1. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
      3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
      6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
      7. org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
      8. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      9. org.mortbay.jetty.Server.handle(Server.java:322)
      10. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536)
      11. org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930)
      12. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
      13. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
      14. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405)
      15. org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
      15 frames
    39. Jetty Util
      QueuedThreadPool$PoolThread.run
      1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      1 frame