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

items search/filter returns error with Oracle DB

    Details

      Description

      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]

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: