-
Incident report
-
Resolution: Fixed
-
Trivial
-
2.0.4
-
Oracle 11.2.0.3, Debian 6
I got a lot of such errors in server.log
10657:20130226:150516.525 evaluate_expressions():expression [4,09666666666666666666>80] cannot be evaluated: Format error or unsupporte d operator. Exp: [4,09666666666666666666] 10657:20130226:150516.525 End of evaluate_expressions() 10657:20130226:150516.525 query [txnlev:1] [begin update triggers set error='Format error or unsupported operator. Exp: [4,09666666666666666666]' where triggerid=13524; end; ]
SQL> show parameter nls_numeric_characters; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ nls_numeric_characters string , SQL> select expression,error from ais_zabbix.triggers where triggerid=13524; EXPRESSION -------------------------------------------------------------------------------- ERROR ----------------------------------------------------------------- {18631}>80 Format error or unsupported operator. Exp: [2,94866666666666666666] SQL> select itemid from ais_zabbix.functions where functionid=18631; ITEMID ---------- 23345 SQL> select type,lastvalue,prevvalue,value_type from ais_zabbix.items where itemid=23342; TYPE ---------- LASTVALUE -------------------------------------------------------------------------------- PREVVALUE -------------------------------------------------------------------------------- VALUE_TYPE ---------- 15 4.760000 4.760000 0
maybe this issue links with ZBX-5691, i'm not shure, because LASTVALUE and PREVVALUE types are NVARCHAR2(255)