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

Importing a template that updates an existing, yields oracle errors

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Blocker Blocker
    • 1.8.9
    • 1.8.5
    • Frontend (F)
    • Oracle 10g2 server, oracle 11g2 cliens

      When re-importing an existing template, oracle errors are generated for the item update queries. Queries:
      SQL error [ORA-00936: missing expression] in [UPDATE items SET description='ping',key_='icmpping',hostid=10166,delay=300,history=7,type=3,snmp_community='',snmp_oid='',value_type=3,data_type=0,trapper_hosts='',snmp_port=161,units='',multiplier=0,delta=0,snmpv3_securityname='',snmpv3_securitylevel=,snmpv3_authpassphrase='',snmpv3_privpassphrase='',formula='',trends=365,logtimefmt='',valuemapid=0,delay_flex='',params='',ipmi_sensor='',templateid=85208,authtype=0,username='',password='',publickey='',privatekey='' WHERE itemid=81794]

      here, the following is wrong: snmpv3_securitylevel=

      this an integer, NOT NULL column in the database, that means it MUST have a value, which the zabbix fronted omits.

      Fix: add the securitylevel to the query when updating an item

            Unassigned Unassigned
            phoemix Gergely Czuczy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: