java.lang.RuntimeException

tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • I created a Model from scratch against a table (that was originally populated from a Kettle Trans) and when I added a filter against a numeric field, the Analyzer bombed. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.mc.yf(SourceFile:222) at com.pentaho.analyzer.content.a.lv.vm(SourceFile:206) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:168) 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:77) 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(RequestParameterAuthenticationFilter.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:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.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(SecurityContextHolderAwareRequestFilter.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:218) 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: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:232) at java.util.concurrent.FutureTask.get(FutureTask.java:91) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:157) ... 66 more Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:294) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:310) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:370) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:116) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:87) at com.pentaho.analyzer.report.ReportRequestService$mc.ty(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:152) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:928) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:858) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:832) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:583) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:679) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:173) at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:427) at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:933) at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:163) at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:368) at mondrian.olap.Util.lookupCompound(Util.java:547) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:406) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1616) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1587) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119) at mondrian.olap.Query$ScopedSchemaReader.lookupCompound(Query.java:1784) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:111) at mondrian.olap.Util.lookup(Util.java:730) at mondrian.olap.Id.accept(Id.java:107) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.SetBase.validate(SetBase.java:136) at mondrian.mdx.NamedSetExpr.accept(NamedSetExpr.java:70) at mondrian.olap.Id.accept(Id.java:115) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.Formula.accept(Formula.java:110) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156) at mondrian.olap.Query.resolve(Query.java:590) at mondrian.olap.Query.resolve(Query.java:483) at mondrian.olap.Query.(Query.java:236) at mondrian.olap.Query.(Query.java:195) at mondrian.olap.Parser.makeQuery(Parser.java:907) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1963) at mondrian.olap.Parser.do_action(Parser.java:739) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:809) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:106) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:59) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:249) ... 11 more
    via by Curtis Boyden,
  • I created a Model from scratch against a table (that was originally populated from a Kettle Trans) and when I added a filter against a numeric field, the Analyzer bombed. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.mc.yf(SourceFile:222) at com.pentaho.analyzer.content.a.lv.vm(SourceFile:206) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:168) 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:77) 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(RequestParameterAuthenticationFilter.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:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.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(SecurityContextHolderAwareRequestFilter.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:218) 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: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:232) at java.util.concurrent.FutureTask.get(FutureTask.java:91) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:157) ... 66 more Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:294) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:310) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:370) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:116) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:87) at com.pentaho.analyzer.report.ReportRequestService$mc.ty(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:152) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:928) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:858) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:832) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:583) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:679) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:173) at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:427) at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:933) at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:163) at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:368) at mondrian.olap.Util.lookupCompound(Util.java:547) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:406) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1616) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1587) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119) at mondrian.olap.Query$ScopedSchemaReader.lookupCompound(Query.java:1784) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:111) at mondrian.olap.Util.lookup(Util.java:730) at mondrian.olap.Id.accept(Id.java:107) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.SetBase.validate(SetBase.java:136) at mondrian.mdx.NamedSetExpr.accept(NamedSetExpr.java:70) at mondrian.olap.Id.accept(Id.java:115) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.Formula.accept(Formula.java:110) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156) at mondrian.olap.Query.resolve(Query.java:590) at mondrian.olap.Query.resolve(Query.java:483) at mondrian.olap.Query.(Query.java:236) at mondrian.olap.Query.(Query.java:195) at mondrian.olap.Parser.makeQuery(Parser.java:907) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1963) at mondrian.olap.Parser.do_action(Parser.java:739) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:809) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:106) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:59) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:249) ... 11 more
    via by Curtis Boyden,
  • GitHub comment 1296#273303452
    via GitHub by jmbredal
    ,
  • PO very slow on zkwebui
    via adempiere by bma99
    ,
  • Obscure error reporting
    via GitHub by omj
    ,
    • java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.mc.yf(SourceFile:222) at com.pentaho.analyzer.content.a.lv.vm(SourceFile:206) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:168) 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:77) 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(RequestParameterAuthenticationFilter.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:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.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(SecurityContextHolderAwareRequestFilter.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:218) 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: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:232) at java.util.concurrent.FutureTask.get(FutureTask.java:91) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:157) ... 66 more Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:294) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:310) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:370) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:116) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:87) at com.pentaho.analyzer.report.ReportRequestService$mc.ty(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:152) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189) at mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:928) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:858) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:832) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:583) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:679) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:173) at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:427) at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:933) at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:163) at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:368) at mondrian.olap.Util.lookupCompound(Util.java:547) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:406) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1616) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1587) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119) at mondrian.olap.Query$ScopedSchemaReader.lookupCompound(Query.java:1784) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:111) at mondrian.olap.Util.lookup(Util.java:730) at mondrian.olap.Id.accept(Id.java:107) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.SetBase.validate(SetBase.java:136) at mondrian.mdx.NamedSetExpr.accept(NamedSetExpr.java:70) at mondrian.olap.Id.accept(Id.java:115) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80) at mondrian.olap.Formula.accept(Formula.java:110) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156) at mondrian.olap.Query.resolve(Query.java:590) at mondrian.olap.Query.resolve(Query.java:483) at mondrian.olap.Query.<init>(Query.java:236) at mondrian.olap.Query.<init>(Query.java:195) at mondrian.olap.Parser.makeQuery(Parser.java:907) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1963) at mondrian.olap.Parser.do_action(Parser.java:739) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:809) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:106) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:59) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:249) ... 11 more

    Users with the same issue

    jokesterjokester
    1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    94 more bugmates