java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist

Pentaho BI Platform Tracking | Rob Fellows | 6 years ago
  1. 0

    There appears to be a case sensitive issue between postgres and analyzer. the mondrian.xml (attached) defines the Table name as "ANALYZERDS", the actual table name in the postgresql db is "analyzerds". when the table is quoted it is case sensitive in postgresql. this causes an error. opening up pgadmin and querying: select * from "ANALYZERDS" -- causes an error. select * from "analyzerds" -- works select * from ANALYZERDS -- works REPRO PATH: 1 Create a new datasource from a csv file (attached is the one i used)... I also named the datasource "analyzerDS" -- as you can see, it is mixed case 2 After completing the data source, create a new Analyzer Report with it as it's data source 3 Drag a measure/dimension onto the report area get the following error... java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.c.a(SourceFile:222) at com.pentaho.analyzer.content.a.o.dC(SourceFile:201) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:171) at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) 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:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:103) 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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" 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) ... 72 more Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" 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$c.bk(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$c.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) ... 1 more Caused by: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) 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.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:381) at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:110) at mondrian.rolap.agg.Aggregation.load(Aggregation.java:172) at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:96) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:495) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:430) at mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:206) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:187) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:803) at mondrian.rolap.RolapResult.(RolapResult.java:417) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:593) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:285) ... 11 more

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist
  2. 0

    There appears to be a case sensitive issue between postgres and analyzer. the mondrian.xml (attached) defines the Table name as "ANALYZERDS", the actual table name in the postgresql db is "analyzerds". when the table is quoted it is case sensitive in postgresql. this causes an error. opening up pgadmin and querying: select * from "ANALYZERDS" -- causes an error. select * from "analyzerds" -- works select * from ANALYZERDS -- works REPRO PATH: 1 Create a new datasource from a csv file (attached is the one i used)... I also named the datasource "analyzerDS" -- as you can see, it is mixed case 2 After completing the data source, create a new Analyzer Report with it as it's data source 3 Drag a measure/dimension onto the report area get the following error... java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.c.a(SourceFile:222) at com.pentaho.analyzer.content.a.o.dC(SourceFile:201) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:171) at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) 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:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:103) 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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" 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) ... 72 more Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" 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$c.bk(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$c.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) ... 1 more Caused by: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) 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.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:381) at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:110) at mondrian.rolap.agg.Aggregation.load(Aggregation.java:172) at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:96) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:495) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:430) at mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:206) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:187) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:803) at mondrian.rolap.RolapResult.(RolapResult.java:417) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:593) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:285) ... 11 more

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist
  3. 0

    problem with initial.load.delete.first

    symmetricds | 7 years ago | jdempsky
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select set_config('symmetric.triggers_disabled', '', false)]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Adding Another Client to the Sample Scenario

    symmetricds | 8 years ago | oapaydin
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignor ed until end of transaction block
  6. 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
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: relation "ANALYZERDS" 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:1548)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236)
    6 frames
  3. Commons DBCP
    DelegatingStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
    1 frame
  4. mondrian.rolap
    RolapUtil.executeQuery
    1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:152)
    2. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230)
    3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189)
    3 frames
  5. mondrian.rolap.agg
    AggregationManager.loadAggregation
    1. mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:381)
    2. mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:110)
    3. mondrian.rolap.agg.Aggregation.load(Aggregation.java:172)
    4. mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:96)
    4 frames
  6. mondrian.rolap
    RolapConnection.execute
    1. mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:495)
    2. mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:430)
    3. mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:206)
    4. mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:187)
    5. mondrian.rolap.RolapResult.executeBody(RolapResult.java:803)
    6. mondrian.rolap.RolapResult.<init>(RolapResult.java:417)
    7. mondrian.rolap.RolapConnection.execute(RolapConnection.java:593)
    7 frames
  7. com.pentaho.analyzer
    ReportRequestService$c.call
    1. com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:285)
    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$c.bk(SourceFile:250)
    7. com.pentaho.analyzer.report.ReportRequestService$c.call(SourceFile:240)
    7 frames
  8. 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