java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist

Pentaho BI Platform Tracking | Curtis Boyden | 6 years ago
  1. 0

    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

    Pentaho BI Platform Tracking | 6 years ago | Curtis Boyden
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist
  2. 0

    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

    Pentaho BI Platform Tracking | 6 years ago | Curtis Boyden
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist
  3. 0

    org.postgresql.util.PSQLException: Bad value for type int :

    Google Groups | 8 years ago | ave
    org.postgresql.util.PSQLException: ERROR: ошибка синтаксиса в или рядом "and"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PostgreSQL issue: could not access file "$libdir/plpgsql": No such file or directory

    Stack Overflow | 5 years ago | rajesh
    org.postgresql.util.PSQLException: ERROR: could not access file "$libdir/plpgsql": No such file or directory
  6. 0

    cannot insert multiple commands into a prepared statement with hibernate and postgresql 8.3.23

    Stack Overflow | 1 year ago | Wallace
    org.postgresql.util.PSQLException: ERROR: cannot insert multiple commands into a prepared statement
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. org.postgresql.util.PSQLException

    ERROR: function upper(double precision) does not exist

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
    6 frames
  3. mondrian.rolap
    RolapSchemaReader.lookupMemberChildByName
    1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:152)
    2. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230)
    3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189)
    4. mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:928)
    5. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:858)
    6. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:832)
    7. mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:247)
    8. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:210)
    9. mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:583)
    10. mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:679)
    11. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176)
    12. mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:173)
    13. mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:427)
    13 frames
  4. mondrian.olap
    HierarchyBase.lookupChild
    1. mondrian.olap.Util.lookupHierarchyRootMember(Util.java:933)
    2. mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:163)
    2 frames
  5. mondrian.rolap
    RolapSchemaReader.getElementChild
    1. mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:368)
    1 frame
  6. mondrian.olap
    Util.lookupCompound
    1. mondrian.olap.Util.lookupCompound(Util.java:547)
    1 frame
  7. mondrian.rolap
    RolapSchemaReader.lookupCompound
    1. mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:406)
    1 frame
  8. mondrian.olap
    ValidatorImpl.validate
    1. mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119)
    2. mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1616)
    3. mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1587)
    4. mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:119)
    5. mondrian.olap.Query$ScopedSchemaReader.lookupCompound(Query.java:1784)
    6. mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:111)
    7. mondrian.olap.Util.lookup(Util.java:730)
    8. mondrian.olap.Id.accept(Id.java:107)
    9. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
    9 frames
  9. mondrian.olap.fun
    FunUtil.resolveFunArgs
    1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929)
    1 frame
  10. mondrian.mdx
    UnresolvedFunCall.accept
    1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103)
    1 frame
  11. mondrian.olap
    SetBase.validate
    1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
    2. mondrian.olap.SetBase.validate(SetBase.java:136)
    2 frames
  12. mondrian.mdx
    NamedSetExpr.accept
    1. mondrian.mdx.NamedSetExpr.accept(NamedSetExpr.java:70)
    1 frame
  13. mondrian.olap
    ValidatorImpl.validate
    1. mondrian.olap.Id.accept(Id.java:115)
    2. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
    2 frames
  14. mondrian.olap.fun
    FunUtil.resolveFunArgs
    1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929)
    1 frame
  15. mondrian.mdx
    UnresolvedFunCall.accept
    1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103)
    1 frame
  16. mondrian.olap
    Parser.do_action
    1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
    2. mondrian.olap.Formula.accept(Formula.java:110)
    3. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156)
    4. mondrian.olap.Query.resolve(Query.java:590)
    5. mondrian.olap.Query.resolve(Query.java:483)
    6. mondrian.olap.Query.<init>(Query.java:236)
    7. mondrian.olap.Query.<init>(Query.java:195)
    8. mondrian.olap.Parser.makeQuery(Parser.java:907)
    9. mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1963)
    10. mondrian.olap.Parser.do_action(Parser.java:739)
    10 frames
  17. Xalan Java
    lr_parser.parse
    1. java_cup.runtime.lr_parser.parse(lr_parser.java:569)
    1 frame
  18. mondrian.olap
    ConnectionBase.parseQuery
    1. mondrian.olap.Parser.parseInternal(Parser.java:809)
    2. mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:106)
    3. mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:59)
    4. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63)
    4 frames
  19. com.pentaho.analyzer
    ReportRequestService$mc.call
    1. com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:249)
    2. com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:310)
    3. com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:370)
    4. com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:116)
    5. com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:87)
    6. com.pentaho.analyzer.report.ReportRequestService$mc.ty(SourceFile:250)
    7. com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240)
    7 frames
  20. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    5. java.lang.Thread.run(Thread.java:619)
    5 frames