java.sql.SQLException: Tabella non trovata in statement [select sequence_name fr om user_sequences]

openejb-users | Paolo Spadafora | 8 years ago
  1. 0

    datasource problem with hibernate and oracle

    openejb-users | 8 years ago | Paolo Spadafora
    java.sql.SQLException: Tabella non trovata in statement [select sequence_name fr om user_sequences]
  2. 0

    datasource problem with hibernate and oracle

    openejb-users | 8 years ago | Paolo Spadafora
    java.sql.SQLException: Tabella non trovata in statement [select sequence_name fr om user_sequences]
  3. 0

    Steps: 1. Create a new analyzer report using SteelWheels 2. Select any fields and measure. Such as Country and Sales BUG: Get Java error: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Column not found: ORDERFACT.TOTALPRICE in statement [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "CUSTOMER_W_TER"."COUNTRY" as "c1" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER" group by "CUSTOMER_W_TER"."TERRITORY", "CUSTOMER_W_TER"."COUNTRY" having NOT((sum("ORDERFACT"."TOTALPRICE") is null)) order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC, CASE WHEN "CUSTOMER_W_TER"."COUNTRY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."COUNTRY" ASC] at com.pentaho.analyzer.report.ReportRequestService.get(ReportRequestService.java:216) at com.pentaho.analyzer.content.controller.ReportRunner.getResult(ReportRunner.java:282) at com.pentaho.analyzer.content.controller.AjaxBean.getReportHTML(AjaxBean.java:182) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(AnalyzerContentGenerator.java:199) at sun.reflect.GeneratedMethodAccessor125.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.WebSpringPentahoObjectFactory$ProxyInvokeHandler.invoke(WebSpringPentahoObjectFactory.java:288) at $Proxy16.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:117) 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(SystemStatusFilter.java:72) 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:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Column not found: ORDERFACT.TOTALPRICE in statement [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "CUSTOMER_W_TER"."COUNTRY" as "c1" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER" group by "CUSTOMER_W_TER"."TERRITORY", "CUSTOMER_W_TER"."COUNTRY" having NOT((sum("ORDERFACT"."TOTALPRICE") is null)) order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC, CASE WHEN "CUSTOMER_W_TER"."COUNTRY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."COUNTRY" ASC] 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(ReportRequestService.java:174) ... 72 more Caused by: java.lang.RuntimeException: java.sql.SQLException: Column not found: ORDERFACT.TOTALPRICE in statement [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "CUSTOMER_W_TER"."COUNTRY" as "c1" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER" group by "CUSTOMER_W_TER"."TERRITORY", "CUSTOMER_W_TER"."COUNTRY" having NOT((sum("ORDERFACT"."TOTALPRICE") is null)) order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC, CASE WHEN "CUSTOMER_W_TER"."COUNTRY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."COUNTRY" ASC] at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(AnalysisAreaManager.java:299) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(ReportManagerImpl.java:298) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(ReportManagerImpl.java:358) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:122) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:93) at com.pentaho.analyzer.report.ReportRequestService$2.call(ReportRequestService.java:268) at com.pentaho.analyzer.report.ReportRequestService$2.call(ReportRequestService.java:258) 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: java.sql.SQLException: Column not found: ORDERFACT.TOTALPRICE in statement [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "CUSTOMER_W_TER"."COUNTRY" as "c1" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER" group by "CUSTOMER_W_TER"."TERRITORY", "CUSTOMER_W_TER"."COUNTRY" having NOT((sum("ORDERFACT"."TOTALPRICE") is null)) order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC, CASE WHEN "CUSTOMER_W_TER"."COUNTRY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."COUNTRY" ASC] 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 org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:180) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:332) at mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:76) at mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:133) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:233) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:176) at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:118) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:913) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:109) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:913) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:201) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:913) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:811) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:642) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:598) at mondrian.rolap.RolapResult.<init>(RolapResult.java:286) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630)

    Pentaho BI Platform Tracking | 4 years ago | Sarah Moursalien
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Column not found: ORDERFACT.TOTALPRICE in statement [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "CUSTOMER_W_TER"."COUNTRY" as "c1" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER" group by "CUSTOMER_W_TER"."TERRITORY", "CUSTOMER_W_TER"."COUNTRY" having NOT((sum("ORDERFACT"."TOTALPRICE") is null)) order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC, CASE WHEN "CUSTOMER_W_TER"."COUNTRY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."COUNTRY" ASC]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 0

    Running sales_overtime.xaction sample in the SteelWheels dashboards samples yields the error below, and exceptions below that. Failed Error: SQLBaseComponent.ERROR_0006 - Could not execute sales_overtime.xaction - java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAILS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))] (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Starting execute of samples/steel-wheels/dashboards/sales_overtime.xaction (com.pentaho.core.solution.ProSolutionEngine) Debug: Getting runtime context and data (com.pentaho.core.solution.ProSolutionEngine) Debug: Loading action sequence definition file (com.pentaho.core.solution.ProSolutionEngine) Debug: audit: instanceId=5ac39360-8a7b-11dd-bed1-197b80496e7f, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.RuntimeContext) Error: SQLBaseComponent.ERROR_0006 - Could not execute sales_overtime.xaction - java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAILS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))] (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Error: RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext) Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (com.pentaho.core.solution.ProSolutionEngine) Server Version: Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 Exceptions: 16:59:11,248 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 16:59:11,248 ERROR [SQLLookupRule] a2f812a1-8a7b-11dd-bed1-197b80496e7f:COMPONENT:context-3994571-1222289951076:sales_overtime.xactionSQLBaseComponent.ERROR_0006 - Could not execute sales_overtime.xac tion java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAI LS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))] 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 org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:294) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:266) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:597) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:538) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:241) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95) at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159) at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:141) at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:268) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) 16:59:11,264 ERROR [SQLLookupRule] Error end: 16:59:11,264 ERROR [RuntimeContext] a2f812a1-8a7b-11dd-bed1-197b80496e7f:RUNTIME:context-3994571-1222289951076:sales_overtime.xaction RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully 16:59:11,311 ERROR [ProSolutionEngine] a2f812a1-8a7b-11dd-bed1-197b80496e7f:SOLUTION-ENGINE:sales_overtime.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

    Pentaho BI Platform Tracking | 8 years ago | Jared Pshedesky
    java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAI LS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))]

    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

      Tabella non trovata in statement [select sequence_name fr om user_sequences]

      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. Commons DBCP
      DelegatingStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      2. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      2 frames
    4. Hibernate
      SchemaUpdate.execute
      1. org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:128)
      2. org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:46)
      3. org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:39)
      4. org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:129)
      4 frames
    5. Hibernate
      SessionFactoryImpl.<init>
      1. org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
      1 frame
    6. Hibernate
      AnnotationConfiguration.buildSessionFactory
      1. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300)
      2. org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
      2 frames
    7. Hibernate EJB
      HibernatePersistence.createContainerEntityManagerFactory
      1. org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
      2. org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132)
      2 frames
    8. OpenEJB :: OSGi :: Core
      OpenEJB.init
      1. org.apache.openejb.assembler.classic.PersistenceBuilder.createEntityManagerFactory(PersistenceBuilder.java:183)
      2. org.apache.openejb.assembler.classic.Assembler.createApplication(Assembler.java:487)
      3. org.apache.openejb.assembler.classic.Assembler.createApplication(Assembler.java:447)
      4. org.apache.openejb.assembler.classic.Assembler.buildContainerSystem(Assembler.java:365)
      5. org.apache.openejb.assembler.classic.Assembler.build(Assembler.java:277)
      6. org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:150)
      7. org.apache.openejb.OpenEJB.init(OpenEJB.java:299)
      7 frames
    9. OpenEJB :: Assembly :: Tomcat :: Catalina
      TomcatLoader.init
      1. org.apache.openejb.tomcat.catalina.TomcatLoader.init(TomcatLoader.java:121)
      1 frame