Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15081

ORA-00979: not a GROUP BY expression

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • None
    • 4.0 (plan)
    • Server (S)

      Dear support team,
      Recently we upgraded our Zabbix version from 3.4 to 4.0 and our actions doesn't work due to this error :

      We use Oracle DB 12.2.
      [Z3005] query failed: [-1] ORA-00979: not a GROUP BY expression [select e.eventid,e.source,e.object,e.objectid,e.clock,e.value,e.acknowledged,e.ns,e.name,e.severity,max(es.suppress_until) from events e left join event_suppress es on e.eventid=es.eventid where e.eventid=213324 group by e.eventid order by e.eventid]

      If the problem fixed in Zabbix 4.0.1, how can i download the source ?!

      Best regards,
      Alireza Zabihi

            Unassigned Unassigned
            a.zabihi Alireza Zabihi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: