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

items search/filter returns error with Oracle DB

XMLWordPrintable

      When I navigate to Hosts -> items (of one of hosts) and there I use filter:

      • Host group:

      ociexecute(): ORA-00918: column ambiguously defined [include/db.inc.php:446]
      SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT DISTINCT i.*,g.name FROM items i,groups g,hosts_groups hg WHERE i.type<>9 AND ( (i.flags IN ('0','4')) ) AND g.groupid = hg.groupid AND hg.hostid=i.hostid AND UPPER(g.name)='SSW1_T1' AND i.itemid BETWEEN 000000000000000 AND 099999999999999 ORDER BY i.status) WHERE rownum BETWEEN 0 AND 2001]
      ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:579]

      when I use filter:

      • Host group:
      • Name like:

      ociexecute(): ORA-00918: column ambiguously defined [include/db.inc.php:446]
      SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT DISTINCT i.*,g.name FROM items i,groups g,hosts_groups hg WHERE i.type<>9 AND ( UPPER(i.name) LIKE '%SDFS%' ESCAPE '!' ) AND ( (i.flags IN ('0','4')) ) AND g.groupid = hg.groupid AND hg.hostid=i.hostid AND UPPER(g.name)='SSW1_T1' AND i.itemid BETWEEN 000000000000000 AND 099999999999999 ORDER BY i.status) WHERE rownum BETWEEN 0 AND 2001]
      ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:579]

            Unassigned Unassigned
            olgierdw Olgierd Wolodkiewicz
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: