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

Impossible to export map from Zabbix on Oracle database

XMLWordPrintable

      If a map contains a image, there is not possible to export it on Oracle database. XML file contains:

      [error] SQL error [ORA-00932: inconsistent datatypes: expected - got BLOB] in [SELECT DISTINCT sm.sysmapid,i.* FROM images i,sysmaps sm,sysmaps_elements se WHERE sm.sysmapid='18' AND sm.sysmapid=se.sysmapid AND (se.iconid_off=i.imageid OR se.iconid_on=i.imageid OR se.iconid_disabled=i.imageid OR se.iconid_maintenance=i.imageid OR sm.backgroundid=i.imageid)]

      [error] oci_fetch_assoc(): ORA-24374: define not done before fetch or execute and fetch [sysmaps.php:109 ? CConfigurationExport->export() ? CConfigurationExport->gatherData() ? CConfigurationExport->gatherMaps() ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CImage->get() ? DBfetch() ? oci_fetch_assoc() in /srv/www/htdocs/include/db.inc.php:589]

            iivs Ivo Kurzemnieks
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: