[ZBX-5510] items search/filter returns error with Oracle DB Created: 2012 Aug 29  Updated: 2017 May 30  Resolved: 2012 Aug 31

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.0.2
Fix Version/s: 2.0.3rc1, 2.1.0

Type: Incident report Priority: Major
Reporter: Olgierd Wolodkiewicz Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: database, items, oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

RHEL + Oracle 11g2



 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]



 Comments   
Comment by Alexander Vladishev [ 2012 Aug 30 ]

I confirm in latest 2.0 r29943.

Comment by Eduards Samersovs (Inactive) [ 2012 Aug 31 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-5510

Comment by Eduards Samersovs (Inactive) [ 2012 Sep 04 ]

Fixed in versions pre-2.1.0 (beta) r30087, pre-2.0.3 r30086

Generated at Fri Apr 26 07:01:57 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.