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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Pentaho BI Platform Tracking by Curtis Boyden, 1 year ago
java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist
via Pentaho BI Platform Tracking by Curtis Boyden, 1 year ago
java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function upper(double precision) does not exist
via Pentaho BI Platform Tracking by Alena Karneichyk, 1 year ago
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request.
via GitHub by borderlayout
, 1 year ago
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: No result found for this query
via Pentaho BI Platform Tracking by Abhimanyu Varadaraju, 6 months ago
java.util.concurrent.ExecutionException: java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: AggStar AggStar:agg_c_10_sales_fact_1997 bk=0x0000000000000000000000000000010111000000000000000000010110000000
via Pentaho BI Platform Tracking by Ronye Sarreira, 7 months ago
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request.
java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: 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 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)
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)

Users with the same issue

Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 times, 1 year ago
Once, 4 days ago
104 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.