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

Evalution of expressions error. cannot be evaluated: Format error or unsupported operator. Possibly bug with NLS charset between digits.

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 2.0.6rc1, 2.1.0
    • 2.0.4
    • Server (S)
    • 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)

            Unassigned Unassigned
            netflash Alexander Romanov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: