XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 4.0.0
    • None
    • None

      Steps to reproduce:

      1. Database Oracle 11.2.04
        After upgrading from version 3.2 to version 4.0, errors appeared.

      Result:

       1353:20181011:155153.215 [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=26145388 group by e.eventid order by e.eventid]
       1352:20181011:155153.226 [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=26145388 group by e.eventid order by e.eventid]
       1357:20181011:155153.290 [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=26145390 group by e.eventid order by e.eventid]
       1358:20181011:155153.298 [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=26145391 group by e.eventid order by e.eventid]
       1362:20181011:155153.303 [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=26145394 group by e.eventid order by e.eventid]
       1355:20181011:155153.330 [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=26145389 group by e.eventid order by e.eventid]
       1356:20181011:155153.341 [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=26145390 group by e.eventid order by e.eventid]
       1361:20181011:155153.353 [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=26145393 group by e.eventid order by e.eventid]
       1364:20181011:155153.370 [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=26145394 group by e.eventid order by e.eventid]
       1368:20181011:155153.377 [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=26145396 group by e.eventid order by e.eventid]
       1367:20181011:155153.400 [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=26145396 group by e.eventid order by e.eventid]
       1366:20181011:155153.439 [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=26145395 group by e.eventid order by e.eventid]
       1371:20181011:155154.271 [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=26145398 group by e.eventid order by e.eventid]
      

            Unassigned Unassigned
            sergeyxx12xx Sergey Fedorov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: