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

Wrong query on Monitoring->IT Services page for Oracle DB

    XMLWordPrintable

    Details

      Description

      One regression has been found:

      SQL error [ORA-00907: missing right parenthesis] in [SELECT sa.serviceid,sa.value FROM (SELECT MAX(sa3.servicealarmid) AS servicealarmid FROM (SELECT sa2.serviceid,MAX(sa2.clock) AS clock FROM service_alarms sa2 WHERE sa2.clock<'1360225390' AND (sa2.serviceid BETWEEN '11' AND '15' OR sa2.serviceid BETWEEN '20' AND '28' OR sa2.serviceid BETWEEN '30' AND '36' OR sa2.serviceid BETWEEN '43' AND '53' OR sa2.serviceid IN ('37','2','5','6','9','29','38','39','42','41')) GROUP BY sa2.serviceid) AS ss JOIN service_alarms sa3 ON sa3.serviceid = ss.serviceid and sa3.clock = ss.clock GROUP BY sa3.serviceid) AS ss2 JOIN service_alarms sa ON sa.servicealarmid = ss2.servicealarmid]
      ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:582]
      

      Oracle does not support "AS" keyword for subqueries. So this query should be different for Oracle and other databases.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: