-
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)