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

IBM DB2 error "Value is too long" for message field in alerts table

XMLWordPrintable

      IBM DB2 error when trying to insert long text in message field in alerts table.

         993:20151112:183728.751 [Z3005] query failed: [-433] 22001 [IBM][CLI Driver][DB2/LINUXX8664] SQL0433N  Value "2015.11.12 09:33:02 New message in file /var/log/websphere/i" is too long.  SQLSTATE=22001 [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype) values (8862248,103,3907367,64,1447346248,1,'[email protected]','Websphere iApi: PROBLEM (New message in file /var/log/websphere/iapi_clsrv2.log.2015-11-12)','...Long log message with some text data here...',0,'',1,0);]

      In such case entries are not stored in alerts table thus no messages are sent to recipients when corresponding trigger is fired.

            Unassigned Unassigned
            ingus.vilnis Ingus Vilnis
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: