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

oracle db faulty statements

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 1.9.6 (beta)
    • Frontend (F)
    • zabbix server 1.9.6, redhat, oracle-db 11.2 on solaris, php 5.1

      if i want to select the itemlist in the web-frontend, i get the following error:
      • ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00932: inconsistent datatypes: expected - got NCLOB [include/db.inc.php:458]
      • SQL error [ORA-00932: inconsistent datatypes: expected - got NCLOB] in [SELECT DISTINCT i.*,hg.groupid FROM items i,hosts_groups hg WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND (i.hostid IN ('10017')) AND (hg.groupid IN ('4')) AND hg.hostid=i.hostid AND ( (i.flags IN ('0','4')) )]
      • ocifetchinto() [<a href='function.ocifetchinto'>function.ocifetchinto</a>]: ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:606]

      attached the screenshot

            Unassigned Unassigned
            zychonatic matthias zeilinger
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: