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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.8.5
    • Fix Version/s: 1.8.9
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Oracle 10g2 server, oracle 11g2 cliens

      Description

      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

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: