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

Zabbix cannot store alert message on Oracle : query failed:[-1] ORA-01704: string literal too long

XMLWordPrintable

      Zabbix cannot store alert message on Oracle if the alert mesage is long. Escalator process retry inserting the alert every 3 seconds.
      This happenes if alert setting has

      {ITEM.VALUE}

      macro for log item.

      Error message on zabbix_server.log:

      query failed:[-1] ORA-01704: string literal too long [insert into alerts (alertid, actionid, ...

      message column in alerts table is nvarchar2(2048) on Oracle.

            Unassigned Unassigned
            kodai Kodai Terashima
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: