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

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

            Dates

              Created:
              Updated:
              Resolved: