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

ORACLE Alert message params limited to 2048 characters

    XMLWordPrintable

Details

    • Documentation task
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 4.0.39, 5.0.20
    • 6.2 (plan)
    • Server (S)
    • None
    • Team B
    • Sprint 86 (Mar 2022), Sprint 87 (Apr 2022), Sprint 88 (May 2022)
    • 0.1

    Description

      • have some webhook with many parameters to send some payload about problem
      • while inserting this message to alerts table
      • message might be truncated with ORACLE database as in DB schema parameters field has NVARCHAR2(2048) type.
      • so when we generate some JSON to send this might broke message structure completely.

      Result:
      message has failed to send

      Expected:
      Ideally write this to zabbix server log as this very hard to investigate

      at least we should put some note about this limitation for oracle.
      Maybe this note should be added to https://www.zabbix.com/documentation/5.0/en/manual/config/notifications/action/operation/message

      Zabbix 6.0 this limitation was fixed by changing type of DB field with ZBX-20420.

      Attachments

        Issue Links

          Activity

            People

              kkuzmina Katerina Kuzmina
              neogan Andrei Gushchin
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: