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]

Pentaho BI Platform Tracking | Jem Matzan | 7 years ago
  1. 0

    Instead of showing the error message below, I would rather have something like this... Bad Query: Not in aggregate function or group by clause org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:468) 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) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: 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.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:138) 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) ParentException: 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)

    Pentaho BI Platform Tracking | 7 years ago | Jem Matzan
    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]
  2. 0

    Instead of showing the error message below, I would rather have something like this... Bad Query: Not in aggregate function or group by clause org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:468) 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) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: 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.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:138) 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) ParentException: 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)

    Pentaho BI Platform Tracking | 7 years ago | Jem Matzan
    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]
  3. 0

    HSQLDB + JUnit + Hibernate: java.sql.SQLException: invalid schema name

    Stack Overflow | 2 years ago
    java.sql.SQLException: invalid schema name: SRH in statement [select liquidacio0_.idLiquidacion as idLiquid1_180_0_, liquidacio0_.fkEstado as fkEstado180_0_, liquidacio0_.FECHA_LIQ as FECHA3_180_0_, liquidacio0_.DIAS_LIQUIDAR as DIAS4_180_0_, liquidacio0_.MES_DIAS as MES5_180_0_, liquidacio0_.MES_LIQUIDACION as MES6_180_0_, liquidacio0_.LIQUIDACION_TVAC as LIQUIDAC7_180_0_, liquidacio0_.FECHA_ESTADO as FECHA8_180_0_, liquidacio0_.fkSolicitud as fkSolici9_180_0_, liquidacio0_.idTvac as idTvac180_0_, liquidacio0_.NUMLIQ as NUMLIQ180_0_, liquidacio0_.legajo as legajo180_0_, liquidacio0_.periodo as periodo180_0_ from srh.srh_liquidacion liquidacio0_ where liquidacio0_.idLiquidacion=?]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    NetBeans Forums - JPA, Hibernate, HSQL and Remote Access. Please Help.

    netbeans.org | 1 year ago
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    Grails User (Old Archive) - ERROR context.GrailsContextLoader - Error executing bootstraps: Error creating bean with name 'messageSource'

    nabble.com | 1 year ago
    java.sql.SQLException: Table not found in statement [insert into > jsec_user (id, version, password_hash, username) values (null, ?, ?, ?)]

    8 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

      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()
    2. HSQLDB
      jdbcConnection.prepareStatement
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      3. org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      3 frames
    3. org.pentaho.reporting
      Worker.run
      1. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:160)
      2. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:134)
      3. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
      4. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88)
      5. org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168)
      6. org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143)
      7. org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81)
      8. org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
      9. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185)
      10. org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:255)
      11. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:375)
      12. org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77)
      13. org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:261)
      14. org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)
      14 frames