XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Critical
    • Resolution: Duplicate
    • 4.0.0
    • None
    • None
    • None

    Description

      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]
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: