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.

            Assignee:
            Unassigned
            Reporter:
            Ingus Vilnis
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: