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

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

      • 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.

            kkuzmina Katerina Kuzmina (Inactive)
            neogan Andrei Gushchin (Inactive)
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: