[ZBX-5030] Frontend Configuration "IT Services" DB errors Created: 2012 May 21  Updated: 2017 May 30  Resolved: 2012 May 22

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

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

RHEL5.x + Oracle 11

Issue Links:
Duplicate
is duplicated by ZBX-5214 ORA-01791 Closed
is duplicated by ZBX-5211 SQL Error on IT Services with Postgre... Closed

 Description   

If I add any "IT Services" I have errors on Zabbix Frontend Web

ociexecute(): ORA-01791: not a SELECTed expression [include/db.inc.php:439]
SQL error [ORA-01791: not a SELECTed expression] in [SELECT DISTINCT sl.* FROM services_links sl,services s WHERE ( (sl.serviceupid IN ('5')) ) AND sl.linkid BETWEEN 000000000000000 AND 099999999999999 AND sl.servicedownid=s.serviceid ORDER BY s.sortorder, s.serviceid]
ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:570]

 Comments   
Comment by Eduards Samersovs (Inactive) [ 2012 May 22 ]

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

Comment by Toms (Inactive) [ 2012 May 22 ]

TESTED

Comment by Eduards Samersovs (Inactive) [ 2012 May 22 ]

Fixed in versions pre-2.1.0 (beta) r27744, pre-2.0.1 r27741

Generated at Tue May 06 07:41:41 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.