-
Incident report
-
Resolution: Cannot Reproduce
-
Blocker
-
1.8.5
-
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