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

Solutions on the web

via Pentaho BI Platform Tracking by Jared Pshedesky, 1 year ago
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
via Pentaho BI Platform Tracking by Jared Pshedesky, 1 year ago
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
via Pentaho BI Platform Tracking by Golda David, 1 year ago
Not in aggregate function or group by clause: org.hsqldb.Expression@150bd4d in statement [select REGION, sum(ACTUAL) from QUADRANT_ACTUALS group by REGION order by ACTUAL]
via Pentaho BI Platform Tracking by Golda David, 1 year ago
Not in aggregate function or group by clause: org.hsqldb.Expression@150bd4d in statement [select REGION, sum(ACTUAL) from QUADRANT_ACTUALS group by REGION order by ACTUAL]
via Pentaho BI Platform Tracking by Michael Tarallo, 1 year ago
Column not found: NULL.QUANTITYORDERED in statement [SELECT BT_CUSTOMER_W_TER_CUSTOMER_W_TER.COUNTRY AS COL0 ,BT_CUSTOMER_W_TER_CUSTOMER_W_TER.CUSTOMERNAME AS COL1 , SUM( null.QUANTITYORDERED * null.PRICEEACH ) AS COL2
via runawfe by doudou00225
, 1 year ago
Table already exists: JBM\_DUAL in statement
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)