-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
4.4.0alpha1, 4.4.0alpha2
-
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...