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

oracle db faulty statements

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.9.6 (beta)
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      zabbix server 1.9.6, redhat, oracle-db 11.2 on solaris, php 5.1

      Description

      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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: