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 Jem Matzan, 1 year ago
Not in aggregate function or group by clause: org.hsqldb.Expression@1cac6db in statement [SELECT "ORDERFACT"."QUANTITYORDERED", "ORDERFACT"."PRICEEACH", "ORDERFACT"."ORDERLINENUMBER", "ORDERFACT"."TOTALPRICE", "ORDERFACT
via Pentaho BI Platform Tracking by Jem Matzan, 1 year ago
Not in aggregate function or group by clause: org.hsqldb.Expression@1cac6db in statement [SELECT "ORDERFACT"."QUANTITYORDERED", "ORDERFACT"."PRICEEACH", "ORDERFACT"."ORDERLINENUMBER", "ORDERFACT"."TOTALPRICE", "ORDERFACT
via ctakes-user by Stuti Awasthi, 1 year ago
Table not found in statement [SELECT * FROM long WHERE CUI = ?]
via ctakes-user by Geise, Brandon D., 6 months ago
Table not found in statement [SELECT * FROM long WHERE CUI = ?]
via ctakes-user by Stuti Awasthi, 6 months ago
Table not found in statement [SELECT * FROM long WHERE CUI = ?]
via ctakes-user by Geise, Brandon D., 1 year ago
Table not found in statement [SELECT * FROM long WHERE CUI = ?]
java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@1cac6db in statement [SELECT
     "ORDERFACT"."QUANTITYORDERED",
     "ORDERFACT"."PRICEEACH",
     "ORDERFACT"."ORDERLINENUMBER",
     "ORDERFACT"."TOTALPRICE",
     "ORDERFACT"."SHIPPEDDATE",
     "ORDERFACT"."STATUS",
     "PRODUCTS"."PRODUCTNAME",
     "PRODUCTS"."PRODUCTCODE",
     "ORDERFACT"."PRODUCTCODE",
     "PRODUCTS"."PRODUCTLINE"
FROM
     "PRODUCTS" INNER JOIN "ORDERFACT" ON "PRODUCTS"."PRODUCTCODE" = "ORDERFACT"."PRODUCTCODE"
WHERE
     "ORDERFACT"."STATUS" <> 'Shipped'
 AND "PRODUCTS"."PRODUCTLINE" = 'Ships'
GROUP BY
     "ORDERFACT"."STATUS"
ORDER BY
     "ORDERFACT"."STATUS" ASC]	at org.hsqldb.jdbc.Util.throwError(Unknown Source)	at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)	at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:160)	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:134)	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)	at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88)	at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168)	at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143)	at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81)	at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)	at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185)	at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.(ProcessState.java:255)	at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:375)	at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77)	at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:261)	at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)