SQL error column "s.vstream_id" must appear in the GROUP BY clause

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • Component/s: SolarQuery
    • None

      Got an exception with this API call:

      /solarquery/api/v1/sec/datum/list?nodeId=497&sourceId=EM/apt/&combiningType=Sum&sourceIdMaps=Sum:EM/apt/&startDate=2022-10-17T08:55&endDate=2023-10-17T08:56&aggregation=Week&withoutTotalResultsCount=true&max=1000

       

      The stacktrace was:

      ERROR: column "s.vstream_id" must appear in the GROUP BY clause or be used in an aggregate function
  Position: 753
	at net.solarnetwork.central.common.dao.jdbc.sql.CommonJdbcUtils.executeFilterQuery(CommonJdbcUtils.java:165) ~[solarnet-common-1.17.0.jar:1.17.0]
	at net.solarnetwork.central.datum.v2.dao.jdbc.JdbcDatumEntityDao.findFiltered(JdbcDatumEntityDao.java:379) ~[solarnet-datum-1.14.0.jar:1.14.0]
	at net.solarnetwork.central.datum.v2.dao.DatumEntityDao.findFiltered(DatumEntityDao.java:69) ~[solarnet-datum-1.14.0.jar:1.14.0]
	at net.solarnetwork.central.query.biz.dao.DaoQueryBiz$$EnhancerBySpringCGLIB$$4ecadeef.findFilteredAggregateGeneralNodeDatum(<generated>) ~[classes/:1.9.0]
	at net.solarnetwork.central.query.web.api.DatumController.filterGeneralDatumData(DatumController.java:101) ~[classes/:1.9.0]

            Assignee:
            Matt Magoffin
            Reporter:
            Matt Magoffin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: