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

ORA-12899: value too large for column "ALERTS"."MESSAGE" when item is eventlog[] and item value is added in notification

    XMLWordPrintable

Details

    Description

      We have many trigger that checks about event viewer events. When error is found in event viewer a mail is sent with content of error. Message is:

      Trigger name:

      {TRIGGER.NAME}

      Trigger status:

      {TRIGGER.STATUS}

      Trigger severity:

      {TRIGGER.SEVERITY}

      Check:

      {ITEM.NAME1}


      Type:

      {ITEM.KEY1}


      Value:

      {ITEM.VALUE1}

      contains all the event viewer message that is bigger then 2000 chars ... This generate an oracle error in zabbix server log complaining about the length of MESSAGE field in the ALERTS table because field is only 2000 CHAR ... we can enlarge field up to 4000 CHAR but this is not enough. ALERTS table must manage also log ITEM!!

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              yayo yayo
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: