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

ORA-00979: not a GROUP BY expression

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: