Mysql error appears when executing System report with "Disk Size" or "Disk Used" in filter. It works without errors if the report is created in the Admin UI.
mysql error: [1111: Invalid use of group function] in EXECUTE("select * from (SELECT MACHINE.NAME AS SYSTEM_NAME, AVG(MACHINE_DISKS.PERCENT_USED) AS MACHINE_DISKS_PERCENT_USED, GROUP_CONCAT(DISTINCT MACHINE_DISKS.DISK_FREE SEPARATOR '\n') AS MACHINE_DISKS_DISK_FREE_GROUPED, SUM(MACHINE_DISKS.DISK_SIZE) AS MACHINE_DISKS_DISK_SIZE, SUM(MACHINE_DISKS.DISK_USED) AS MACHINE_DISKS_DISK_USED, MACHINE.ID as TOPIC_ID, SUBSTRING("ORG1", 4) AS KORG_ID FROM ORG1.MACHINE MACHINE LEFT JOIN ORG1.MACHINE_DISKS MACHINE_DISKS ON (MACHINE_DISKS.ID = MACHINE.ID) WHERE ((SUM(MACHINE_DISKS.DISK_SIZE) is not null)) GROUP BY MACHINE.ID union SELECT MACHINE.NAME AS SYSTEM_NAME, AVG(MACHINE_DISKS.PERCENT_USED) AS MACHINE_DISKS_PERCENT_USED, GROUP_CONCAT(DISTINCT MACHINE_DISKS.DISK_FREE SEPARATOR '\n') AS MACHINE_DISKS_DISK_FREE_GROUPED, SUM(MACHINE_DISKS.DISK_SIZE) AS MACHINE_DISKS_DISK_SIZE, SUM(MACHINE_DISKS.DISK_USED) AS MACHINE_DISKS_DISK_USED, MACHINE.ID as TOPIC_ID, SUBSTRING("ORG2", 4) AS KORG_ID FROM ORG2.MACHINE MACHINE LEFT JOIN ORG2.MACHINE_DISKS MACHINE_DISKS ON (MACHINE_DISKS.ID = MACHINE.ID) WHERE ((SUM(MACHINE_DISKS.DISK_SIZE) is not null)) GROUP BY MACHINE.ID ) as T order by SYSTEM_NAME")
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center