java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"]

Pentaho BI Platform Tracking | Farrell Wilson | 7 years ago
  1. 0

    working through the getting started guide page 30 in the pdf... ... 3. Drag the COUNTRY field from the Field list on the left onto the report. ... when I try the previous step, I get the following exception... btw my table name is sales_data2 NOT sales_data java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.px.yf(SourceFile:255) at com.pentaho.analyzer.content.a.yl.ab(SourceFile:207) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:145) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:256) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:79) 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.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:96) 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:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:157) ... 62 more Caused by: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:289) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:293) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:352) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:81) at com.pentaho.analyzer.report.ReportRequestService$mc.f(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:241) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:373) at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:519) at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:478) at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:466) at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:146) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:658) at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:476) at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:462) at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getLevelMembers(RolapCube.java:2630) at mondrian.olap.DelegatingSchemaReader.getLevelMembers(DelegatingSchemaReader.java:154) at mondrian.olap.Query$QuerySchemaReader.getLevelMembers(Query.java:1423) at mondrian.olap.fun.FunUtil.getNonEmptyLevelMembers(FunUtil.java:2065) at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2073) at mondrian.olap.fun.LevelMembersFunDef$1.evaluateMemberList(LevelMembersFunDef.java:43) at mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:173) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.olap.fun.OrderFunDef$MemberCalcImpl.evaluateMemberList(OrderFunDef.java:199) at mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540) at mondrian.rolap.RolapResult.(RolapResult.java:273) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:604) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:281) ... 11 more

    Pentaho BI Platform Tracking | 7 years ago | Farrell Wilson
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"]
  2. 0

    working through the getting started guide page 30 in the pdf... ... 3. Drag the COUNTRY field from the Field list on the left onto the report. ... when I try the previous step, I get the following exception... btw my table name is sales_data2 NOT sales_data java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199) at com.pentaho.analyzer.content.a.px.yf(SourceFile:255) at com.pentaho.analyzer.content.a.yl.ab(SourceFile:207) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:145) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:256) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:79) 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.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:96) 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:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:157) ... 62 more Caused by: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:289) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:293) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:352) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:81) at com.pentaho.analyzer.report.ReportRequestService$mc.f(SourceFile:250) at com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:241) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:373) at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:519) at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:478) at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:466) at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:146) at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:658) at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:476) at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:462) at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getLevelMembers(RolapCube.java:2630) at mondrian.olap.DelegatingSchemaReader.getLevelMembers(DelegatingSchemaReader.java:154) at mondrian.olap.Query$QuerySchemaReader.getLevelMembers(Query.java:1423) at mondrian.olap.fun.FunUtil.getNonEmptyLevelMembers(FunUtil.java:2065) at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2073) at mondrian.olap.fun.LevelMembersFunDef$1.evaluateMemberList(LevelMembersFunDef.java:43) at mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:173) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:71) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.olap.fun.OrderFunDef$MemberCalcImpl.evaluateMemberList(OrderFunDef.java:199) at mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136) at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64) at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122) at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540) at mondrian.rolap.RolapResult.(RolapResult.java:273) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:604) at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:281) ... 11 more

    Pentaho BI Platform Tracking | 7 years ago | Farrell Wilson
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"]
  3. 0

    how to resolve java.sql.SQLException: Table not found in statement

    Stack Overflow | 4 years ago | user1551750
    java.sql.SQLException: Table not found in statement [select * from "PUBLIC"."xxx"]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Connect to Open Office odb file using jdbc program

    Stack Overflow | 5 years ago | Harshavardhan Konakanchi
    java.sql.SQLException: Table not found in statement [SELECT * FROM Emp]
  6. 0

    HSQLDB issue: Using HSQL as backend for the existing MVC application using JDBC template

    Stack Overflow | 5 years ago | AbdulAziz
    java.sql.SQLException: Table not found in statement [select id, description, price from products]

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Table not found in statement [select "sales_data2"."COUNTRY" as "c0" from "sales_data2"]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.executeQuery
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
      3 frames
    3. mondrian.rolap
      RolapCube$RolapCubeSchemaReader.getLevelMembers
      1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:142)
      2. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:241)
      3. mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:373)
      4. mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:519)
      5. mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:478)
      6. mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:466)
      7. mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:146)
      8. mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:658)
      9. mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:476)
      10. mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:462)
      11. mondrian.rolap.RolapCube$RolapCubeSchemaReader.getLevelMembers(RolapCube.java:2630)
      11 frames
    4. mondrian.olap
      Query$QuerySchemaReader.getLevelMembers
      1. mondrian.olap.DelegatingSchemaReader.getLevelMembers(DelegatingSchemaReader.java:154)
      2. mondrian.olap.Query$QuerySchemaReader.getLevelMembers(Query.java:1423)
      2 frames
    5. mondrian.olap.fun
      LevelMembersFunDef$1.evaluateMemberList
      1. mondrian.olap.fun.FunUtil.getNonEmptyLevelMembers(FunUtil.java:2065)
      2. mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2073)
      3. mondrian.olap.fun.LevelMembersFunDef$1.evaluateMemberList(LevelMembersFunDef.java:43)
      3 frames
    6. mondrian.calc.impl
      AbstractMemberListCalc.evaluate
      1. mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71)
      1 frame
    7. mondrian.rolap
      RolapNamedSetEvaluator.evaluateMemberIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
      3 frames
    8. mondrian.mdx
      NamedSetExpr$2.evaluateMemberIterable
      1. mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
      1 frame
    9. mondrian.calc.impl
      AbstractMemberIterCalc.evaluate
      1. mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52)
      1 frame
    10. mondrian.rolap
      RolapNamedSetEvaluator.evaluateMemberIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
      3 frames
    11. mondrian.mdx
      NamedSetExpr$2.evaluateMemberIterable
      1. mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
      1 frame
    12. mondrian.olap.fun
      GenerateFunDef$GenerateListCalcImpl.evaluateList
      1. mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:173)
      1 frame
    13. mondrian.calc.impl
      AbstractListCalc.evaluate
      1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:71)
      1 frame
    14. mondrian.rolap
      RolapNamedSetEvaluator.evaluateMemberIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
      3 frames
    15. mondrian.mdx
      NamedSetExpr$2.evaluateMemberIterable
      1. mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
      1 frame
    16. mondrian.olap.fun
      OrderFunDef$MemberCalcImpl.evaluateMemberList
      1. mondrian.olap.fun.OrderFunDef$MemberCalcImpl.evaluateMemberList(OrderFunDef.java:199)
      1 frame
    17. mondrian.calc.impl
      AbstractMemberListCalc.evaluate
      1. mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71)
      1 frame
    18. mondrian.rolap
      RolapNamedSetEvaluator.evaluateMemberIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:851)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:136)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
      3 frames
    19. mondrian.mdx
      NamedSetExpr$2.evaluateMemberIterable
      1. mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
      1 frame
    20. mondrian.calc.impl
      AbstractMemberIterCalc.evaluate
      1. mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52)
      1 frame
    21. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:731)
      2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:574)
      3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:540)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:273)
      5. mondrian.rolap.RolapConnection.execute(RolapConnection.java:604)
      5 frames
    22. com.pentaho.analyzer
      ReportRequestService$mc.call
      1. com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:281)
      2. com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:293)
      3. com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:352)
      4. com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110)
      5. com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:81)
      6. com.pentaho.analyzer.report.ReportRequestService$mc.f(SourceFile:250)
      7. com.pentaho.analyzer.report.ReportRequestService$mc.call(SourceFile:240)
      7 frames
    23. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      2. java.util.concurrent.FutureTask.run(Unknown Source)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      5. java.lang.Thread.run(Unknown Source)
      5 frames