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

oracle db faulty statements

    XMLWordPrintable

Details

    • Incident report
    • Resolution: Duplicate
    • Major
    • None
    • 1.9.6 (beta)
    • Frontend (F)
    • 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

        1. ora-statement.png
          48 kB
          matthias zeilinger

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: