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]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web12999

  • 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 Pentaho BI Platform Tracking by Sarah Moursalien, 1 year ago
    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
  • Stack trace

    • 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.<init>(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.<init>(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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 6 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 2 years ago
    5 more bugmates