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

Error on Discovery rule with Oracle BackEnd

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 4.4.0alpha1, 4.4.0alpha2
    • Frontend (F)
    • RedHat 7.5 , Oracle 18c

      Open any discovery rule configuration page cause the following error :

      • SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT DISTINCT ir.*,i.* FROM items i LEFT JOIN item_rtdata ir ON ir.itemid = i.itemid WHERE i.flags=1 AND i.hostid=10263 ORDER BY i.name) WHERE rownum BETWEEN 0 AND 1001]
      • oci_fetch_assoc(): ORA-24374: define not done before fetch or execute and fetch [host_discovery.php:759 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → DBfetch() → oci_fetch_assoc() in include/db.inc.php:560]

      Result:
      See screenshot...

            ematuls Eduards Matuls (Inactive)
            anicotra Antonino
            Votes:
            4 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: